Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
xarapre7
Creator II
Creator II

12-Mo Avg of an Average Turn Around Time

I'm trying to get the 12-Mo Average of the average turn around time using the expression:

=Num(rangesum(above(Avg({$<[Group]={'AME'}>}[Working Days])),0,12),00) but, it's not giving the expected result as below.

    

MonthAverage Turn Around Days12-Mo AvgExpected  12-Mo Avg
Jan-2015912
Feb-2015921
Mar-2015921
Apr-2015921
May-2015721
Jun-2015919
Jul-2015721
Aug-2015719
Sep-2015919
Oct-20151421
Nov-20151126
Dec-201510239
Jan-20169229
Feb-20169219
Mar-201610219
Apr-2016132210
May-2016142510
Jun-2016152611
Jul-2016152711
Aug-2016112712
Sep-20161123

12

Can you please help me with the correct expression to get the expected 12-Mo Average? This is actually getting the Average of an Average which is what i need.  Any help you could help is highly appreciated.  Thank you.

3 Replies
sunny_talwar

May be try RangeAvg() instead of RangeSum

=Num(RangeAvg(Above(Avg({$<[Group]={'AME'}>}[Working Days])), 0, 12), '00')

xarapre7
Creator II
Creator II
Author

It works as expected.  Thanks!

sunny_talwar

May be this if you only want to see the numbers starting Dec-2015

=If(RowNo() > 11, Num(RangeAvg(Above(Avg([Average Turn Around Days]), 0, 12)), '00'))


Capture.PNG