Every LOD expression is wrapped in curly braces {} . The basic structure follows this pattern: FIXED [Dimension 1], [Dimension 2] : AGG([Measure])
When using FIXED, ask yourself these three questions: fixed in tableau
Change the aggregation of the new field to AVG in the view (or wrap it): Every LOD expression is wrapped in curly braces {}
You want to compare the daily sales of a specific product category against the average daily sales of the entire store. | Expression | Respects view dimensions
FIXED tells Tableau to ignore the view's level of detail.
| Expression | Respects view dimensions? | Respects view filters? | |------------|---------------------------|------------------------| | | No (uses specified dimensions only) | No (unless context filter) | | INCLUDE | Yes (adds specified dimensions) | Yes | | EXCLUDE | Yes (removes specified dimensions) | Yes |
If you just put AVG(Sales) in the view, you get the average order value. You need a two-step process.