Qlik Community

Qlik Sense App Development

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

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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