Running total in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ dax_lod_result

intermediate

Calculate Running Total Using Table Calculation

You have monthly sales data in Tableau. Which table calculation formula correctly computes the running total of sales ordered by month?

A SUM([Sales])

B TOTAL(SUM([Sales]))

C WINDOW_SUM(SUM([Sales]), FIRST(), LAST())

D RUNNING_SUM(SUM([Sales]))

💡 Hint

Think about which function accumulates values over a range.

RUNNING_SUM accumulates the sum of sales in order, producing a running total. TOTAL returns the total for the partition, WINDOW_SUM sums over a window but needs specific offsets, and SUM just sums the current row.

❓ visualization

intermediate

Best Visualization for Running Total Trend

You want to show the running total of sales over time to your manager. Which visualization type best shows the cumulative trend clearly?

A Pie chart showing sales distribution by month

B Bar chart showing monthly sales side by side

C Line chart with running total on Y-axis and time on X-axis

D Scatter plot of sales vs. month

💡 Hint

Think about which chart type shows trends over time smoothly.

A line chart is ideal for showing cumulative trends over time because it connects points smoothly and shows growth clearly. Bar charts and pie charts do not show accumulation well.

🧠 Conceptual

advanced

Understanding Partitioning in Running Totals

In Tableau, you apply a running total table calculation on sales partitioned by region and ordered by month. What happens if you remove the partitioning by region?

A The running total will show only the first region's sales

B The running total will accumulate sales across all regions combined over time

C The calculation will produce an error due to missing partition

D The running total will reset for each region separately

💡 Hint

Partitioning controls where the running total resets.

Without partitioning by region, the running total sums sales across all regions as one group, accumulating over time without resetting.

🔧 Formula Fix

advanced

Fixing Incorrect Running Total Calculation

You created a running total of sales by month but notice the total resets unexpectedly within the same year. Which option explains the likely cause?

A The calculation is ordered by sales amount instead of date

B The table calculation is partitioned by month instead of year

C The running total uses WINDOW_SUM instead of RUNNING_SUM

D The data source has missing months causing reset

💡 Hint

Ordering affects how running totals accumulate.

If the running total is ordered by sales amount rather than date, the calculation resets unexpectedly because the sequence is not chronological.

🎯 Scenario

expert

Running Total with Multiple Dimensions and Filters

You have sales data by region, product category, and month. You want a running total of sales by month that ignores filters on product category but respects filters on region. How do you configure the running total calculation in Tableau?

A Use RUNNING_SUM(SUM([Sales])) with context filter on region and exclude product category filter

B Use RUNNING_SUM(SUM([Sales])) with all filters applied normally

C Use WINDOW_SUM(SUM([Sales])) partitioned by product category and region

D Use RUNNING_SUM(SUM([Sales])) and apply product category filter as context filter

💡 Hint

Context filters affect calculation order and what data is included.

To ignore product category filters but respect region filters, set region filters as context filters and exclude product category filters from context. This way, running total respects region but ignores product category filtering.