205 service requests
Site: CHDQ

About this visual

Each circle represents a possible state of the service request.

The size represents the percentage of time spent by all service requests in this state. (Larger circles indicate more time.)

The colour represents the time spent by any service requests, on average in this state. (Red circles indicate a higher average processing time.)

The arcs on top represent forward flows, from left to right. Their size and colour again represent the total and average time spent in that transition.

The arcs below represent reverse flows, from right to left. Their size and colour are similarly constructed.

6.6% Cancelled 7.7% Closed 14.2% Completed 0.0% Draft 27.0% In Progress 0.0% Pending 21.6% Planning 0.0% Rejected 1.8% Submitted 21.0% Waiting Approval

Cause of delay This visual uses TopCause: a Gramener algorithm

Group Count Days spent

* Empty cell implies no impact

Summary of the causes

There are no significant causes of delay that we can infer for this segment from the data.

Service requests status Showing 100 out of 659

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
REQ000000626797 10-06-14 8:35 Draft Submitted 408
REQ000000626797 10-06-14 8:42 Submitted Waiting Approval 4
REQ000000626797 10-06-14 8:42 Planning In Progress 405
REQ000000626797 10-06-14 8:48 In Progress Completed 10883880
REQ000000626797 14-10-14 8:06 Completed Closed 1347170
REQ000000691709 20-10-14 5:54 Submitted Waiting Approval 20
REQ000000691709 20-10-14 5:55 Waiting Approval Cancelled 16
REQ000000723343 27-10-14 6:54 Draft Cancelled 14
REQ000000723424 27-10-14 6:59 Draft Cancelled 349108
REQ000000786668 11-07-14 15:18 Draft Cancelled 17
REQ000000786816 11-07-14 15:19 Draft Cancelled 58
REQ000000791706 12-02-14 14:13 Cancelled Draft 20806402
REQ000000878005 27-11-14 7:46 Submitted Waiting Approval 8
REQ000000878005 27-11-14 7:46 Waiting Approval Rejected 19583
REQ000000924579 12-08-14 8:06 Submitted Waiting Approval 25
REQ000000924579 12-08-14 8:07 Waiting Approval Cancelled 18
REQ000000941243 12-10-14 15:20 Submitted Waiting Approval 19
REQ000000941243 12-10-14 15:20 Waiting Approval Planning 5531096
REQ000000941243 15-12-14 15:45 Planning In Progress 63048
REQ000000946827 12-11-14 13:36 Submitted Waiting Approval 17
REQ000000946827 12-11-14 13:36 Waiting Approval Planning 2605220
REQ000000946827 12-12-14 17:16 Planning In Progress 1454
REQ000000947090 12-11-14 14:51 Submitted Waiting Approval 16
REQ000000947090 12-11-14 14:51 Waiting Approval Planning 1250
REQ000000947090 12-11-14 15:12 Planning In Progress 2873
REQ000000947195 12-11-14 15:29 Submitted Waiting Approval 15
REQ000000947195 12-11-14 15:30 Waiting Approval Planning 3829
REQ000000947195 12-11-14 16:33 Planning In Progress 2579146
REQ000000947311 12-11-14 14:20 Submitted Waiting Approval 20
REQ000000947311 12-11-14 14:20 Waiting Approval Planning 1371
REQ000000947311 12-11-14 14:43 Planning In Progress 2582537
REQ000000948331 12-11-14 17:11 Submitted Waiting Approval 26
REQ000000948331 12-11-14 17:12 Waiting Approval Planning 5952324
REQ000000948331 20-01-15 14:37 Planning Cancelled 21758
REQ000000948479 12-11-14 18:55 Submitted Waiting Approval 6
REQ000000948479 12-11-14 18:55 Waiting Approval Planning 2990009
REQ000000948479 17-12-14 9:28 Planning Cancelled 2978303
REQ000000948694 12-11-14 19:01 Submitted Waiting Approval 9
REQ000000948694 12-11-14 19:01 Waiting Approval Planning 2989626
REQ000000948694 17-12-14 9:28 Planning Cancelled 2978283
REQ000000948700 12-11-14 19:06 Submitted Waiting Approval 10
REQ000000948700 12-11-14 19:06 Waiting Approval Planning 2989333
REQ000000948700 17-12-14 9:28 Planning Cancelled 2978329
REQ000000948901 12-11-14 18:47 Submitted Waiting Approval 6
REQ000000948901 12-11-14 18:47 Waiting Approval Planning 2990463
REQ000000948901 17-12-14 9:28 Planning Cancelled 2978356
REQ000000948931 12-11-14 19:45 Submitted Waiting Approval 7
REQ000000948931 12-11-14 19:45 Waiting Approval Rejected 2932081
REQ000000953056 12-12-14 14:29 Submitted Waiting Approval 12
REQ000000953056 12-12-14 14:29 Waiting Approval Planning 5643
REQ000000953056 12-12-14 16:03 Planning In Progress 323838
REQ000000953375 12-12-14 14:53 Submitted Waiting Approval 16
REQ000000953375 12-12-14 14:54 Waiting Approval Planning 6870
REQ000000953375 12-12-14 16:48 Planning In Progress 331620
REQ000000953770 12-12-14 16:20 Submitted Waiting Approval 11
REQ000000953770 12-12-14 16:20 Waiting Approval Planning 1716
REQ000000953770 12-12-14 16:48 Planning In Progress 333358
REQ000000953873 12-12-14 17:20 Submitted Waiting Approval 12
REQ000000953873 12-12-14 17:20 Waiting Approval Planning 851
REQ000000953873 12-12-14 17:34 Planning In Progress 336162
REQ000000954054 12-12-14 16:35 Submitted Waiting Approval 9
REQ000000954054 12-12-14 16:35 Waiting Approval Planning 787
REQ000000954054 12-12-14 16:48 Planning In Progress 336239
REQ000000954551 12-12-14 20:06 Submitted Waiting Approval 6
REQ000000954551 12-12-14 20:06 Waiting Approval Planning 388023
REQ000000954551 17-12-14 7:53 Planning Cancelled 2983970
REQ000000954709 12-12-14 19:50 Submitted Waiting Approval 9
REQ000000960888 15-12-14 14:09 Submitted Waiting Approval 12
REQ000000960888 15-12-14 14:10 Waiting Approval Planning 88427
REQ000000960888 16-12-14 14:43 Planning In Progress 19705539
REQ000000961359 15-12-14 15:10 Submitted Waiting Approval 13
REQ000000961359 15-12-14 15:10 Waiting Approval Planning 3674
REQ000000961359 15-12-14 16:11 Planning In Progress 68974
REQ000000961715 15-12-14 15:16 Submitted Waiting Approval 14
REQ000000961715 15-12-14 15:17 Waiting Approval Planning 16043
REQ000000961715 15-12-14 19:44 Planning In Progress 133913
REQ000000961737 15-12-14 15:33 Submitted Waiting Approval 10
REQ000000961737 15-12-14 15:33 Waiting Approval Planning 15023
REQ000000961737 15-12-14 19:44 Planning In Progress 134938
REQ000000962006 15-12-14 15:56 Submitted Waiting Approval 9
REQ000000962006 15-12-14 15:56 Waiting Approval Planning 196844
REQ000000962006 17-12-14 22:37 Planning In Progress 35069
REQ000000967141 16-12-14 13:15 Submitted Waiting Approval 3
REQ000000967141 16-12-14 13:15 Waiting Approval Planning 9728
REQ000000967141 16-12-14 15:57 Planning In Progress 58052
REQ000000967146 16-12-14 13:19 Submitted Waiting Approval 2
REQ000000967146 16-12-14 13:19 Waiting Approval Planning 9447
REQ000000967146 16-12-14 15:57 Planning In Progress 58425
REQ000000967789 16-12-14 15:59 Submitted Waiting Approval 4
REQ000000967789 16-12-14 15:59 Waiting Approval Planning 62946
REQ000000967789 17-12-14 9:28 Planning In Progress 22288
REQ000000968100 16-12-14 16:08 Submitted Waiting Approval 7
REQ000000968100 16-12-14 16:08 Waiting Approval Planning 62410
REQ000000968100 17-12-14 9:29 Planning In Progress 20702
REQ000000968296 16-12-14 16:03 Submitted Waiting Approval 5
REQ000000968296 16-12-14 16:03 Waiting Approval Planning 62749
REQ000000968296 17-12-14 9:28 Planning In Progress 21889
REQ000000968506 16-12-14 16:05 Submitted Waiting Approval 5
REQ000000968506 16-12-14 16:05 Waiting Approval Planning 62587
REQ000000968506 17-12-14 9:29 Planning In Progress 21447

