Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi
I'm trying to build a chart that shows what procedures are taking up a resource's time throughout a single day. Kind of a timeline, but for a day. Procedures are composed out of steps. In the best case the result would look something like this:
I've tried a number of timeline and gantt visualizations, but they all seem to be focused on days and are quite rigid in terms of bending em for my needs.
Is there a way to build a visualization like this? It needs to be precise to the second of utilization.
Below is some sample data for a day in case it's needed
Sequence | Date | ProcName | ProcStart | ProcEnd | ProcDuration | StepName | StepStart | StepEnd | StepDuration |
1 | 01.01.2023 | Proc1 | 8:11:05 | 8:29:10 | 0:18:05 | Step1 | 8:11:05 | 8:11:07 | 0:00:02 |
1 | 01.01.2023 | Proc1 | 8:11:05 | 8:29:10 | 0:18:05 | Step2 | 8:11:16 | 8:11:46 | 0:00:30 |
1 | 01.01.2023 | Proc1 | 8:11:05 | 8:29:10 | 0:18:05 | Step1 | 8:12:38 | 8:12:40 | 0:00:02 |
1 | 01.01.2023 | Proc1 | 8:11:05 | 8:29:10 | 0:18:05 | Step3 | 8:12:46 | 8:12:53 | 0:00:07 |
1 | 01.01.2023 | Proc1 | 8:11:05 | 8:29:10 | 0:18:05 | Step4 | 8:13:02 | 8:15:09 | 0:02:07 |
1 | 01.01.2023 | Proc1 | 8:11:05 | 8:29:10 | 0:18:05 | Step1 | 8:15:24 | 8:15:26 | 0:00:02 |
1 | 01.01.2023 | Proc1 | 8:11:05 | 8:29:10 | 0:18:05 | Step3 | 8:15:31 | 8:15:40 | 0:00:09 |
1 | 01.01.2023 | Proc1 | 8:11:05 | 8:29:10 | 0:18:05 | Step3 | 8:15:55 | 8:16:02 | 0:00:07 |
1 | 01.01.2023 | Proc1 | 8:11:05 | 8:29:10 | 0:18:05 | Step5 | 8:16:11 | 8:16:33 | 0:00:22 |
1 | 01.01.2023 | Proc1 | 8:11:05 | 8:29:10 | 0:18:05 | Step6 | 8:16:51 | 8:17:10 | 0:00:19 |
1 | 01.01.2023 | Proc1 | 8:11:05 | 8:29:10 | 0:18:05 | Step7 | 8:17:15 | 8:19:22 | 0:02:07 |
1 | 01.01.2023 | Proc1 | 8:11:05 | 8:29:10 | 0:18:05 | Step8 | 8:19:28 | 8:23:26 | 0:03:58 |
1 | 01.01.2023 | Proc1 | 8:11:05 | 8:29:10 | 0:18:05 | Step3 | 8:23:36 | 8:23:43 | 0:00:07 |
1 | 01.01.2023 | Proc1 | 8:11:05 | 8:29:10 | 0:18:05 | Step9 | 8:23:58 | 8:27:12 | 0:03:14 |
1 | 01.01.2023 | Proc1 | 8:11:05 | 8:29:10 | 0:18:05 | Step10 | 8:27:17 | 8:29:10 | 0:01:53 |
2 | 01.01.2023 | Proc2 | 8:53:34 | 9:08:40 | 0:15:06 | Step2 | 8:53:34 | 8:53:45 | 0:00:11 |
2 | 01.01.2023 | Proc2 | 8:53:34 | 9:08:40 | 0:15:06 | Step1 | 8:54:58 | 8:55:03 | 0:00:05 |
2 | 01.01.2023 | Proc2 | 8:53:34 | 9:08:40 | 0:15:06 | Step3 | 8:55:08 | 8:55:19 | 0:00:11 |
2 | 01.01.2023 | Proc2 | 8:53:34 | 9:08:40 | 0:15:06 | Step11 | 8:55:26 | 8:57:08 | 0:01:42 |
2 | 01.01.2023 | Proc2 | 8:53:34 | 9:08:40 | 0:15:06 | Step12 | 8:57:28 | 9:01:23 | 0:03:55 |
2 | 01.01.2023 | Proc2 | 8:53:34 | 9:08:40 | 0:15:06 | Step13 | 9:01:28 | 9:02:20 | 0:00:52 |
2 | 01.01.2023 | Proc2 | 8:53:34 | 9:08:40 | 0:15:06 | Step14 | 9:02:31 | 9:04:31 | 0:02:00 |
2 | 01.01.2023 | Proc2 | 8:53:34 | 9:08:40 | 0:15:06 | Step15 | 9:04:48 | 9:05:33 | 0:00:45 |
2 | 01.01.2023 | Proc2 | 8:53:34 | 9:08:40 | 0:15:06 | Step16 | 9:05:38 | 9:08:40 | 0:03:02 |
3 | 01.01.2023 | Proc2 | 9:29:23 | 9:49:58 | 0:20:35 | Step2 | 9:29:23 | 9:29:34 | 0:00:11 |
3 | 01.01.2023 | Proc2 | 9:29:23 | 9:49:58 | 0:20:35 | Step1 | 9:30:49 | 9:30:51 | 0:00:02 |
3 | 01.01.2023 | Proc2 | 9:29:23 | 9:49:58 | 0:20:35 | Step3 | 9:30:57 | 9:31:06 | 0:00:09 |
3 | 01.01.2023 | Proc2 | 9:29:23 | 9:49:58 | 0:20:35 | Step11 | 9:31:13 | 9:33:07 | 0:01:54 |
3 | 01.01.2023 | Proc2 | 9:29:23 | 9:49:58 | 0:20:35 | Step12 | 9:33:22 | 9:37:46 | 0:04:24 |
3 | 01.01.2023 | Proc2 | 9:29:23 | 9:49:58 | 0:20:35 | Step17 | 9:37:50 | 9:38:01 | 0:00:11 |
3 | 01.01.2023 | Proc2 | 9:29:23 | 9:49:58 | 0:20:35 | Step13 | 9:38:07 | 9:39:08 | 0:01:01 |
3 | 01.01.2023 | Proc2 | 9:29:23 | 9:49:58 | 0:20:35 | Step14 | 9:39:13 | 9:41:59 | 0:02:46 |
3 | 01.01.2023 | Proc2 | 9:29:23 | 9:49:58 | 0:20:35 | Step15 | 9:42:15 | 9:43:07 | 0:00:52 |
3 | 01.01.2023 | Proc2 | 9:29:23 | 9:49:58 | 0:20:35 | Step16 | 9:43:12 | 9:46:20 | 0:03:08 |
3 | 01.01.2023 | Proc2 | 9:29:23 | 9:49:58 | 0:20:35 | Step18 | 9:46:25 | 9:49:58 | 0:03:33 |
Thanks!
I think I've messed up with sample data, so here is a link to an excel file
User | Count |
---|---|
117 | |
73 | |
58 | |
49 | |
48 |
User | Count |
---|---|
171 | |
122 | |
60 | |
59 | |
56 |