| LOD Type | Logic | Best for | | :--- | :--- | :--- | | | Calculate only by these dimensions. Ignore everything else in the view. | "What is the company max sales?" "First purchase date per user." | | INCLUDE | Calculate by view dimensions + these extra ones. | "What is the average sales per day, even if my view is by month?" | | EXCLUDE | Calculate by view dimensions, but remove these ones. | "What is the total US sales, ignoring state level detail?" |
If you have been using Tableau for more than a few weeks, you have probably hit the wall . fixed calculation tableau
FIXED [Sub-Category] : MAX([Sales]) Wait, that gives me a number, not a flag. | LOD Type | Logic | Best for
But what if you want the FIXED calculation to respect the year? | "What is the average sales per day,
But when you filter the dashboard to "2024" only, that MIN changes. The customer who first bought in 2020 suddenly shows a first purchase date of 2024. The calculation is .
Result: Tableau looks at all chairs, finds the single highest sales number, and highlights only that row. Do not try to memorize every LOD syntax. Instead, memorize this question: