1 Reply Latest reply on Feb 2, 2019 2:12 PM by Hari Ankem

    Dynamic Moving Average for last 4 weeks

    ankit.ravi

      I am trying develop a  viz. where i want to compare for example current day (Lets assume 02/01/2019 which is a Friday) revenue against previous 4 Fridays ( 01/25/19,01/18/19,01/11/19,01/04/19). As far as I know to achieve moving averages you either use window function or you can use a fixed date as a parameter and use it to achieve the moving average calculation.

       

      In my case, I want it to be dynamic, like if I want to limit to current month only I would still like to see L4 average for the 1st of the month.

       

      Please do let me know if you need any other detail from me to help solve the issue. I have attached the sample workbook with what I am trying to build.

       

      Thanks