How to determine the maximum number of customers that were waiting in the chat queue for a given...

Content

Hello,

A client has asked for a report that includes a metric for the maximum number of customers that were waiting in the chat queue for a given date/time range. They recognize that all customers will technically be waiting for a period of time before they are engaged but they are trying to identify for given date range of 'chats.requested', what is the highest number of customers that were waiting for a chat to be accepted.

I attempted to get the value via the expression 'max(chat_queue_stats.cur_users_waiting)' but that is not returning an appropriate value. How else could I obtain their desired value?