Practical application

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.

Exercise - practical FIXED

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.

Exercise steps - practical FIXED - the problem

1. Open the workbook associated with this chapter and navigate to the worksheet entitled The Problem.

2. Select the 2012_World_Pop dataset.

3. Create a calculated field named Percent of Total with the following code:

         SUM([Population])...