How FIXED Tableau Level of Detail Function Works

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:

Resources:

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

[JohnWRodat]

Good examples and important to highlight order-of-operation. One of the better explanations I've seen.

[carolefischer]

Hi Ollie, such a great tutorial! I particularly appreciate seeing how to choose to put the dimension onto the Context Filter. Great video!

[otis-lk]

Ollie and Eric are so handsome :D thank you for your videos

[otis-lk]

excuse me sir, how could you record the video and make annotations directly like that? what app was it?