INCLUDE LOD expression in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to calculate the average sales including the Category level.

Tableau

AVG([1] [Category] : SUM([Sales]) })

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

AINCLUDE

BEXCLUDE

CFIXED

DWINDOW

Attempts:

3 left

💡 Hint

Common Mistakes

Using EXCLUDE instead of INCLUDE changes the level of detail incorrectly.

Using FIXED ignores the view's dimensions.

The INCLUDE LOD expression adds the specified dimension ([Category]) to the level of detail for the aggregation.

2fill in blank

medium

Complete the INCLUDE LOD expression to calculate total profit including both Region and Segment.

Tableau

SUM([1] [Region], [Segment] : SUM([Profit]) })

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

AEXCLUDE

BFIXED

CWINDOW

DINCLUDE

Attempts:

3 left

💡 Hint

Common Mistakes

Using FIXED locks the level of detail ignoring the view.

Using EXCLUDE removes dimensions instead of adding.

INCLUDE adds the specified dimensions ([Region], [Segment]) to the aggregation level.

3fill in blank

hard

Fix the error in the INCLUDE LOD expression to correctly calculate average discount including Sub-Category.

Tableau

AVG([1] [Sub-Category] : AVG([Discount]) })

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

AINCLUDE

BEXCLUDE

CFIXED

DINCLUDE(

Attempts:

3 left

💡 Hint

Common Mistakes

Adding extra parentheses after INCLUDE causes syntax errors.

Using EXCLUDE or FIXED changes the meaning.

The correct syntax uses INCLUDE without extra parentheses after it.

4fill in blank

hard

Fill the blank to calculate the sum of sales including Category and Sub-Category levels.

Tableau

SUM([1] [Category], [Sub-Category] : SUM([Sales]) })

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

AEXCLUDE

BINCLUDE

DFIXED

Attempts:

3 left

💡 Hint

Common Mistakes

Using EXCLUDE or FIXED changes the level of detail incorrectly.

Omitting the INCLUDE keyword causes syntax errors.

The INCLUDE LOD expression adds the specified dimensions ([Category], [Sub-Category]) to the level of detail for the aggregation.

5fill in blank

hard

Fill the blank to create an INCLUDE LOD expression calculating average profit including Region and Segment.

Tableau

AVG([1] [Region], [Segment] : SUM([Profit]) })

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

AEXCLUDE

BFIXED

CINCLUDE

Attempts:

3 left

💡 Hint

Common Mistakes

Using FIXED or EXCLUDE changes the aggregation level incorrectly.

Omitting the INCLUDE keyword causes syntax errors.

The INCLUDE LOD expression adds the specified dimensions ([Region], [Segment]) to the level of detail for the aggregation.