Running total in Tableau - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a running total in Tableau?

A running total is a cumulative sum of a measure that adds values from the start up to the current point in a sequence, like adding daily sales one day after another.

beginner

How do you create a running total in Tableau?

You create a running total by using the 'Quick Table Calculation' feature and selecting 'Running Total' on a measure in your view.

beginner

What is the difference between a running total and a simple sum?

A simple sum adds all values together without order, while a running total adds values step-by-step in a sequence, showing the total up to each point.

intermediate

Why is sorting important when using running totals?

Sorting ensures the running total adds values in the correct order, like by date, so the cumulative sum makes sense over time.

intermediate

Can running totals be reset in Tableau? How?

Yes, running totals can reset by partitioning the data, for example, restarting the total for each category or region using the 'Compute Using' settings.

What does a running total show in Tableau?

A Difference between values

B Cumulative sum of values in order

C Maximum value only

D Average of all values

A running total adds values step-by-step in order, showing the cumulative sum.

Which Tableau feature helps create a running total quickly?

A Data Blending

B Filter Shelf

C Parameter Control

D Quick Table Calculation

Quick Table Calculation lets you apply running total easily on a measure.

Why must data be sorted correctly for running totals?

A To filter out unwanted data

B To change colors of bars

C To ensure cumulative sums add in the right sequence

D To create a pie chart

Sorting ensures the running total adds values in the correct order, like by date.

How can you reset a running total in Tableau?

A By partitioning data using 'Compute Using'

B By changing the color palette

C By adding a filter

D By exporting data

Partitioning data resets the running total for each group or category.

Which of these is NOT true about running totals?

A They ignore the order of data

B They can be created with Quick Table Calculation

C They show cumulative sums over a sequence

D They can reset by partitioning

Running totals depend on the order of data; ignoring order would give wrong results.

Explain how to create and use a running total in Tableau.

Think about adding values step-by-step in order.

Describe why sorting and partitioning matter when working with running totals.

Consider how totals add up over time or categories.