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.

[vishsaggi]

You database tables has got some duplicate data i believe. I am not sure if that is correct but the count it is doing for the Avg is incorrect so i used distinct it is coming out correctly so just use this expression in your Avg Team text object as :

=Num(Avg(Total{$<WM_TEAM=>} DISTINCT CALLS.CALLS_ANSWERED) ,'#,##0')

[xarapre7]

Looks like it's coming through right now.  Thank you so much for your help!

By the way, regarding my 2nd question...what's the best way to do that the whole metrics table can be exported in excel and printed out?

[sunny_talwar]

I don't like the fact that we are doing Distinct Avg() here... What happens if two of the Agents happen to have the same exact number. Then only one of them will be picked. I would rather do a Avg(Aggr(....)) to make sure that I take both agents into account...

[vishsaggi]

I cant think of any other way, There are many text objects you used. Can you create this as a straight table or a pivot table getting all the expressions in a single table. It is little time consuming now to work on this. Apologies for that, if time permits will look into that again. However, make sure you data is correct with regards to CALLS.CALLS_ANSWERED seems duplicate information is coming through. And change the expressions where ever this field is used for calculations.

[vishsaggi]

Oops I missed that.

[xarapre7]

I tried the Avg(Aggr(Sum(...), but I had the ' - ' again as the result. 

[sunny_talwar]

Testing and will get back to you....

[sunny_talwar]

I guess I am not clear what the expected output is? vishsaggi‌ is giving me 4 when I select Abas. Is that the number you are looking to get?

[xarapre7]

Yes.  His Team should have an Avg of 4.

[sunny_talwar]

I have no idea how you came with that number 4, but this expression

=Num(Avg(Total{$<WM_TEAM=>} DISTINCT CALLS.CALLS_ANSWERED) ,'#,##0')

Is just giving Avg(CALLS.CALLS_ANSWERED) by one employee.... this is not for the team. The number that it gives is 3.875, but due to number formatting, the number is rounded off to 0 decimals. If this is what you want, then you can use this:

=Num(Avg(DISTINCT CALLS.CALLS_ANSWERED) ,'#,##0')

But how is this team average? I have a feeling that this is not what you want, but I might be wrong.

Best.

Sunny