Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
Can you please help me to sum the Averages? Please see attached sample in Excel.
The expression below is giving me the Average of Calls. I need the sum of the Averages of the calls by the number of employees by month.
=Num(Sum({$<EMPLOYEE_NAME=,WM_TEAM=p()>} CALLS.CALLS_ANSWERED),'#,##0')/Count({$<EMPLOYEE_NAME=,WM_TEAM=p()>} DAY_MASTER.FULL_DATE)
Hoping for your kind help.
Thanks.
=Num(Sum({$<EMPLOYEE_NAME=,WM_TEAM=p()>} TOTAL CALLS.CALLS_ANSWERED),'#,##0')/Count({$<EMPLOYEE_NAME=,WM_TEAM=p()>} TOTAL DAY_MASTER.FULL_DATE)
Or just add a total row on the chart!