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
A Data Viz of U.S. Lumber Prices in 2021 My wife and I moved into our downsized home three years ago. Our timing was good. There was some available inventory, and we were able ...
Tableau Conference 2020: Keynote Recap I’ve been going to Tableau Conferences ever since the first one at the Edgewater Hotel in Seattle in 2008. There were around 200 total ...

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

Telefon: +49 (0)211 5408 5301

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