Calls Handled & % Talk time as part of a Reason code report

[sarbarnes]

Team,

I have taken a standard Reason code report, which I show as columns of the time for each reason code by Agent. I have a customer who want to see Total Call time (Talk/Active), % Call time & number of calls handled, all within the same report.

The time Columns I believe I can sort , however adding the calls handled is proving difficult.

If anyone out there has done this already, please can you give me some pointers.

Thanks Sarah

[Jameson Gagnepain]

Sarah,

Due to the difference in "DateTime" usage between the tables involved in such a report, you will probably need to build this as an Anonymous Block report. For best report definition reusability, summarize all your reason code data into intervals by agent (i.e. half hours if you use half-hour intervals), then summarize your skill group data into intervals by agent, then join the two together on interval and agent.

-Jameson

[Ronald Reif]

Sarah, Have you looked into any 3rd party reporting solutions that have easy to create and modify custom/advanced reports to make your life easier with UCCX/UCCE platforms?  Please let me know if you are interested.

Ron Reif