Determine Number of waiting calls in a queue

[Thomas_MedOne]

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.

[djurecicK2 · Accepted solution]

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))

[Thomas_MedOne]

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.

[v-nuoc-msft · Accepted solution]

Hi @Thomas_MedOne 

@djurecicK2 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.

[djurecicK2 · Accepted solution]

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))

[Thomas_MedOne]

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"))