The first portion of this chapter was designed to demonstrate how LOD calculations work. The remainder will be dedicated to practical applications. Specifically, we will consider three typical challenges that were previously solved using other Tableau capabilities such as table calculations and data blending.
This exercise will look at a problem that occurs when mixing a table calculation that calculates the percentage of the total with a dimension filter. We will consider the problem, a workaround used in previous versions of Tableau, and a solution using an LOD calculation. After covering these three options, a commentary section will discuss the germane points of each.