0 Replies Latest reply: Apr 16, 2018 8:19 AM by Yash Sinha RSS

    Calculate Rolling Average Hours for 30 weeks

    Yash Sinha

      I have the following columns in my data model:

       

      Captur2e.JPG

       

      I have to calculate the rolling average of hours a resource has spent on a particular project over last 30 weeks.

       

      I found some solutions online but I'm not able to use them for my requirement.


      Since I have date/month/quarter/year filters in my dashboard, should I be calculating the rolling average at app level or script level?


      Any help will be appreciated!


      Thanks,

      YASH