Avg of Calls and Print text objects

[xarapre7]

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.

[xarapre7]

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!

[sunny_talwar]

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

[xarapre7]

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.

[sunny_talwar]

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')

[xarapre7]

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!!!  🙂

[xarapre7]

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.

[sunny_talwar]

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))

[xarapre7]

I tried your above expression but, it's giving me just a result of 1.

[sunny_talwar]

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?"

[xarapre7]

Yes.  Just the sum of the Averages which in the above given example...the result should be 32.