The level of detail calculations

The level of detail calculations (LOD) enable you to tell Tableau Public at exactly which dimensional level you would like to aggregate without having to place that dimension on the visualization. Additionally, you can include or exclude dimensions in the calculations and create calculations that include all the underlying data.

The following are the three types of LOD calculations:

• FIXED: This computes a value for the dimension that you specify

• INCLUDE: This computes at a dimensional level and is not included in the visualization itself

• EXCLUDE: This excludes a dimension that is a part of the visualization

LOD has a big caveat. While you can perform table calculations on them and create aggregations and functions within them, you cannot include table calculations in them.

A FIXED LOD calculation

Each LOD calculation has the following three features that are different from those that we have discussed before:

• The LOD expression type: In this case, the LOD expression...