All in Level of Detail
FIXED Level of Detail Functions (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!
Do you want to keep all data associated with a value which has multiple records in a data set? Maybe it's how many students attended multiple schools, how many patients visited a hospital multiple times or how many customers made multiple purchases.
I was recently working on a project where we wanted to compare weekly performance, but it only made sense to compare weeks once they were complete. As a result, we routinely came across situations where we wanted to compare the last full week to the previous full week.
Level of Detail Expressions are one of the most powerful and least understood features in Tableau's calculation toolkit. Watch the below webinar recording to learn how they can be used to get more out of your Tableau workbooks.
I’ve been working with a healthcare system that wants to do a better job of understanding patient behavior. Better understanding will drive decisions around staffing, purchasing, shift breaks, essentially the entire way the system is managed.
