→ Works even when you filter to a specific year.
In this example, Tableau will calculate the total sales for each region, ignoring the country and city levels of detail.
FIXED [dimension1, dimension2, ...] : [aggregation or calculation] tableau fixed calculation
In Tableau , a FIXED calculation is a type of Level of Detail (LOD) expression that computes values at a specific level of detail, completely independent of the dimensions or filters currently in your view. This allows you to perform "for each" type analysis, such as finding the total sales for each state even when viewing data at a city level. Hevo Data +2 Key Characteristics View Independence
FIXED [Customer ID] : MIN([Order Date])
| Pitfall | Why it happens | Fix | |---------|----------------|-----| | | FIXED ignores dimension filters | Move filter to Context or use INCLUDE/EXCLUDE | | Unexpected repeated values | Row-level vs aggregated calculation | Place FIXED on Detail or use as a measure | | Slow performance | Computes across entire data source | Limit dimensions, use extracts, or pre-aggregate |
FIXED [Category] : SUM([Sales]) This tells Tableau: "Regardless of what else is in the view, calculate the total sum of sales for every Category". Why Use FIXED Calculations? → Works even when you filter to a specific year
Tableau is a powerful data visualization tool that enables users to connect to various data sources, create interactive dashboards, and share insights with others. One of the key features of Tableau is its calculation engine, which allows users to create calculated fields, measures, and dimensions. Among these calculations, the "Fixed" calculation is a powerful and flexible feature that enables users to perform complex aggregations and calculations. In this essay, we will explore the concept of Tableau's fixed calculation, its syntax, and its applications.