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:




      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!