Running total in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to calculate a running total of Sales.

Tableau

RUNNING_SUM([1])

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

ASUM([Sales])

BAVG([Sales])

CCOUNT([Sales])

DMIN([Sales])

Attempts:

3 left

💡 Hint

Common Mistakes

Using AVG or COUNT instead of SUM inside RUNNING_SUM.

Not using an aggregation function inside RUNNING_SUM.

The RUNNING_SUM function requires a measure to sum over time. Using SUM([Sales]) correctly calculates the running total of sales.

2fill in blank

medium

Complete the code to compute a running total of Profit by Month.

Tableau

RUNNING_SUM([1])

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

ACOUNT([Profit])

BMAX([Profit])

CMIN([Profit])

DSUM([Profit])

Attempts:

3 left

💡 Hint

Common Mistakes

Using MAX or MIN instead of SUM inside RUNNING_SUM.

Using COUNT which counts rows, not sums values.

To calculate running total of profit, use SUM([Profit]) inside RUNNING_SUM.

3fill in blank

hard

Fix the error in the running total calculation for Quantity.

Tableau

RUNNING_SUM([1])

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

AAVG([Quantity])

B[Quantity]

CSUM([Quantity])

DCOUNT([Quantity])

Attempts:

3 left

💡 Hint

Common Mistakes

Using the field directly without SUM inside RUNNING_SUM.

Using AVG or COUNT instead of SUM.

The running total needs an aggregation like SUM([Quantity]). Using just [Quantity] causes an error because RUNNING_SUM expects an aggregated measure.

4fill in blank

hard

Fill both blanks to calculate running total of Sales partitioned by Region.

Tableau

RUNNING_SUM([1]) OVER ([2])

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

ASUM([Sales])

BPARTITION BY [Region]

CORDER BY [Date]

DGROUP BY [Region]

Attempts:

3 left

💡 Hint

Common Mistakes

Using GROUP BY instead of PARTITION BY in window function.

Not using aggregation inside RUNNING_SUM.

Use SUM([Sales]) inside RUNNING_SUM and PARTITION BY [Region] to reset running total for each region.

5fill in blank

hard

Fill all three blanks to calculate running total of Profit ordered by Month within each Category.

Tableau

RUNNING_SUM([1]) OVER ([2], [3])

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

ASUM([Profit])

BPARTITION BY [Category]

CORDER BY [Month]

DGROUP BY [Category]

Attempts:

3 left

💡 Hint

Common Mistakes

Using GROUP BY instead of PARTITION BY.

Not ordering by date/month causes incorrect running totals.

Missing aggregation inside RUNNING_SUM.

Use SUM([Profit]) inside RUNNING_SUM. Then partition by category and order by month to get running totals per category over time.