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]

I may have gotten the Avg of 4 when I filtered for the specific month for a team.  But, what  I want really is the Avg of the Team. So what is the correct expression for that?  Kindly help.  Thank you in advance.

[sunny_talwar]

Is this what you want?

=Avg({$<WM_TEAM = p(WM_TEAM), EMPLOYEE_NAME>}Aggr(Sum({$<WM_TEAM = p(WM_TEAM), EMPLOYEE_NAME>} CALLS.CALLS_ANSWERED), EMPLOYEE_NAME))

Where I get an average call of 1253.5814. How did I get this?

I sum the call answered by the individual Employees within the team and I find there average

Does this look right to you? The above chart is showing the 1253.5814 based on selection in the employee Name Abas, Lendion Zachary

[xarapre7]

Sunny T,

The results you have above is actually just for individuals which is also what I got using the following expression:

=Num(Sum({$} CALLS.CALLS_ANSWERED),'#,##0') .  It's not the Avg of the Team. 

[sunny_talwar · Accepted solution]

I am talking about this number my friend

It is the Avg of the sum of calls answered by each of the employees in the whole team.

[sunny_talwar]

I guess what is the number you are looking to get? We have a sample to work with, but we don't know what is the output you are looking to get

[xarapre7]

Oh yeah.... that is the Avg for the Team.  That is correct!  Thanks.

[sunny_talwar]

Awesome, I am glad we were finally able to reach your goal. In a text box object, you can use this expression:

=Avg({$<WM_TEAM = p(WM_TEAM), EMPLOYEE_NAME>}Aggr(Sum({$<WM_TEAM = p(WM_TEAM), EMPLOYEE_NAME>} CALLS.CALLS_ANSWERED), EMPLOYEE_NAME))

[xarapre7]

I'm so glad you were able to help me with this.  I won't be able to figure this out by myself.  Thank you so much!

[sunny_talwar]

I am glad we were able to help you here

Best,

Sunny

[vishsaggi]

Thanks Sunny for your expertise here. Opens up few missing thoughts.