Skip to main content
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

12-Month Rolling Average in %



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) on and so forth.




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!




0 Replies