LOD Calculations: Dimensions or Measures?
In the previous exercises, when calculating LOD calculations, you have always used a measure to give a numerical output. FIXED
LOD calculations can show results in measures or dimensions, depending on the field used in the expression.
So, MIN ([Order_Date])}
will be a dimension, because [Order_Date]
is a dimension, and {fixed Country: AVG([GDP])}
will be a measure, because [GDP]
is a measure. In contrast, INCLUDE
and EXCLUDE
LOD calculations always show results in measures.
You will now learn how dimensions used in the view affect the LOD calculation's computation.
Aggregation and LOD Calculations
In previous exercises, you computed AVG(Profit)
per Customer
at a Region
level, but did not include Customer
in the view. How did Tableau manage that?
The answer lies in how Tableau handles the level of aggregation. In this section, you will learn about the backend...