Rolling period calculations in Tableau - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a rolling period calculation in Tableau?

A rolling period calculation shows data aggregated over a moving window of time, like the last 7 days or 3 months, updating as new data comes in.

intermediate

How do you create a 7-day rolling sum in Tableau?

Use a table calculation with WINDOW_SUM(SUM([Measure]), -6, 0) to sum the current day and previous 6 days.

beginner

What is the difference between a rolling average and a moving average?

They mean the same: average over a moving window of time, smoothing data to show trends.

intermediate

Why is it important to set the correct addressing and partitioning in Tableau rolling calculations?

Because it controls how Tableau moves through data to calculate the rolling period correctly, ensuring accurate results.

beginner

What does WINDOW_SUM(SUM([Sales]), -2, 0) calculate?

It sums the Sales for the current row and the two previous rows, creating a 3-period rolling sum.

Which Tableau function is commonly used for rolling period sums?

A AVG

B SUM

C WINDOW_SUM

D COUNT

WINDOW_SUM sums values over a specified window, perfect for rolling sums.

In a 7-day rolling sum, how many previous days are included besides the current day?

A 0

B 7

C 1

D 6

The current day plus 6 previous days make a 7-day rolling sum.

What does partitioning control in Tableau rolling calculations?

A The color of the chart

B Which data groups the calculation restarts for

C The font size

D The data source connection

Partitioning defines groups where the rolling calculation restarts.

Which of these is NOT a rolling period calculation?

A Year-to-date total

B Rolling sum

C Rolling average

D Moving median

Year-to-date total is cumulative from start of year, not a moving window.

What is the main benefit of using rolling period calculations?

A To smooth data and show trends over time

B To count distinct customers

C To change data colors

D To filter data by category

Rolling calculations smooth data by averaging or summing over time windows.

Explain how to build a 3-month rolling average in Tableau and why it is useful.

Think about summing or averaging over the current and previous 2 months.

Describe the role of addressing and partitioning in rolling period calculations in Tableau.

Consider how Tableau moves through rows and groups data.