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 functions
  • 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