Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
yashcena
Contributor III
Contributor III

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