Moving average in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to calculate a 3-period moving average using Tableau's WINDOW_AVG function.

Tableau

WINDOW_AVG(SUM([Sales]), -2, [1])

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

A0

Attempts:

3 left

💡 Hint

Common Mistakes

Using positive numbers for offsets instead of negative for previous rows.

Confusing the start and end offsets.

The WINDOW_AVG function calculates the average over a range of data points. The second argument is the start offset, and the third argument is the end offset. For a 3-period moving average, the window includes the current row and the two previous rows, so the end offset is 0.

2fill in blank

medium

Complete the code to calculate a 5-period moving average including the current and previous 4 periods.

Tableau

WINDOW_AVG(SUM([Profit]), [1], 0)

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

A5

B-5

C4

D-4

Attempts:

3 left

💡 Hint

Common Mistakes

Using -5 instead of -4 for the start offset.

Using positive offsets which look forward instead of backward.

For a 5-period moving average including the current and previous 4 periods, the start offset is -4 and the end offset is 0.

3fill in blank

hard

Fix the error in the moving average calculation to correctly compute a 7-day moving average.

Tableau

WINDOW_AVG(SUM([Quantity]), [1], 0)

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

A6

B-6

C-7

D7

Attempts:

3 left

💡 Hint

Common Mistakes

Using -7 which excludes the current day.

Using positive offsets which look forward.

A 7-day moving average includes the current day and previous 6 days, so the start offset should be -6.

4fill in blank

hard

Fill both blanks to calculate a centered 3-period moving average (one previous, current, and one next period).

Tableau

WINDOW_AVG(SUM([Revenue]), [1], [2])

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

A-1

B0

C1

D2

Attempts:

3 left

💡 Hint

Common Mistakes

Using 0 for both offsets which only includes the current row.

Using offsets that are not symmetric.

A centered 3-period moving average includes one previous period (-1), the current period (0), and one next period (1).

5fill in blank

hard

Fill all three blanks to calculate a moving average of [Sales] over the last 4 periods excluding the current period.

Tableau

WINDOW_AVG(SUM([1]), [2], [3])

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

A[Sales]

B-4

C-1

D0

Attempts:

3 left

💡 Hint

Common Mistakes

Including the current period by using 0 as end offset.

Using the wrong field inside SUM.

To calculate the moving average over the last 4 periods excluding the current, use SUM([Sales]) with start offset -4 and end offset -1.