INCLUDE LOD expression in Tableau - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the INCLUDE LOD expression do in Tableau?

It calculates a value including additional dimensions beyond the view's level of detail, allowing more detailed aggregation without changing the view.

beginner

Write a simple INCLUDE LOD expression to calculate average sales per customer, even if the view is at the region level.

{ INCLUDE [Customer ID] : AVG([Sales]) }

intermediate

How does INCLUDE differ from FIXED LOD expressions?

INCLUDE adds dimensions to the existing view level of detail, while FIXED calculates at a specified level regardless of the view's dimensions.

intermediate

Can INCLUDE LOD expressions be used with filters in Tableau?

Yes, INCLUDE LOD expressions respect context filters but ignore dimension filters unless those filters are added to context.

beginner

Why use INCLUDE LOD instead of just adding dimensions to the view?

INCLUDE LOD lets you calculate detailed metrics without changing the visual layout or granularity of the view, keeping it clean and focused.

What does the INCLUDE LOD expression do in Tableau?

A Calculates values including extra dimensions beyond the view's level of detail

B Fixes the calculation to a specific dimension ignoring the view

C Excludes certain dimensions from the calculation

D Filters data before aggregation

INCLUDE adds specified dimensions to the calculation level, allowing more detailed aggregation than the view.

Which of these is a correct INCLUDE LOD expression to get average sales per product?

A { EXCLUDE [Product ID] : AVG([Sales]) }

B { FIXED [Product ID] : SUM([Sales]) }

C { INCLUDE [Product ID] : AVG([Sales]) }

D AVG([Sales])

INCLUDE adds Product ID to the calculation level, averaging sales per product.

If your view is at the Region level, what does INCLUDE [Customer ID] do?

A Fixes calculation only at Region level

B Calculates metrics at Customer ID level within each Region

C Filters out Customer ID from the data

D Ignores Customer ID and calculates at Region level

INCLUDE adds Customer ID dimension, so calculation is more detailed than Region level.

Which filter type does INCLUDE LOD respect in Tableau?

A Context filters

B Dimension filters not in context

C All filters equally

D No filters

INCLUDE LOD respects context filters but ignores dimension filters unless they are added to context.

Why might you use INCLUDE LOD instead of adding dimensions to the view?

A To fix calculation at a single dimension

B To remove dimensions from the calculation

C To filter data before aggregation

D To calculate detailed metrics without changing the view's layout

INCLUDE lets you add detail to calculations without changing the visual granularity.

Explain how INCLUDE LOD expressions work in Tableau and give a simple example.

Think about adding detail to calculations without changing the view.

Describe the difference between INCLUDE and FIXED LOD expressions and when to use each.

Consider how each controls calculation granularity.

Practice

1. What does the INCLUDE LOD expression do in Tableau?

easy

A. Changes the data source connection

B. Removes all filters from the calculation

C. Aggregates data only at the highest level of detail

D. Calculates a measure at a more detailed level than the current view

Solution

1. Step 1: Understand the purpose of INCLUDE LOD

   INCLUDE LOD lets you add extra detail to calculations without changing the main view's level of detail.

2. Step 2: Compare options to definition

   Calculates a measure at a more detailed level than the current view correctly states it calculates measures at a more detailed level than the current view, which matches the INCLUDE LOD purpose.

3. Final Answer:

   Calculates a measure at a more detailed level than the current view -> Option D

4. Quick Check:

   INCLUDE LOD = More detailed calculation [OK]

Hint: INCLUDE adds detail inside calculation without changing view [OK]

Common Mistakes:

• Confusing INCLUDE with EXCLUDE or FIXED LOD
• Thinking it removes filters
• Assuming it changes data source

2. Which of the following is the correct syntax for an INCLUDE LOD expression to calculate average sales per customer in Tableau?

easy

A. { INCLUDE [Customer ID] : AVG([Sales]) }

