02-01-2016 05:30 AM
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
02-08-2016 06:33 AM
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
03-08-2016 10:41 AM
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
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide