5 Replies Latest reply on Jan 25, 2018 7:51 AM by Shinichiro Murakami

    Avg the running total

    hridesh.selarka

      Hello community,

       

      I am trying to add a column with AVG of running total. I have several weeks of columns but I am hiding it as I want to see only last 6 weeks in my display. This will be updated on weekly basis.

      I am looking for an output as in shown here in excel format. I tried multiple ways but couldn't get the result I am looking for. I tried the "WINDOW_AVG(RUNNING_SUM(COUNT([Order ID])))" but it adds the rows for every activity.  Please suggest what's the best way to add the AVG of Running total ?

       

      Thank you

      cap6.PNGcap4.PNGcap3.PNG

       

      Message was edited by: John Doe