B. { EXCLUDE [Customer ID] : AVG([Sales]) }

C. INCLUDE [Customer ID] AVG([Sales])

D. { FIXED [Customer ID] AVG([Sales]) }

Solution

1. Step 1: Recall correct INCLUDE LOD syntax

   The correct syntax uses curly braces, INCLUDE keyword, dimension in brackets, colon, then aggregation function.

2. Step 2: Check each option

   { INCLUDE [Customer ID] : AVG([Sales]) } matches syntax: { INCLUDE [Customer ID] : AVG([Sales]) }. Others have wrong keywords, missing braces, or missing colon.

3. Final Answer:

   { INCLUDE [Customer ID] : AVG([Sales]) } -> Option A

4. Quick Check:

   Syntax = { INCLUDE [Dimension] : Aggregation } [OK]

Hint: INCLUDE syntax always uses braces and colon [OK]

Common Mistakes:

• Omitting curly braces or colon
• Using wrong LOD keyword (EXCLUDE or FIXED)
• Missing brackets around dimension

3. Given the data view shows total sales by Region, what will the following INCLUDE LOD expression calculate?

{ INCLUDE [Customer ID] : SUM([Sales]) }

Options:

medium

A. Sum of sales per customer then aggregated by region

B. Average sales per region

C. Sum of sales per region ignoring customers

D. Sum of sales ignoring region and customer

Solution

1. Step 1: Understand the view and LOD expression

   The view is grouped by Region. The INCLUDE LOD adds Customer ID detail inside the calculation.

2. Step 2: Interpret the calculation result

   The expression sums sales per Customer ID first, then aggregates these sums by Region in the view.

3. Final Answer:

   Sum of sales per customer then aggregated by region -> Option A

4. Quick Check:

   INCLUDE adds detail level inside aggregation [OK]

Hint: INCLUDE adds detail inside aggregation, then aggregates by view [OK]

Common Mistakes:

• Thinking it ignores customers
• Confusing sum with average
• Assuming it ignores region

4. Identify the error in this INCLUDE LOD expression:

{ INCLUDE Customer ID : SUM([Sales]) }

medium

A. Incorrect use of curly braces

B. Missing aggregation function

C. Missing square brackets around Customer ID

D. INCLUDE keyword should be EXCLUDE

Solution

1. Step 1: Check syntax for dimension references

   Dimension names must be enclosed in square brackets in LOD expressions.

2. Step 2: Identify missing brackets

   Customer ID is missing square brackets, causing syntax error.

3. Final Answer:

   Missing square brackets around Customer ID -> Option C

4. Quick Check:

   Dimensions need [brackets] in LOD [OK]

Hint: Always put dimension names in square brackets [OK]

Common Mistakes:

• Omitting brackets around dimensions
• Confusing INCLUDE with EXCLUDE
• Missing curly braces

5. You want to calculate the average sales per product category but also include the customer-level detail in the calculation without changing the view's level of detail. Which INCLUDE LOD expression should you use?

hard

A. AVG([Sales])

B. { INCLUDE [Customer ID] : AVG([Sales]) }

C. { EXCLUDE [Customer ID] : AVG([Sales]) }

D. { FIXED [Product Category] : AVG([Sales]) }

Solution

1. Step 1: Understand the requirement

   You want average sales per product category but with customer-level detail included in calculation without changing view level.

2. Step 2: Choose correct LOD expression

   INCLUDE adds customer detail inside calculation while keeping view level (product category). { INCLUDE [Customer ID] : AVG([Sales]) } matches this need.

3. Final Answer:

   { INCLUDE [Customer ID] : AVG([Sales]) } -> Option B

4. Quick Check:

   INCLUDE adds detail without changing view [OK]

Hint: Use INCLUDE to add customer detail inside product category calc [OK]

Common Mistakes:

• Using FIXED which ignores view level
• Using EXCLUDE which removes detail
• Using simple AVG ignoring detail