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!