cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II

## Determine Number of waiting calls in a queue

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.

2 ACCEPTED SOLUTIONS
Super User

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

Community Support

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

4 REPLIES 4
Helper II

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.

Community Support

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

Super User

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

Helper II

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.