LOD vs table calculations in Tableau - Interactive Practice

Practice - 5 Tasks

1fill in blank

easy

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

Tableau

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

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

A[Sales]

B[Profit]

C[Quantity]

D[Discount]

Attempts:

3 left

💡 Hint

Common Mistakes

Using Profit or Quantity instead of Sales.

Forgetting to use SUM inside the LOD expression.

The fixed LOD expression fixes the calculation at the Region level and sums the Sales field.

2fill in blank

medium

Complete the table calculation to compute the running total of sales.

Tableau

RUNNING_SUM([1])

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

A[Sales]

B[Profit]

C[Quantity]

D[Discount]

Attempts:

3 left

💡 Hint

Common Mistakes

Using Profit or Quantity instead of Sales.

Not understanding that RUNNING_SUM is a table calculation.

RUNNING_SUM calculates the cumulative total of the Sales field across the table.

3fill in blank

hard

Fix the error in this LOD expression that tries to calculate average sales per customer.

Tableau

{FIXED [Customer ID]: AVG([1])}

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

A[Discount]

B[Profit]

C[Quantity]

D[Sales]

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM instead of AVG.

Applying AVG to Profit or Quantity instead of Sales.

The AVG function should be applied to the Sales field to get average sales per customer.

4fill in blank

hard

Fill both blanks to create a table calculation that computes the percent of total sales by category.

Tableau

SUM([1]) / TOTAL(SUM([2]))

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

A[Sales]

B[Profit]

D[Quantity]

Attempts:

3 left

💡 Hint

Common Mistakes

Using different fields in numerator and denominator.

Forgetting to use TOTAL for the denominator.

The calculation divides the sum of Sales per category by the total sum of Sales to get the percent of total.

5fill in blank

hard

Fill all three blanks to create a fixed LOD expression that calculates the maximum profit per segment and category.

Tableau

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

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

A[Segment]

B[Category]

C[Profit]

D[Sales]

Attempts:

3 left

💡 Hint

Common Mistakes

Using Sales instead of Profit for the MAX function.

Mixing up Segment and Category fields.

The fixed LOD fixes the calculation at Segment and Category levels and finds the maximum Profit.