Hello All!
I need help in getting the rolling 12-month Avg for the Avg Speed of Answer (ASA) in minutes & seconds (eg, 4:25).
And how to get the previous month's data? Can you please help?
Variable to get the actual ASA:
vActualASA = Minute((((Sum({<CALLS.CALLS_ANSWERED={'>0'}>}CALLS.WAIT_TIME)/Sum(CALLS.CALLS_ANSWERED))/60)/24)/60) & ':' & Num(Second((((Sum({<CALLS.CALLS_ANSWERED={'>0'}>} CALLS.WAIT_TIME)/Sum(CALLS.CALLS_ANSWERED))/60)/24)/60),'00')
Code for 12-month Avg
=sum({<[DAY_MASTER.FULL_DATE]={">=$(=MonthStart(Now(),-1))<=$(=MonthEnd(Now(),-12))"},DAY_MASTER.YEAR=,DAY_MASTER.MONTH=,DAY_MASTER.QUARTER=>}vActualASA)
Thanks in advance!
xarapre7
