Skip to main content
cancel
Showing results for 
Search instead 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

Reply
Thomas_MedOne
Helper II
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
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

v-nuoc-msft
Community Support
Community Support

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

v-nuoc-msft
Community Support
Community Support

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors