Tableau’s INCLUDE Level of Detail Scope

Data

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
Thoughts on Tableau Conference 2024 I’ve attended every Tableau Conference since the first one in 2008, held at the Edgewood Hotel in Seattle. That conference included 150 ...
Ten Questions for ChatGPT about Tableau and Level of Detail Expressions I had some fun with ChatGPT asking it questions about cohort analysis this week. I’ll spare you the 4,000 words it created on general ...

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