Calculate Rolling Average Hours for 30 weeks

[yashcena]

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!

Thanks,

YASH