topic Re: Determine Number of waiting calls in a queue in DAX Commands and Tips

Determine Number of waiting calls in a queue

Thomas_MedOne — Fri, 14 Jun 2024 14:50:27 GMT

I am reporting on call queue data pulled out of Zoom.

What I have in my table is:

Time Call Started (the first moment it came into the queue) Ex: 02/23/2024 2:49:00am

Total duration they were in the queue and handled. Ex: (minutes) 4.7333

I am asked to report on how many calls were in the queue at any given time. How many were waiting in the queue. I assume there is some way to do this because I know when the call started and how long it lasted. So I should be able to see how it stacks up and then report on it.

I have no idea how to create a measure or even just a report on something like this.

Re: Determine Number of waiting calls in a queue

djurecic — Fri, 14 Jun 2024 15:51:30 GMT

Hi Thomas_MedOne ,

I would create a seperate date/time table and do not relate it to the zoom data table.

Create a slicer on that table.

Then create a measure like this

CallsInQueue=

var SelectedDateTime= Selectedvalue(DateTimeTable[DateTime])

return

Calculate(Countrows([ZoomDataTableName]), FILTER(ZoomDataTableName, ZoomDataTableName[DateTime]= SelectedDateTime))

Re: Determine Number of waiting calls in a queue

Thomas_MedOne — Fri, 14 Jun 2024 20:24:58 GMT

I tried creating a Date/Time table with this below. It's all midnight. How do I create one with each hour of the day? Perhaps every half hour?

DateTime = ADDCOLUMNS(CALENDAR (DATE(2023,12,1), DATE(2030,12,31)),"DateTT",Format([Date],"dd/mm/yyyy h:nn AMPM"))

Re: Determine Number of waiting calls in a queue

Anonymous — Mon, 17 Jun 2024 01:42:08 GMT

Hi Thomas_MedOne

djurecic Thank you very much for your prompt reply and here allow me to share some of it.

To create an hourly or half-hourly date/schedule in Power BI, you can try the following:

Create a table.

For hourly intervals, the incremental value 1/24 can be used.

Table = GENERATESERIES(DATE(2021,1,1), NOW(), 1/24)

For half-hour intervals, you can use the 1/48.

Table = GENERATESERIES(DATE(2021,1,1), NOW(), 1/48)

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Determine Number of waiting calls in a queue

Thomas_MedOne — Wed, 19 Jun 2024 13:47:51 GMT

I am not sure why a solution was accept on my post. I haven't tried this yet because I have payroll this week and do not have the time to try this out yet.