Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Help needed to create a detailed chat report

edited Mar 2, 2021 2:20AM in Reporting & Analytics for B2C Service 2 comments

Content

i need to create a chat report with following below column, 

Date
Queue
Interval
Chats Offered
Chats Completed
Abandoned Chats
SLAs Met
Average Wait Time
Idle Sessions
Max Wait Time
Agents Available
Agents Online
Chats Active

Service Level %
Total Wait time
Average Handle Time
Idle Time
Utilization
Chats in Queue
Transfers Completed
Conferences Completed

i found most of the columns in chat_queue_stats table however i don't understand how to add below column, chat_queue_stats table doesn't allow to join any table except Queue, please help me to make this this report.


Service Level %
Total Wait time

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!