Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

12-Month Rolling Average in %

Hi,

 

I have the following data in my data model JOBDATE, JOBNAME, SLA_MET.

 

I have to calculate the OVERALL_SLA_MET% for each day and month.

 

On 01/01, 4 jobs met SLA and 1 job missed SLA, so overall SLA_MET% is 80% (4/5)

Similarly, on 01/04, 2 jobs met SLA, so overall SLA_MET% is 40% (2/5)...so on and so forth.

 

mockdata.JPG

 

I'm able to get the overall SLA_MET% for months also using the same logic. 

 

However, i want a KPI to display the rolling 12 months average of the OVERALL SLA_MET%.

I have attached a test qvw file with 7 days of data. For the purpose of this question please consider rolling 3 days average.

I can use the same logic for months in my app.

 

Any help would be greatly appreciated!

 

Thanks,

Yash

0 Replies