I thought I would summarize in today’s blog my new knowledge about LODs in Tableau as many people find them difficult to understand and very unclear how and when to use.

Level Of Details calculation is the type of calculation in Tableau. They come very handy when you want to calculate things at a different level than what you see in the view. They can do that by fixing the level of details in the calculation, including more granular details to the calculation or excluding a granularity of detail in the calculation, where you end up with more aggregated data

That’s where their names come from: {FIXED}, {INCLUDE} and {EXCLUDE}.

One important thing to remember is the order of operation as it is different for FIXED LODs and INCLUDE or EXCLUDE LODs. Need to bear in mind that the Dimensional filters affect INCLUDE/EXCLUDE LODs but not FIXED LODs.

Context filters however work before FIXED LODs but simple dimensional filters work after {FIXED} LODs, but before {INCLUDE} and {EXCLUDE} LODs

The syntax is similar for all of them where we need to specify the {type of LOD, [dimension], [optional dimension]: aggregate[measure]}. In Fixed LODs you can be able to skip [dimension]. If you don’t have a dimension you can even not mention the type of LOD (Fixed). For example, it can look like {COUNTD([State])}

You can’t combine Table calculations and LODs in one. For example, if we do LOD calculation to find out the date of the customer’s last order we will use Max [Order date], not last[Order date], because last() is a table calculation.

Hope that will help a bit to remember a few important points for using LODs.

The Data School
Author: The Data School