Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

yashcena
New Contributor II

Calculate Rolling Average Hours for 30 weeks

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

Community Browser