5 Replies Latest reply: Oct 13, 2017 7:21 AM by Sunny Talwar RSS

    7 day rolling avg

    Tirumal Dhulipudi

      Hi All, Need Help..

       

      I want to create a 7 day rolling average but I need to use Month year on X-axis.


      I am using: rangeavg(above(sum(sales),0,7))


      X Axis: Month Year


      Rolling average will be based on Month year, I need to calculate it based on 7 days sales.


      thumbnail_Rollin.jpg