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:
| 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?" | fixed calculation tableau
But what if you want the FIXED calculation to respect the year? Result: Tableau looks at all chairs, finds the
You try a standard calculation: MIN(Order Date) . Ignore everything else in the view