How to Calculate Moving Average in Tableau
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.
Connect with us:
•Upcoming Tableau Classes: onenumber.biz/onenumber-table...
•Book an hour to work with Ollie: www.eventbrite.com/e/tableau-...
•Subscribe to the OneNumber Newsletter: onenumber.biz/newsletter
•Follow Ollie Linley on LinkedIn: / oliverlinley
Resources:
•Example Tableau Workbook: public.tableau.com/views/Movi...
Chapters:
0:00 What is a moving average?
1:21 Moving Average Example
1:58 Build a Moving Average
4:30 Upcoming Tableau Classes
4:55 Save and Edit Table Calculation
Пікірлер: 3
Need help with your Tableau calculations? Schedule an hour with Ollie! www.eventbrite.com/e/tableau-office-hours-with-ollie-linley-eastern-time-tickets-439769641837 | Ready to master Tableau? Check out our lineup of upcoming classes! www.eventbrite.com/o/onenumber-15678294163
Is there a way to create a filter for moving average for different data values?
@onenumbertableau
Ай бұрын
Sure! What values are you trying to filter? If you can give us a little more info, we can help!