In this tutorial I talk about the Tableau Level of Detail calculations  {fixed}, {include} and {exclude} which are new in Tableau Version 9.

We see how {fixed} can be used to turn a measure into bands and give it the full functionality of a dimension. This functionality is something that we are regularly asked for at Interworks and gives a great alternative to using ‘bins’ which can often be limiting.

Next we see how {include} is used to drill in to a lower level of detail without needing the dimension in the visualisation. This functionality really opens up possibilities on KPI or high level visualisations where space is a premium.

Finally {exclude} is used to compare a value within a chart to its overarching value. This functionality then expanded to define the overarching value which the cells are compared to using both {include} and {exclude} in the same calculation.  

If you have any questions, or comments, let us know in the comments section and keep tuned for more blog posts covering the latest improvements of Tableau Desktop 9.0. If you have any questions, please feel free to send me an email or, if you’re ready to download Tableau, click here to get started on a free 14 day trial!