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.

[sunny_talwar]

Although I am glad it is working, I don't see why you would need ALL, I would think that this alone should work

=Sum({1} Aggr((Sum( {$<WM_TEAM = p(WM_TEAM),EMPLOYEE_NAME=>}total<DAY_MASTER.FULL_DATE>  CALLS.CALLS_ANSWERED)/
Count({$<WM_TEAM = p(WM_TEAM),EMPLOYEE_NAME=>} Total<DAY_MASTER.FULL_DATE>EMPLOYEE_NAME)),DAY_MASTER.FULL_DATE))

[xarapre7]

Both 'All' and {1} in the expression are giving the same result.  What should be the difference?

[sunny_talwar]

All = TOTAL {1} where TOTAL is not needed in a dimension-less object such as text box object because it is already doing a total. All is something which I have heard might get discontinued in the near future, so I guess you would be safe to use {1} instead of All;

[xarapre7]

Okay.  Thanks.  I appreciate all the help!

[xarapre7]

Hi Sunny T!

The expression below includes CALLS_ANSWERED that are greater than 0.  How can I include in this expression to exclude the number of agents who have 0 CALLS_ANSWERED for a specific time frame?  I only want the count of agents with CALLS_ANSWERED >0 for its denominator.  Thank you in advance!

=Num(Sum({1} Aggr((Sum( {$<WM_TEAM = p(WM_TEAM),EMPLOYEE_NAME=>}total<DAY_MASTER.FULL_DATE>  CALLS.CALLS_ANSWERED)/
Count({$<WM_TEAM = p(WM_TEAM),EMPLOYEE_NAME=>} Total<DAY_MASTER.FULL_DATE>EMPLOYEE_NAME)),DAY_MASTER.FULL_DATE)),'#,##0') 

[sunny_talwar]

I think this has been already a very complicated thread and its time we open a new thread for a new requirement. You can always refer to this thread in your new thread, but creating a new thread will help you get more eyes + it will help future visitors running into similar issues with more ease.

[xarapre7]

Okay.  I'll go ahead and repost my last msg.  Thanks.

[sunny_talwar]

Thanks