Percent of total in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to calculate the percent of total sales for each category.

Tableau

SUM([Sales]) / [1]

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

AMIN([Sales])

BAVG([Sales])

CTOTAL(SUM([Sales]))

DCOUNT([Sales])

Attempts:

3 left

💡 Hint

Common Mistakes

Using AVG([Sales]) instead of TOTAL(SUM([Sales]))

Using COUNT([Sales]) which counts rows, not sums values

To calculate percent of total, divide the sum of sales by the total sum of sales across all categories using TOTAL(SUM([Sales])).

2fill in blank

medium

Complete the code to create a calculated field that shows percent of total profit by region.

Tableau

SUM([Profit]) / [1]

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

AAVG([Profit])

BSUM([Profit])

CMIN([Profit])

DWINDOW_SUM(SUM([Profit]))

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM([Profit]) which only sums for the current row

Using AVG([Profit]) which calculates average, not total

WINDOW_SUM(SUM([Profit])) calculates the total profit over the window, which is needed to compute percent of total.

3fill in blank

hard

Fix the error in the calculated field to correctly compute percent of total sales by segment.

Tableau

SUM([Sales]) / [1]

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

AWINDOW_SUM(SUM([Sales]))

BSUM([Sales])

CTOTAL(AVG([Sales]))

DAVG([Sales])

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM([Sales]) in denominator which causes division by itself

Using AVG([Sales]) which does not represent total sales

WINDOW_SUM(SUM([Sales])) correctly computes the total sales over the window, enabling percent of total calculation.

4fill in blank

hard

Fill both blanks to calculate percent of total profit by category and region.

Tableau

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

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

AWINDOW_SUM(SUM([Profit]))

BFIXED

CTOTAL

DINCLUDE

Attempts:

3 left

💡 Hint

Common Mistakes

Using FIXED or INCLUDE which are not appropriate for this calculation

Using SUM([Profit]) instead of WINDOW_SUM for total

Use WINDOW_SUM(SUM([Profit])) to get total profit in the window and TOTAL to aggregate correctly for percent of total.

5fill in blank

hard

Fill all three blanks to create a calculated field for percent of total sales by category with table calculation.

Tableau

SUM([Sales]) / [1]([2](SUM([Sales])), [3])

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

AWINDOW_SUM

BTOTAL

CALL

DPARTITION

Attempts:

3 left

💡 Hint

Common Mistakes

Using PARTITION instead of ALL which limits scope

Using WINDOW_SUM outside TOTAL which causes incorrect aggregation

Use TOTAL(WINDOW_SUM(SUM([Sales])), ALL) to compute total sales ignoring filters for percent of total.