Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Thomas_MedOne
Helper III
Helper III

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
djurecicK2
Super User
Super User

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

View solution in original post

Anonymous
Not applicable

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.

View solution in original post

4 REPLIES 4
Thomas_MedOne
Helper III
Helper III

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.

Anonymous
Not applicable

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
Super User
Super User

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

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

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.