6 Replies Latest reply on Nov 17, 2018 6:13 PM by Ethan Chan

    exponentially-weighted moving average (EWMA)

    David Thomas

      Under Table Calculations I'm using "Calculation Type" as "Moving Calculation" and Summarize values using "Average" going back 3 previous values.

      I notice a customize button on the bottom left that utilizes the WINDOW_AVG function like: WINDOW_AVG(SUM([Closed]), -3, 0)

       

      I'm curious if Tableau has a way to utilize EWMA (exponentially-weighted moving average) aka EMA (exponential moving average) or if perhaps someone has come up with an equivalent formula?

       

      More on EWMA/EMA here:

      http://en.wikipedia.org/wiki/EWMA#Exponential_moving_average