The FIXED Level of Detail Function (LODs) let you specify the level of detail you want to aggregate a particular measure at. This allows us to work around the natural limitations of the level of detail in the worksheet we're working in.
FIXED LODs are a great place to start as they are the definitive, essential LOD. The two others (EXCLUDE and INCLUDE) are less common, but functional in their own unique ways. If you want to simplify and just learn one LOD type, FIXED is the one for you!
While LODs can be a bit intimidating or confusing at first, they're an essential part of working with Tableau. This video walks you through the fundamentals of FIXED LODs in Tableau, explaining what the level of detail is, and when you might need an LOD.
Connect with us:
•Upcoming Tableau Classes: onenumber.biz/onenumber-table...
•Book an hour to work with Ollie: onenumber.biz/office-hours
•Subscribe to the OneNumber Newsletter: onenumber.biz/newsletter
•Follow Ollie Linley on LinkedIn: / oliverlinley
Resources:
•Example Tableau Workbook: public.tableau.com/views/FIXE...
•Discrete vs. Continuous: onenumber.biz/blog-1/2022/5/2....
•Unraveling the Mystery of LOD Expressions: onenumber.biz/blog-1/2020/5/1...
Chapters
0:00 How Level of Detail Works
1:55 FIXED Header Totals
5:20 Office Hours and Classes
5:30 FIXED and Order of Operations
7:15 FIXED Cohort Analysis
16 июл 2024