INCLUDE LOD expression in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ dax_lod_result

intermediate

Calculate Average Sales per Customer Including Region

You have sales data with Customer and Region fields. You want to calculate the average sales per customer but include Region in the calculation using an INCLUDE LOD expression.

Which of the following Tableau calculations correctly uses INCLUDE LOD to achieve this?

A { INCLUDE [Region] : AVG([Sales]) }

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

C { EXCLUDE [Region] : AVG([Sales]) }

D { FIXED [Customer] : AVG([Sales]) }

💡 Hint

INCLUDE LOD adds dimensions to the view for aggregation.

Option A correctly uses INCLUDE to add Region to the aggregation level, calculating average sales per customer including region.

Option A incorrectly includes Customer, which is already the base level.

Option A uses EXCLUDE, which removes Region from the calculation.

Option A uses FIXED, which fixes calculation only by Customer, ignoring Region.

❓ visualization

intermediate

Best Visualization for INCLUDE LOD Showing Sales by Customer and Region

You created an INCLUDE LOD calculation to get average sales per customer including region. Which visualization best shows this data clearly?

A A bar chart with Customer on the x-axis and average sales on the y-axis, colored by Region

B A pie chart showing total sales by Region only

C A line chart showing sales over time without region breakdown

D A scatter plot with sales on x-axis and customer count on y-axis

💡 Hint

Think about showing both Customer and Region dimensions clearly.

Option A clearly shows average sales per customer and includes region by color, matching the INCLUDE LOD calculation.

Other options do not show both Customer and Region together.

🧠 Conceptual

advanced

Understanding INCLUDE LOD Behavior

Which statement best describes how INCLUDE LOD expressions behave in Tableau?

A INCLUDE LOD removes specified dimensions from the view level of detail for aggregation.

B INCLUDE LOD adds specified dimensions to the view level of detail for aggregation, even if they are not in the view.

C INCLUDE LOD fixes the aggregation at the specified dimensions regardless of the view.

D INCLUDE LOD ignores all dimensions and calculates aggregation at the data source level.

💡 Hint

Think about what INCLUDE means in terms of dimensions.

INCLUDE LOD adds dimensions to the aggregation level, even if those dimensions are not in the current view.

Option B describes EXCLUDE LOD.

Option B describes FIXED LOD.

Option B is incorrect.

🔧 Formula Fix

advanced

Identify the Error in INCLUDE LOD Expression

Review the following Tableau INCLUDE LOD expression:

{ INCLUDE [Region] AVG([Sales]) }

What is the error in this expression?

Tableau

{ INCLUDE [Region] AVG([Sales]) }

A Braces '{}' should be parentheses '()'

B Incorrect use of square brackets around Region

C AVG function cannot be used inside INCLUDE LOD

D Missing colon ':' between dimension and aggregation

💡 Hint

Check the syntax for INCLUDE LOD expressions carefully.

The correct syntax requires a colon ':' after the dimension list before the aggregation function.

Option D identifies this missing colon.

Other options are incorrect because square brackets are correct for fields, AVG is valid, and braces are required.

🎯 Scenario

expert

Using INCLUDE LOD to Compare Sales with and without Region

You want to create a dashboard that compares average sales per customer including region and average sales per customer ignoring region. Which two LOD expressions should you use?

A { FIXED [Region] : AVG([Sales]) } and { EXCLUDE [Customer] : AVG([Sales]) }

B { EXCLUDE [Region] : AVG([Sales]) } and { INCLUDE [Customer] : AVG([Sales]) }

C { INCLUDE [Region] : AVG([Sales]) } and { FIXED [Customer] : AVG([Sales]) }

D { FIXED [Customer, Region] : AVG([Sales]) } and { INCLUDE [Customer] : AVG([Sales]) }

💡 Hint

Think about how FIXED and INCLUDE control aggregation levels.

Option C correctly uses INCLUDE to add Region and FIXED to fix only by Customer, allowing comparison.

Other options misuse LOD types or dimensions.