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.