#WOW2026 | Week 4 | Can you create a dynamic moving average?

/ Tableau, Workout Wednesday / By

Introduction

Happy New Year everyone, my turn comes round awfully quickly these days.

As it’s still the start of 2026, I didn’t want to go too hard too quick. Hopefully this isn’t too bad. We are flexing our Table Calc, Date and Order of Operations skills in this challenge. Have fun!

Click to open in Tableau Public

Requirements

  • Dashboard Size: 800×800
  • One sheet
  • 3 parameters
  • A date calc that can change levels between Quarter, Month & Week.
  • 1 parameterised Moving average calc. Only looking back X months (remember if it says -2 that’s actually a 3 month/week etc)
  • Filter to show the last X time frame
  • Format however you like

Dataset

Superstore available from here.

Attribute

When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration.  Also include the hashtag #WOW2026 in your description to make it searchable!

Share

After you finish your workout, share on Twitter and/or LinkedIn using the hashtag #WOW2026 #Tableau and tag @WorkoutWednsday

Solution

Interactive