From the course: Tableau: Mastering Calculations

Unlock the full course today

Join today to access over 24,200 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 year of purchase date. What happens if we filter the normal date of purchase? To no longer include the year 2020, then all orders from 2020 will be excluded so that the oldest order from all customers should only come from 2021 at the earliest, right? Let's try this out. Let's exclude 2020. Hmm. We can see even though there is no longer a bar for 2020, the remaining years still show which existing customers ordered from us for the first time in 2020. 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. Now our date filter is a dimension filter. We can 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 and you don't need to worry about them. FIXED is a special case however. FIXED expressions are calculated before…

Contents