Now, even if you drill down or filter, that benchmark number remains tied to the global dataset structure (unless you use Context Filters).
This calculates the acquisition date for every customer. You can then compare this against the current date to find "Days Since First Purchase." Even if you filter the view to show only 2024 transactions, this calculation will look back in history to find the true first purchase date. tableau fixed calculation
In Tableau, a fixed calculation is a type of calculation that allows users to perform aggregations or calculations at a specific level of detail, while ignoring the other levels of detail in the data. The fixed calculation is denoted by the FIXED keyword, followed by the level of detail and the aggregation or calculation to be performed. The syntax of a fixed calculation is as follows: Now, even if you drill down or filter,
You want to see how each Sub-Category's sales compare to the global average sales of all Sub-Categories. In Tableau, a fixed calculation is a type