5 Replies Latest reply on Nov 23, 2016 5:44 AM by David Li

    A difficult calculation in Tableau: Decay

    Fabio Guimaraes

      Hi There!

      I can't make the calculation attached in Tableau. Any help?

       

      I'm trying to create a new column using another column as reference.

      The task is to create a kind of "moving average" using 50% of the row before my actual row plus my actual row but not considering this math for the first row of data.

      Here is a simple example:

      Column A     New Column            Explanation of the task

      10                       10                         (Dont consider the math)

      20                         25                        (50% of 10 +20)

      50                         63                         (50% of 25 +50)

      15                         46                          (50% of 63 +46)