Reporting and Analytics for Service

Get Involved. Join the Conversation.

Topic

    Edgardo Lineros
    Maxed out chats
    Topic posted February 8, 2019 by Edgardo LinerosGreen Ribbon: 100+ Points 
    29 Views, 1 Comment
    Title:
    Maxed out chats
    Summary:
    Report creation for resource allocation
    Content:
    We are working on resource allocation KPIs and attempting to build a maxed out chats report. To the business, "maxed out" means an agent is handling 3 chats at one time. We want to see a report that shows when an agent was handling more than one chat at a time, the number of chats they were handling at once, and the duration (minutes) those chats were overlapping. A mockup of this report is in the attached file, column J-M, blue header:
    05da50d9ed4487b3342ef7f62c1558e4 

    Also in the attached file, we have data that we can get from the system (columns A-F). By looking at requested time stamp (E) and completed time stamp (F) we can tell when chats are overlapping. Columns G & H are manually added for the purpose of illustrating what we are trying to achieve.
     
    Can you tell us if there is a way to achieve this logic?
     
    Thank you in advance!

    Comment

     

    • Justin

      i think you may want to look at the report called 'Chat Concurrency Factor' that may help with what you are trying to do