Video | Tableau | Data visualisation | Analytics

Exclude Level of Detail Calculation: Tableau Functions

The final and probably the easiest LOD to understand.

Part ofTableau Level of detail functionsTableau Functions
Watch on YouTube
  • The exclude function works against the viz level of detail, effectively removing a specified dimension from the view before performing the aggregation
  • Unlike fixed LODs, both include and exclude functions are influenced by what you place in the visualisation, so adding dimensions like region can unexpectedly change your results
  • Exclude often returns ATTR() because apportioning a higher-level value across a finer-grained view is the only way it can display the result
  • When building complex calculations, set everything up as a table first to verify your numbers before creating charts and worrying about formatting
  • You can combine a string parameter with an IF calculation and exclude LOD to build a dynamic comparison chart that recalculates against any selected subcategory
The Drilldown
a just-tim newsletter

Liked this? Get the honest take most weeks.

New essays about the industry as they land. My running read on what's worth your attention. By email or on LinkedIn.

5,323 subscribers and counting

or
inRead it on LinkedIn

Email via beehiiv. No spam, unsubscribe any time.