EXCLUDE LOD expression in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create an EXCLUDE LOD expression that excludes the Category dimension.

Tableau

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

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

A[Region]

B[Category]

C[Customer]

D[Order Date]

Attempts:

3 left

💡 Hint

Common Mistakes

Using a dimension that is not in the view.

Forgetting to include the colon after the dimension.

Confusing EXCLUDE with INCLUDE or FIXED.

The EXCLUDE LOD expression removes the specified dimension from the view's level of detail. Here, excluding [Category] means the calculation ignores Category when summing Sales.

2fill in blank

medium

Complete the EXCLUDE LOD expression to calculate average sales excluding the Region dimension.

Tableau

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

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

A[Region]

B[Customer Segment]

C[Category]

D[Order Date]

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing a dimension that is not part of the view.

Using SUM instead of AVG when the question asks for average.

Excluding [Region] means the average sales calculation ignores the Region dimension, aggregating over all regions.

3fill in blank

hard

Fix the error in the EXCLUDE LOD expression that tries to exclude the Customer dimension but has incorrect syntax.

Tableau

{EXCLUDE [1] SUM([Profit])}

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

A[Customer]

B[Customer];

CCustomer

D[Customer],

Attempts:

3 left

💡 Hint

Common Mistakes

Adding commas or semicolons inside the curly braces.

Omitting the colon after the dimension.

The correct syntax requires the dimension inside square brackets without extra commas or semicolons, and a colon after the dimension. The fixed expression is {EXCLUDE [Customer] : SUM([Profit])}.

4fill in blank

hard

Fill both blanks to create an EXCLUDE LOD expression that excludes both Region and Category dimensions.

Tableau

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

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

A[Region]

B[Customer]

C[Category]

D[Order Date]

Attempts:

3 left

💡 Hint

Common Mistakes

Forgetting commas between dimensions.

Not using square brackets around dimension names.

To exclude multiple dimensions, list them separated by commas inside the EXCLUDE clause. Here, excluding [Region] and [Category] means the sum of sales ignores these two dimensions.

5fill in blank

hard

Fill all three blanks to write an EXCLUDE LOD expression that excludes Region and Customer, and calculates average profit.

Tableau

{EXCLUDE [1], [2] : [3]([Profit])}

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

A[Region]

B[Customer]

CAVG

DSUM

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM instead of AVG when average is requested.

Omitting commas between dimensions.

Not using square brackets around dimension names.

The expression excludes [Region] and [Customer] dimensions and calculates the average profit using AVG. The correct syntax is {EXCLUDE [Region], [Customer] : AVG([Profit])}.