Tableau Level of Detail Calculated Fields v9

Tableau Level of Detail Calculated Fields v9

Rob Austin
//

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! 

Related

Need Expert Help?

See Our Full Menu of Data Services

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072

×

Love our blog? You should see our emails. Sign up for our newsletter!