491 service requests

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.

7.7% Cancelled 2.4% Closed 12.0% Completed 0.0% Draft 23.8% In Progress 0.9% Pending 29.7% Planning 0.5% Rejected 0.8% Submitted 22.2% Waiting Approval

Cause of delay This visual uses Group-Means: 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 1,563

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
REQ000000648083 11-04-14 15:22 Cancelled Draft 13129181
REQ000000650014 10-09-14 21:01 Submitted Waiting Approval 14
REQ000000650014 10-09-14 21:01 Waiting Approval Cancelled 2560942
REQ000000661353 12-03-14 9:27 Completed Submitted 18590588
REQ000000661353 13-10-14 13:30 Submitted Waiting Approval 13
REQ000000661353 13-10-14 13:30 Waiting Approval Planning 268124
REQ000000661353 16-10-14 15:59 Planning In Progress 9151
REQ000000661353 16-10-14 18:31 In Progress Closed 5439293
REQ000000676533 15-10-14 18:11 Submitted Waiting Approval 10
REQ000000676533 15-10-14 18:12 Waiting Approval Rejected 1
REQ000000682174 16-10-14 16:52 Submitted Waiting Approval 10
REQ000000682174 16-10-14 16:52 Waiting Approval Planning 320927
REQ000000682174 20-10-14 10:01 Planning In Progress 18830
REQ000000682508 16-10-14 16:59 Submitted Waiting Approval 10
REQ000000682508 16-10-14 16:59 Waiting Approval Cancelled 418341
REQ000000687351 17-10-14 15:34 Draft Cancelled 246442
REQ000000688552 17-10-14 22:32 Submitted Waiting Approval 16
REQ000000688552 17-10-14 22:32 Waiting Approval Cancelled 19
REQ000000688554 17-10-14 22:37 Submitted Waiting Approval 21
REQ000000688554 17-10-14 22:37 Waiting Approval Cancelled 155
REQ000000691709 20-10-14 5:54 Submitted Waiting Approval 20
REQ000000691709 20-10-14 5:55 Waiting Approval Cancelled 16
REQ000000701878 12-03-14 10:32 Completed Submitted 19277314
REQ000000701878 21-10-14 13:20 Submitted Waiting Approval 9
REQ000000701878 21-10-14 13:20 Waiting Approval Planning 69468
REQ000000701878 22-10-14 8:38 Planning In Progress 108093
REQ000000701878 23-10-14 14:40 In Progress Closed 4848380
REQ000000709083 11-06-14 9:54 In Progress Submitted 11513596
REQ000000709083 22-10-14 16:08 Submitted Waiting Approval 10
REQ000000709083 22-10-14 16:08 Waiting Approval Planning 603991
REQ000000713788 23-10-14 14:20 Submitted Waiting Approval 16
REQ000000713788 23-10-14 14:20 Waiting Approval Cancelled 389
REQ000000714210 23-10-14 14:26 Submitted Waiting Approval 27
REQ000000714210 23-10-14 14:26 Waiting Approval Cancelled 700844
REQ000000714222 23-10-14 14:31 Submitted Waiting Approval 24
REQ000000714222 23-10-14 14:32 Waiting Approval Cancelled 700570
REQ000000719081 12-08-14 20:02 Cancelled Draft 6284030
REQ000000719320 24-10-14 13:49 Draft Cancelled 20
REQ000000723343 27-10-14 6:54 Draft Cancelled 14
REQ000000723424 27-10-14 6:59 Draft Cancelled 349108
REQ000000773865 11-05-14 14:30 Submitted Waiting Approval 34
REQ000000773865 11-05-14 14:31 Waiting Approval Cancelled 6165
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
REQ000000836073 19-11-14 3:38 Submitted Waiting Approval 13
REQ000000836073 19-11-14 3:38 Waiting Approval Rejected 20874
REQ000000836226 19-11-14 3:45 Submitted Waiting Approval 9
REQ000000836226 19-11-14 3:45 Waiting Approval Rejected 20461
REQ000000848721 02-02-15 16:25 Completed Closed 1324175
REQ000000848721 20-11-14 20:32 Planning Pending 68400
REQ000000848721 21-11-14 15:32 Pending Completed 6310368
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
REQ000000932195 12-09-14 10:40 Submitted Waiting Approval 25
REQ000000932195 12-09-14 10:40 Waiting Approval Planning 8218188
REQ000000932195 16-12-14 13:30 Planning In Progress 93853
REQ000000933181 12-09-14 13:09 Submitted Waiting Approval 11
REQ000000933181 12-09-14 13:10 Waiting Approval Planning 13498
REQ000000933181 12-09-14 16:55 Planning In Progress 2556806
REQ000000933181 12-10-14 7:08 In Progress Closed 8803214
REQ000000933181 22-01-15 4:28 Closed Completed 11273185
REQ000000934004 12-09-14 13:48 Submitted Waiting Approval 12
REQ000000934004 12-09-14 13:48 Waiting Approval Planning 16975
REQ000000934004 12-09-14 18:31 Planning In Progress 2571009
REQ000000938498 12-10-14 9:36 Submitted Waiting Approval 25
REQ000000938498 12-10-14 9:36 Waiting Approval Planning 5502806
REQ000000938498 15-12-14 10:33 In Progress Completed 98459
REQ000000938498 15-12-14 2:10 Planning In Progress 30187
REQ000000938498 16-12-14 13:54 Completed Closed 1342978
REQ000000939092 12-10-14 11:04 Submitted Waiting Approval 12
REQ000000939092 12-10-14 11:04 Waiting Approval Planning 15300
REQ000000939092 12-10-14 15:19 Planning In Progress 1386
REQ000000939668 12-10-14 12:37 Submitted Waiting Approval 22
REQ000000939668 12-10-14 12:38 Waiting Approval Planning 5304468
REQ000000939668 12-12-14 22:06 Planning In Progress 213743
REQ000000939668 15-12-14 9:28 In Progress Closed 5672837
REQ000000939668 19-02-15 1:15 Closed Completed 1002669
REQ000000941240 12-10-14 15:09 Submitted Waiting Approval 15
REQ000000941240 12-10-14 15:09 Waiting Approval Planning 6200400
REQ000000941240 23-12-14 9:29 Planning In Progress 13847263
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
REQ000000941516 12-10-14 15:12 Submitted Waiting Approval 18
REQ000000941516 12-10-14 15:12 Waiting Approval Planning 6200211
REQ000000941516 23-12-14 9:29 Planning In Progress 13847383
REQ000000941802 12-10-14 16:52 Submitted Waiting Approval 26
REQ000000941802 12-10-14 16:52 Waiting Approval Planning 2255
REQ000000941802 12-10-14 17:30 Planning In Progress 19
REQ000000941802 12-10-14 17:30 In Progress Cancelled 1647
REQ000000946827 12-11-14 13:36 Submitted Waiting Approval 17
REQ000000946827 12-11-14 13:36 Waiting Approval Planning 2605220

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 18 18 167.1 3,007.4
Closed 15 15 62.5 937.3
Completed 46 46 102.4 4,708.9
Draft 36 36 0.3 9.1
In Progress 100 100 93.4 9,340.8
Pending 12 12 29.6 354.8
Planning 386 386 30.2 11,676.1
Rejected 24 24 8.5 204.7
Submitted 493 493 0.6 311.2
Waiting Approval 433 433 20.1 8,709.5

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Cancelled Draft 3 155.2 465.5
Pending 1 0.0 0.0
Planning 1 182.0 182.0
Submitted 13 181.5 2,359.9
Closed Completed 9 95.7 861.7
In Progress 4 9.5 38.1
Planning 2 18.8 37.5
Completed Closed 18 28.7 517.2
Planning 10 52.8 527.8
Submitted 18 203.5 3,663.9
Draft Cancelled 9 0.8 6.9
Submitted 21 0.1 2.2
Waiting Approval 6 0.0 0.0
In Progress Cancelled 11 33.7 371.2
Closed 7 48.3 338.4
Completed 41 38.6 1,583.7
In Progress 1 24.1 24.1
Pending 2 30.6 61.3
Planning 4 122.0 488.0
Submitted 34 190.4 6,474.1
Pending Cancelled 1 153.3 153.3
Completed 3 46.4 139.1
In Progress 8 7.8 62.4
Planning Cancelled 21 22.9 481.2
Closed 4 18.7 74.7
Completed 2 35.2 70.4
Draft 1 25.6 25.6
In Progress 343 29.4 10,095.3
Pending 14 43.8 612.5
Submitted 1 316.3 316.3
Rejected Draft 22 0.2 4.4
Submitted 1 200.4 200.4
Waiting Approval 1 0.0 0.0
Submitted Completed 1 19.0 19.0
In Progress 1 5.0 5.0
Planning 3 0.0 0.1
Rejected 2 0.0 0.0
Submitted 1 287.2 287.2
Waiting Approval 485 0.0 0.0
Waiting Approval Cancelled 31 20.0 620.2
Completed 7 21.5 150.6
Draft 1 68.0 68.0
In Progress 5 22.6 113.1
Planning 353 20.9 7,388.7
Rejected 36 10.2 369.0