How to Calculate Moving Average in Tableau

By: Oliver Linley

Ollie lives in Cape Town, South Africa, and is passionate about all things data - and all things Tableau! If you have a question, feel free to reach out to him directly via email.

How do you track trends in Tableau when there is a high degree of fluctuation in our data? Try using a moving average!

A moving average is an average of a collection of points around a specified point. For each mark in our view, Tableau will calculate the average of the mark's value and the value of several previous marks. This creates an average value that "moves" over time.

Our fluctuations can be smoothed out to some degree, giving us a clearer explanation of the trends in our data over time.

Want help setting something like this up? Book an hour with Ollie! Want to dive deep into Tableau? Check out our upcoming Tableau classes!

Resources

Want to keep learning foundational skills in Tableau? Sign up for our weekly newsletter so you never miss new blog posts, videos and events!

Expert Tableau Consulting Available Now

How to Hide Data with a Filter in Tableau (LOOKUP, LAST, FIRST)

0