Five Practical Uses of Tableau Level of Detail (LOD) Expressions | FIXED, INCLUDE, EXCLUDE

Level of Detail Expressions are one of the fundamental Tableau tools that every Tableau user should have in their toolbox. However, many people struggle to conceptualize how LODs work, or in what instances to use them.

It's helpful to see several instances of LODs in action to get a better idea of when to use them in your own context. In this video, we'll look at FIXED, INCLUDE, and EXCLUDE LODs. While FIXED is the most commonly used LOD, EXCLUDE and INCLUDE are immensely helpful in situations when you need filters to work in a specific order, or if you need to use your calculation in windows with varying levels of detail.

For some more hands-on learning, reach out to book an Office Hour with Ollie or Eric!


Connect with us:
•Book an Office Hour with Ollie: https://www.eventbrite.com/e/tableau-...
•Tableau Passport Program: https://onenumber.biz/tableau-trainin...
•Upcoming Tableau Classes: https://www.eventbrite.com/o/onenumbe...
•Subscribe to the OneNumber Newsletter: https://onenumber.biz/newsletter
•Follow Ollie on LinkedIn:   / oliverlinley  


Resources:
•Example Tableau Workbook: https://public.tableau.com/views/5Pra...
•How FIXED Level of Detail Expressions Work: https://onenumber.biz/blog-1/2024/3/1...
•Unraveling the Mystery of LODs: https://onenumber.biz/blog-1/2020/5/1...


0:30 Header Totals
3:42 Frequency Analysis
5:05 Only Multiple/Single Records
6:55 Find Highest/Lowest (FIXED)
8:59 Find Highest/Lowest (INCLUDE)