Why LOD expressions control aggregation scope in Tableau - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a fixed LOD expression that calculates the total sales per region.

Tableau

{FIXED [Region]: SUM([1])}

Drag options to blanks, or click blank then click option'

A[Discount]

B[Sales]

C[Quantity]

D[Profit]

Attempts:

3 left

💡 Hint

Common Mistakes

Using [Profit] or [Quantity] instead of [Sales]

Leaving out the aggregation function SUM

The fixed LOD expression fixes the aggregation at the Region level, so summing [Sales] gives total sales per region.

2fill in blank

medium

Complete the code to create an include LOD expression that adds product category to the aggregation scope for average sales.

Tableau

{INCLUDE [[1]]: AVG([Sales])}

Drag options to blanks, or click blank then click option'

ARegion

BCustomer

CProduct Category

DOrder Date

Attempts:

3 left

💡 Hint

Common Mistakes

Using Region or Customer instead of Product Category

Confusing INCLUDE with FIXED

The INCLUDE LOD expression adds Product Category to the aggregation scope, so average sales are calculated per product category within the existing view level.

3fill in blank

hard

Fix the error in this LOD expression that tries to exclude the Order Date from aggregation scope.

Tableau

{EXCLUDE [[1]]: SUM([Sales])}

Drag options to blanks, or click blank then click option'

AOrder Date

BRegion

CProduct Category

DCustomer

Attempts:

3 left

💡 Hint

Common Mistakes

Excluding Region or Customer instead of Order Date

Using FIXED instead of EXCLUDE

The EXCLUDE LOD expression removes Order Date from the aggregation scope, so sales are summed ignoring the order date detail.

4fill in blank

hard

Fill both blanks to create a fixed LOD expression that calculates the total profit per customer segment.

Tableau

{FIXED [[1]]: SUM([[2]])}

Drag options to blanks, or click blank then click option'

ACustomer Segment

BRegion

CProfit

DSales

Attempts:

3 left

💡 Hint

Common Mistakes

Using Region instead of Customer Segment

Summing Sales instead of Profit

The fixed LOD expression fixes aggregation at the Customer Segment level and sums the Profit field to get total profit per segment.

5fill in blank

hard

Fill all three blanks to create an include LOD expression that calculates average discount per product sub-category within each region.

Tableau

{INCLUDE [[1]], [[2]]: AVG([[3]])}

Drag options to blanks, or click blank then click option'

AProduct Sub-Category

BRegion

CDiscount

DSales

Attempts:

3 left

💡 Hint

Common Mistakes

Using Sales instead of Discount

Excluding Region or Product Sub-Category

The INCLUDE LOD expression adds Product Sub-Category and Region to the aggregation scope and calculates the average Discount accordingly.

Practice

1. What is the main purpose of Level of Detail (LOD) expressions in Tableau?

easy

A. To export data to Excel automatically

B. To change the color of charts dynamically

C. To filter data based on user input

D. To control how data is grouped before aggregation

Solution

1. Step 1: Understand LOD expression role

   LOD expressions let you fix or change the grouping level before aggregation happens.

2. Step 2: Compare with other options

   Changing colors, filtering, or exporting are unrelated to aggregation scope control.

3. Final Answer:

   To control how data is grouped before aggregation -> Option D

4. Quick Check:

   LOD controls grouping before aggregation = A [OK]

Hint: LOD fixes grouping level before aggregation [OK]

Common Mistakes:

• Confusing LOD with filtering
• Thinking LOD changes chart colors
• Assuming LOD exports data

2. Which of the following is the correct syntax for a FIXED LOD expression in Tableau?

easy

A. { FIXED [Region] : SUM([Sales]) }

B. { INCLUDE [Region] : SUM([Sales]) }

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

D. { FIXED SUM([Sales]) : [Region] }

Solution

1. Step 1: Identify correct FIXED syntax

   FIXED LOD syntax is { FIXED [Dimension] : Aggregation }, so { FIXED [Region] : SUM([Sales]) } matches.

2. Step 2: Check other options

   Options A and B use different LOD types, and D has incorrect order.

3. Final Answer:

   { FIXED [Region] : SUM([Sales]) } -> Option A

4. Quick Check:

   FIXED syntax = { FIXED [Dimension] : Aggregation } [OK]

Hint: FIXED syntax: { FIXED [Dimension] : Aggregation } [OK]

Common Mistakes:

• Swapping dimension and aggregation order
• Using INCLUDE or EXCLUDE instead of FIXED
• Missing curly braces

3. Given the data view grouped by [Category], what will { FIXED [Category] : SUM([Sales]) } return compared to SUM([Sales])?

medium

A. FIXED returns total sales ignoring Category grouping

B. SUM returns total sales ignoring Category grouping

C. Both return the same total sales per category

D. FIXED returns average sales per category

Solution

1. Step 1: Understand FIXED with grouping

   FIXED on [Category] fixes aggregation at category level, matching the view's grouping.

2. Step 2: Compare with SUM aggregation

   SUM([Sales]) aggregated by Category in the view also sums sales per category.

3. Final Answer:

   Both return the same total sales per category -> Option C

4. Quick Check:

   FIXED on grouping dimension = same as SUM by that group [OK]

Hint: FIXED on grouped dimension equals normal aggregation [OK]

Common Mistakes:

• Thinking FIXED ignores grouping always
• Confusing FIXED with INCLUDE or EXCLUDE
• Assuming FIXED changes aggregation type

4. Identify the error in this LOD expression: { FIXED : SUM([Sales]) }

medium

A. Missing dimension after FIXED keyword

B. SUM aggregation is not allowed in LOD

C. Curly braces are not needed

D. FIXED cannot be used without INCLUDE or EXCLUDE

Solution

1. Step 1: Check FIXED syntax requirements

   FIXED requires at least one dimension to fix aggregation scope, missing here.

2. Step 2: Validate other parts

   SUM is valid aggregation, curly braces are required, and FIXED can be used alone.

3. Final Answer:

   Missing dimension after FIXED keyword -> Option A

4. Quick Check:

   FIXED needs dimension(s) specified [OK]

Hint: FIXED must specify dimension(s) after keyword [OK]

Common Mistakes:

• Leaving out dimension after FIXED
• Removing curly braces
• Confusing FIXED with INCLUDE/EXCLUDE requirement

5. You want to calculate the total sales per customer ignoring the current view's grouping by product. Which LOD expression should you use?

hard

A. { INCLUDE [Product] : SUM([Sales]) }

B. { FIXED [Customer] : SUM([Sales]) }

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

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

Solution

1. Step 1: Understand requirement

   You want total sales per customer ignoring product grouping in the view.

2. Step 2: Choose correct LOD type

   FIXED on [Customer] fixes aggregation at customer level, ignoring other groupings like product.

3. Step 3: Evaluate options

   INCLUDE adds dimensions, EXCLUDE removes dimensions incorrectly here, FIXED on product fixes wrong dimension.

4. Final Answer:

   { FIXED [Customer] : SUM([Sales]) } -> Option B

5. Quick Check:

   FIXED fixes aggregation ignoring view grouping [OK]

Hint: Use FIXED on dimension to ignore view grouping [OK]

Common Mistakes:

• Using INCLUDE or EXCLUDE instead of FIXED
• Fixing wrong dimension
• Confusing FIXED with filtering