Level of Detail (LOD) Expressions - FIXED

FIXED LOD expressions compute values at a specified level of detail, independent of the view's dimensions. They allow calculations at granularities different from the visualization level. FIXED expressions ignore filters except context filters and data source filters. They're essential for comparing aggregated values at different dimensional levels.

To specify Level of Detail (LOD) Expressions - FIXED, perform the following steps.

1. With Kyvos OrderDate loaded, create a new calculated field.

2. Name it Sales per Customer.

   Open

   

3. Click Ok.

4. Create another calculated field called Avg Sales per Customer.

   Open

   

5. Drag the Region to Rows.

6. Drag Avg Sales per Customer to Columns. This shows average customer-level sales by region.

7. Compare with simply AVG([Sales]) to see the difference.

   Open