Peak number of calls in queue

[PFCCWA]

Hello

I am trying to find the best way to report on peak call number in queue.
We have ICON/infomart.
in terms of switch we are using tserver/avaya.

So far i have managed to report on VQ mediation duration that shows how long they were in the queue for answer, diversion o abandon, but what i need to know is what was the maximum number of calls waiting in queue for a given day.  Through ccpulse reporting on group of queues object we know it went past a certain number but i cannot get that at the moment.
thanks.

[hsujdik]

Info Mart does not have such metric by default, neither through RAA, unfortunately.

What you could do is iterate for each second of the day and count the calls on active on the queue for that given second (between start_ts and end_ts on mediation_segment_fact table), and then returning the greatest value among all the tested seconds.

It is not pretty or even quick, but it is the only way (at least to my knowledge) to get this information from Info Mart