Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to do an average of the below but, I'm not getting the correct result.
=Num(Avg({$<EMPLOYEE=,TEAM=p()>} CALLS_ANSWERED),'#,##0')
Description | Individual | Team |
---|---|---|
Calls Answered | 2,000 | Avg of the Team |
Average Handle Time | 22:37 | 25:11 |
Also, i have a couple of text objects to get different call metrics. I would like the capability to have these
text objects printed altogether in a sheet (as seen in the above table). How should i do this? Can you please help? Thank you in advance for your assistance.
Thank you also Vishwarath for your help. Any bit of assistance really helped me get to what I needed.
Thank you both (Vishwarath & Sunny)! I really appreciate your kind help!
I would suggest you to mark helpful response which you might think will help other people landing on this thread for help. Since this is a pretty lengthy thread, it would be helpful for people to see some stand out responses.
Qlik Community Tip: Marking Replies as Correct or Helpful
Best,
Sunny
Hi Sunny T!
I have a follow-up question for you, if I may, which I know you'll be able to help me with. This is in connection with my previous problem, also using the Team's Avg. I'm trying to get Avg for Open Cases this time. 'O' is for Open record type and '0' is for Non Self-Service.
Below is the expression I used to get just the sum for each individual.
=Num(Count({$<RTYPE={'O'},CASES_RESP.SR_SS={'0'}>} DISTINCT CASES_RESP.NUM_SR),'#,##0')
I'm wondering what's the correct expression to get Avg for the Team? I used below expression but gave me a funky result.
=Num(Avg({$<WM_TEAM = p(WM_TEAM),RTYPE={'O'},CASES_RESP.SR_SS={'0'}, EMPLOYEE_NAME>} Aggr(Sum({$<WM_TEAM = p(WM_TEAM), RTYPE={'O'},CASES_RESP.SR_SS={'0'}, EMPLOYEE_NAME>} DISTINCT CASES_RESP.NUM_SR), EMPLOYEE_NAME)),'#,##0')
Can you please help? Thanks in advance.
May be this:
=Num(Avg({$<WM_TEAM = p(WM_TEAM), EMPLOYEE_NAME, RTYPE={'O'},CASES_RESP.SR_SS={'0'}>} Aggr(Count({$<WM_TEAM = p(WM_TEAM), EMPLOYEE_NAME, RTYPE={'O'},CASES_RESP.SR_SS={'0'}>} DISTINCT CASES_RESP.NUM_SR), EMPLOYEE_NAME)),'#,##0')
The output looks a lot better! I won't be able to know if the numbers are right yet. Need to wait until it gets tested. But Thank You!!! 🙂
Hi Sunny T!
I want to get the sum of the Avgs which is equivalent to 32. Can you please help me achieve that by modifying the expression below?
full_date | NoOfCalls | NoOfEmployees | Avgs |
11/1/2016 | 270 | 33 | 8.1818182 |
11/2/2016 | 261 | 32 | 8.15625 |
11/3/2016 | 260 | 33 | 7.8787879 |
11/4/2016 | 265 | 33 | 8.030303 |
32 |
=Num(Aggr(Sum({$<WM_TEAM = p(WM_TEAM), EMPLOYEE_NAME>} CALLS.CALLS_ANSWERED),EMPLOYEE_NAME),'#,##0')/ (Avg(Aggr(Sum({<DAY_MASTER.FULL_DATE, EMPLOYEE_NAME >} CALLS.CALLS_ANSWERED),EMPLOYEE_NAME)))
Hoping for your kind assistance. Thanks.
So the expression above gives you the correct row level averages? you just want to get the total right?
Try this:
=Sum(Aggr(
Num(Aggr(Sum({$<WM_TEAM = p(WM_TEAM), EMPLOYEE_NAME>} CALLS.CALLS_ANSWERED),EMPLOYEE_NAME),'#,##0')/ (Avg(Aggr(Sum({<DAY_MASTER.FULL_DATE, EMPLOYEE_NAME >} CALLS.CALLS_ANSWERED),EMPLOYEE_NAME)))
, YourDimensions4mThisChart))
I tried your above expression but, it's giving me just a result of 1.
You did not respond to my question above?
"So the expression above gives you the correct row level averages? you just want to get the total right?"
Yes. Just the sum of the Averages which in the above given example...the result should be 32.