Tableau Level of Detail Calculated Fields v9

Data

Tableau Level of Detail Calculated Fields v9

by 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! 

More About the Author

Rob Austin

Consultant
Using Tableau on your Mobile I have been using Tableau since version 4, initially as a Tableau customer. One of the first things I wanted was to be able to see my ...
Tableau Level of Detail Calculated Fields v9 In this tutorial I talk about the Tableau Level of Detail calculations  {fixed}, {include} and {exclude} which are new in Tableau ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

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