Reporting and Analytics for Service

Get Involved. Join the Conversation.

Topic

    Pavol Procka
    Alerts from the chat_queue_stats_rt table
    Topic posted March 27, 2018 by Pavol ProckaSilver Crown: 22,500+ Points 
    27 Views, 3 Comments
    Title:
    Alerts from the chat_queue_stats_rt table
    Content:

    I am trying to create an alert for Chats Waiting. I was hoping to simply create an exception in the chat monitor report, however it will not let me do it if I am using the chat_queue_stats_rt table.

    To show the number of waiting chats, I am using the column chat_queue_stats_rt.cur_chats_waiting but when I try to add the exception with that expression it will not allow me. Looks like it is possible with the chat_queue_stats table, but that is not what I want as that data is delayed (I believe by up to 15 mins) and I am looking for real time alerting so that the waiting chats situation can be dealt with pro-actively.

    Any pointers?

    Version:
    Nov 2016

    Comment