Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Average cases handled per agent in Sorting and Grouping report
6 views
Skip to first unread message
T2B
Oct 8, 2012, 6:00:57 PM10/8/12
to
In a report using sorting and grouping by [WeekClosed], [Agent]
counting [CasesHandled]
I would like an average number of CasesHandled per Agent in the
WeekClosed header.
For example
WeekClosed 10/8/2012 CasesHandled: 36 Average Cases Handled Per
Agent: 12
Agent,RunningSum,Count(CasesHandled)
Bill 1 14
Mary 2 12
Fred 3 11
Total 36
I would like the average cases handled per agent, (36/3 = 12) in my
WeekClosed header.
My report does all but the average. How can I do that?
Thank you.
counting [CasesHandled]
I would like an average number of CasesHandled per Agent in the
WeekClosed header.
For example
WeekClosed 10/8/2012 CasesHandled: 36 Average Cases Handled Per
Agent: 12
Agent,RunningSum,Count(CasesHandled)
Bill 1 14
Mary 2 12
Fred 3 11
Total 36
I would like the average cases handled per agent, (36/3 = 12) in my
WeekClosed header.
My report does all but the average. How can I do that?
Thank you.
0 new messages