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.