How to Calculate Moving Average in Tableau

How to Calculate Moving Average in Tableau

6.250 Lượt nghe
How to Calculate Moving Average in Tableau
🔔 Book a FREE 15-min Tableau call here: https://forms.gle/DfW6TJkMjsmBytig8 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: https://onenumber.biz/onenumber-tableau-classes •Book an hour to work with Ollie: https://www.eventbrite.com/e/tableau-office-hours-with-ollie-linley-eastern-time-tickets-439769641837 •Subscribe to the OneNumber Newsletter: https://onenumber.biz/newsletter •Follow Ollie Linley on LinkedIn: https://www.linkedin.com/in/oliverlinley/ Resources: •Example Tableau Workbook: https://public.tableau.com/views/MovingAverage_16993531540140/MovingAverage?:language=en-GB&publish=yes&:display_count=n&:origin=viz_share_link 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