Alerts from the chat_queue_stats_rt table
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.