Tableau’s INCLUDE Level of Detail Scope


Tableau’s INCLUDE Level of Detail Scope

This week I gave a talk on level of detail expressions at the Atlanta Tableau User Group. Preparing for that talk I watched lots of video. The speech by Ian Coe and Adam Kamor, Pick Your Poison, LOD Expression or Table Calc inspired this dashboard. InterWorks’ Robert Curtis also did a whole series on LOD calcs.

What I Added

This is similar to the worksheet that Ian provided in the talk, but I added a few things:

  1. Sorted the stacked marks by city for descending Average $ Sales by Order.
  2. A Min/Max label for the maximum city.
  3. Rank table calculations to show the specific cities’ rank within the state and the country. These are included in the tooltip.
  4. Filters for the year and for the sum of sales.
  5. Text table that displays the total city marks in view that will change depending on the year filtered but not for the sum of sales filter.

Thanks to Ian and Adam for the talk, and to Tableau Software for providing recording of the talks on the web. I just got around to watching the ones that I couldn’t attend. Excellent content!

More About the Author

Dan Murray

Director of Strategic Innovations
The BI Cantos: Facilitating Data Culture Environments that encourage learning, sharing and discovery will prosper. Environments that don’t will not achieve high ...
The BI Cantos: Setting the Stage for Predictive Analytics Predictive analytics should not be part of your initial BI system deployment. When you have finished building the BI system workflows ...

See more from this author →

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
Geschäftsführer: Mel Stephenson

Telefon: +49 (0)211 5408 5301

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


Insights are just a search away! - Join our webinar on June 21 to see ThoughtSpot in action.