LEVEL OF DETAIL EXPRESSIONS
With Level of Detail Expressions (often abbreviated LOD), you can manually specify the level of detail at which the aggregation of a calculated field happens, as opposed to having it evaluated at the level defined by the dimensions added to the view.
LOD Calculations share some similarities with Table Calculations, and some problems can be tackled equally well with either of them. But there are also significant differences and many use cases for which only one of the two methods is appropriate. One such difference is that LOD Calculations are calculated directly in the data source, meaning only the aggregated data needs to be transferred to Tableau. Assuming that the database has sufficient computing power, this can result in significant performance improvement.
The remainder of this chapter will look at the syntax, the three LOD keywords, and three interesting use cases of these types of calculations.
Keywords and Syntax
LOD Calculations are entered into...
