Learning Tableau 10 - Second Edition

Level of Detail calculations

Level of Detail calculations (sometimes abbreviated as LoD calcs or LoD expressions) are a special kind of calculation that allow you to perform aggregations at a specified level of detail, which may be different from the level of detail defined in the view, and then work with the resulting value at a row level. In this way, you can think of LoD calculations as a hybrid between Row Level calculations and Aggregate Row Level calculations.

Level of Detail syntax

Level of Detail calculations follow this basic pattern of syntax:

{[TYPE] [Dimension 1],[Dimension 2] : AGG([Measure])} 

The parts of the preceding declaration are as follows:

• TYPE: Is the type of LoD calculation (FIXED, INCLUDE, or EXCLUDE), which are described ...