Forum Discussion
How to show queue time in a visual.
Hello everyone,
I'm relatively new to Power BI and could use some guidance. I might not be framing my questions or providing sample data in the best way, so please let me know if adjustments are needed.
My current project involves mimicking the concept of "on-hold" calls in a call center and displaying this information visually for better insights. Specifically, I want to create a visual that illustrates how long a job stays in the queue and whether there are multiple jobs in the queue.
Any advice, examples, or pointers in the right direction would be greatly appreciated!
Here is a sample of my data.
| CreateDate | CreateTime | StartDate | StartTime | EndDate | EndTime | QueueTime | RunTime | Status | User Name |
| Friday, July 7, 2023 | 4:49:26 PM | Friday, July 7, 2023 | 4:50:32 PM | Friday, July 7, 2023 | 5:26:12 PM | 1 | 35 | Success | user3 |
| Saturday, July 8, 2023 | 12:12:27 AM | Saturday, July 8, 2023 | 12:14:29 AM | Saturday, July 8, 2023 | 12:35:51 AM | 2 | 21 | Success | user3 |
| Tuesday, July 11, 2023 | 2:13:52 PM | Tuesday, July 11, 2023 | 2:29:00 PM | Tuesday, July 11, 2023 | 2:55:34 PM | 15 | 26 | Success | user4 |
| Wednesday, July 12, 2023 | 8:13:41 PM | Wednesday, July 12, 2023 | 8:15:09 PM | Wednesday, July 12, 2023 | 8:37:51 PM | 1 | 22 | Success | user3 |
| Monday, July 17, 2023 | 5:00:35 PM | Monday, July 17, 2023 | 5:48:02 PM | Monday, July 17, 2023 | 5:50:18 PM | 47 | 2 | Success | user4 |
| Monday, July 17, 2023 | 7:42:36 PM | Monday, July 17, 2023 | 9:55:33 PM | Monday, July 17, 2023 | 9:55:53 PM | 132 | 0 | Success | user3 |
| Monday, July 17, 2023 | 8:51:14 PM | Monday, July 17, 2023 | 11:14:56 PM | Monday, July 17, 2023 | 11:16:18 PM | 143 | 1 | Success | user5 |
| Tuesday, July 18, 2023 | 3:07:15 AM | Tuesday, July 18, 2023 | 9:44:05 PM | Tuesday, July 18, 2023 | 9:44:25 PM | 1116 | 0 | Success | user3 |
| Wednesday, July 19, 2023 | 4:26:03 PM | Thursday, July 20, 2023 | 8:55:44 PM | Thursday, July 20, 2023 | 8:57:02 PM | 1709 | 1 | Success | user5 |
| Thursday, July 20, 2023 | 3:06:38 AM | Friday, July 21, 2023 | 3:44:27 PM | Friday, July 21, 2023 | 5:40:08 PM | 2197 | 115 | Success | user2 |
| Friday, July 28, 2023 | 4:40:39 PM | Sunday, July 30, 2023 | 5:35:18 AM | Sunday, July 30, 2023 | 6:00:03 AM | 2214 | 24 | Success | user3 |
| Friday, July 28, 2023 | 4:42:30 PM | Sunday, July 30, 2023 | 6:00:17 AM | Sunday, July 30, 2023 | 6:38:07 AM | 2237 | 37 | Success | user3 |
| Tuesday, August 1, 2023 | 9:23:07 PM | Tuesday, August 1, 2023 | 9:25:25 PM | Tuesday, August 1, 2023 | 9:43:35 PM | 2 | 18 | Success | user6 |
| Tuesday, August 1, 2023 | 9:24:43 PM | Tuesday, August 1, 2023 | 9:43:50 PM | Tuesday, August 1, 2023 | 10:02:06 PM | 19 | 18 | Success | user6 |
| Wednesday, August 2, 2023 | 2:56:01 AM | Wednesday, August 2, 2023 | 2:58:09 AM | Wednesday, August 2, 2023 | 2:58:29 AM | 2 | 0 | Success | user1 |
| Wednesday, August 2, 2023 | 8:49:08 AM | Wednesday, August 2, 2023 | 8:51:16 AM | Wednesday, August 2, 2023 | 8:51:36 AM | 2 | 0 | Success | user1 |
| Wednesday, August 2, 2023 | 9:10:48 AM | Wednesday, August 2, 2023 | 9:12:57 AM | Thursday, August 3, 2023 | 1:56:56 AM | 2 | 1003 | Fail | user1 |
| Wednesday, August 2, 2023 | 2:27:07 PM | Thursday, August 3, 2023 | 1:57:39 AM | Thursday, August 3, 2023 | 2:22:51 AM | 690 | 25 | Success | user6 |
| Wednesday, August 2, 2023 | 4:40:46 PM | Thursday, August 3, 2023 | 2:22:55 AM | Wednesday, August 16, 2023 | 11:48:02 AM | 582 | 19285 | Success | user5 |
| Wednesday, August 16, 2023 | 12:56:26 PM | Wednesday, August 16, 2023 | 12:58:38 PM | Wednesday, August 16, 2023 | 12:58:59 PM | 2 | 0 | Success | user4 |
| Wednesday, August 16, 2023 | 1:03:41 PM | Wednesday, August 16, 2023 | 1:05:56 PM | Wednesday, August 16, 2023 | 1:35:37 PM | 2 | 29 | Success | user4 |
| Wednesday, August 16, 2023 | 2:55:46 PM | Wednesday, August 16, 2023 | 2:57:59 PM | Wednesday, August 16, 2023 | 5:02:40 PM | 2 | 124 | Success | user9 |
I would like a visual that looks something like this.
and this
Thanks
Jason
- Anonymous2 years ago
Hi jb_graphic ,
I made some attempts and you can check the results as follows, you can change it yourself in specific cases:
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
- AnonymousNot applicable
Hi jb_graphic ,
I made some attempts and you can check the results as follows, you can change it yourself in specific cases:
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.