Process Workflow Optimization

This page shows all required calculations for the workflow POC.

Computations

  1. De-duplicate data by primary keys Service Request ID, SR Audit Create Datetime, and SR Audit Status.
  2. Sort by Service Request ID, and within that, by SR Audit Create Datetime.
  3. Add a Next status column that has the next row's SR Audit Status within a given Service Request ID. (The last row in each Service Request ID will have a NaN Next status.)
  4. Calculate the Time spent as the next row's SR Audit Create Datetime minus the current row's SR Audit Create Datetime. For the last row, this value will be NaN.

Basic statistics

Time spent in each status, on average

count count_transitioned mean_days total_days
Cancelled 5 5 212.2 1,061.2
Closed 12 12 102.8 1,233.1
Completed 20 20 113.6 2,272.5
Draft 16 16 0.4 6.1
In Progress 37 37 116.9 4,324.5
Pending 1 1 0.0 0.0
Planning 171 171 20.3 3,466.7
Rejected 9 9 0.1 0.9
Submitted 204 204 1.4 289.2
Waiting Approval 184 184 18.3 3,365.6

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Cancelled Draft 1 240.8 240.8
Submitted 4 205.1 820.4
Closed Completed 8 149.4 1,195.0
In Progress 4 9.5 38.1
Completed Closed 5 15.3 76.7
Planning 5 33.5 167.4
Submitted 10 202.8 2,028.4
Draft Cancelled 4 1.0 4.0
Submitted 10 0.2 2.0
Waiting Approval 2 0.0 0.0
In Progress Cancelled 6 74.9 449.4
Closed 4 6.4 25.6
Completed 14 99.7 1,395.1
Pending 1 0.0 0.0
Planning 1 255.7 255.7
Submitted 11 199.9 2,198.7
Pending In Progress 1 0.0 0.0
Planning Cancelled 12 20.9 250.8
Closed 4 18.7 74.7
Completed 1 35.2 35.2
In Progress 152 18.4 2,789.5
Pending 1 0.2 0.2
Submitted 1 316.3 316.3
Rejected Draft 9 0.1 0.9
Submitted Planning 1 2.0 2.0
Rejected 1 0.0 0.0
Submitted 1 287.2 287.2
Waiting Approval 201 0.0 0.0
Waiting Approval Cancelled 10 22.7 226.8
Completed 4 51.8 207.0
In Progress 1 22.1 22.1
Planning 157 17.7 2,776.1
Rejected 12 11.1 133.6