FIXED LOD expression in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to calculate total sales fixed by Region.

Tableau

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

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

AProfit

BQuantity

CSales

DDiscount

Attempts:

3 left

💡 Hint

Common Mistakes

Using Quantity instead of Sales

Forgetting to use SUM()

Using Profit or Discount which are not sales

The FIXED LOD expression fixes the aggregation by Region. We sum the Sales field.

2fill in blank

medium

Complete the code to fix average profit by Category.

Tableau

{FIXED [Category]: AVG([1])}

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

AProfit

BDiscount

CQuantity

DSales

Attempts:

3 left

💡 Hint

Common Mistakes

Using Sales instead of Profit

Using SUM instead of AVG

Using Quantity or Discount which are unrelated

The FIXED LOD expression calculates the average profit fixed by Category.

3fill in blank

hard

Fix the error in the FIXED LOD expression to calculate total quantity by Segment.

Tableau

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

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

A[Segment]

BSegments

C[Segments]

DSegment

Attempts:

3 left

💡 Hint

Common Mistakes

Omitting square brackets around the dimension

Using incorrect dimension names

Using plural form 'Segments' instead of 'Segment'

Dimension names in FIXED LOD expressions must be enclosed in square brackets, like [Segment].

4fill in blank

hard

Fill both blanks to calculate fixed average discount by Region and Category.

Tableau

{FIXED [1], [2]: AVG([Discount])}

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

A[Region]

B[Category]

CRegion

DCategory

Attempts:

3 left

💡 Hint

Common Mistakes

Using dimension names without brackets

Swapping the order of dimensions (order does not affect correctness but keep consistent)

Using plural or incorrect dimension names

FIXED LOD expressions require dimension names in square brackets. Here, Region and Category are fixed dimensions.

5fill in blank

hard

Fill all three blanks to calculate fixed total profit by Segment, Region, and Category.

Tableau

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

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

A[Segment]

B[Region]

C[Category]

D[Sales]

Attempts:

3 left

💡 Hint

Common Mistakes

Including measure fields like Sales as dimensions

Omitting brackets around dimension names

Using incorrect dimension names

The FIXED LOD expression fixes aggregation by Segment, Region, and Category. All dimension names must be bracketed.