Level of Detail (LOD) Expressions - INCLUDE

INCLUDE LOD expressions add dimensions to the aggregation level beyond what's in the view. They compute at a finer grain than the view level, then aggregate up. INCLUDE expressions respect all filters in the view. They're useful when you need to calculate at a detailed level, then summarize to match the visualization.

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

1. Using OrderDate from Kyvos, create a calculated field.

2. Name it Sales by Customer and Category.

   Open

   

3. Click Ok.

4. Drag the Region to Rows.

5. Drag Sales by Customer and Category to columns, aggregated as AVG. This shows average sales at the customer-category level, displayed by region.

   Open

   

6. Add a Category to filters to see how INCLUDE respects filters.

7. Compare results with and without filters applied. Include LOD values changes with the dimension filter.

   Open