From the course: Tableau: Mastering Calculations

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

LOD calculations in the Tableau Order of Operations

LOD calculations in the Tableau Order of Operations - Tableau Tutorial

From the course: Tableau: Mastering Calculations

Start my 1-month free trial Buy for my team

LOD calculations in the Tableau Order of Operations

“

- We just calculated the cohorts by the year of date of purchase. What happens if we filter the normal date of purchase to no longer include the year 2022? Then all orders from 2022 will be excluded, so that the oldest order from all customers should only come from 2023 at the earliest, right? Let's exclude 2022 and see. Hmm, well, we can see, although there is no longer a bar for 2022, the remaining years still show which existing customers ordered from us for the first time in 2022. How can that be? Let's refer to Tableau's Order of Operations again. We first encountered this in the previous chapter when we talked about how to filter table calculations properly. Our date filter is a dimension filter. We see that include and exclude LODs are calculated after the dimension filter. So for these two level of detail expressions, the filter is applied as expected. Don't worry. Fixed, however, is a special case. Fixed calculations are calculated before dimension filters take effect. That's…

Contents