To flag orders with sales higher than the regional average, the correct calculated field would compare the sum of sales for each order against the average sales of all orders within the same region:
This calculation uses a Level of Detail (LOD) expression:
The left part of the formula { FIXED [Order ID] : SUM([Sales]) } calculates the total sales for each individual order.
The right part { FIXED [Region] : AVG({ FIXED [Order ID] : SUM([Sales]) }) } calculates the average sales per order within each region.
The > operator is used to compare these two values to determine if the sales for each order exceed the regional average.
References
This formula utilizes Tableau's LOD expressions to perform complex comparisons across different dimensions of the data, as explained in Tableau's official training materials on LOD calculations.
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit