7
Practicing Level of Detail Calculations
When we talk about Level of Detail (LOD) calculations in Tableau, we mean three expressions: FIXED, INCLUDE, and EXCLUDE. These three expressions open up a world of options by providing the ability to create calculations that target specific levels of granularity. In older versions of Tableau, data granularity for a worksheet was established by the dimensions in a view. If the view contained dimensions for, for example, Region, State, and Postal Code, but the author wanted to create a City-level calculation, the City dimension would need to be included on the view. Furthermore, there was no mechanism for excluding or ignoring a given dimension on a view. Admittedly, the desired results could normally ...
Get Mastering Tableau 2023 - Fourth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
