80 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.2% Cancelled 0.2% Closed 12.2% Completed 0.0% Draft 16.8% In Progress 0.0% Pending 36.1% Planning 0.0% Rejected 0.0% Submitted 27.5% 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 254

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
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
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
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
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
REQ000000773865 11-05-14 14:30 Submitted Waiting Approval 34
REQ000000773865 11-05-14 14:31 Waiting Approval Cancelled 6165
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
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
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
REQ000000973466 17-12-14 13:40 Submitted Waiting Approval 3
REQ000000973466 17-12-14 13:40 Waiting Approval Planning 1104719
REQ000000973466 30-12-14 8:32 Planning In Progress 10541584
REQ000000982465 01-07-15 16:07 Planning Pending 2635475
REQ000000982465 19-12-14 7:56 Submitted Waiting Approval 6
REQ000000982465 19-12-14 7:57 Waiting Approval In Progress 3308074
REQ000000982465 26-01-15 14:51 In Progress Planning 13482975
REQ000000982469 01-02-15 15:31 Planning In Progress 15621592
REQ000000982469 19-12-14 8:01 Submitted Waiting Approval 3
REQ000000982469 19-12-14 8:01 Waiting Approval Planning 3828591
REQ000000992058 01-06-15 14:05 Planning In Progress 8704
REQ000000992058 22-12-14 18:04 Submitted Waiting Approval 4
REQ000000992058 22-12-14 18:04 Waiting Approval Rejected 73250
REQ000000992058 23-12-14 14:25 Rejected Draft 431
REQ000000992058 23-12-14 14:32 Draft Submitted 80
REQ000000992058 23-12-14 14:34 Waiting Approval Rejected 336
REQ000000992058 23-12-14 14:39 Rejected Draft 42
REQ000000992058 23-12-14 14:40 Draft Submitted 74
REQ000000992058 23-12-14 14:41 Submitted Waiting Approval 1
REQ000000992058 23-12-14 14:41 Waiting Approval Planning 13821820
REQ000000996405 01-02-15 15:31 Planning In Progress 26148856
REQ000000996405 23-12-14 16:04 Submitted Waiting Approval 4
REQ000000996405 23-12-14 16:04 Waiting Approval Planning 3453994
REQ000001005542 29-12-14 21:11 Draft Cancelled 133
REQ000001016148 01-05-15 9:29 Submitted Waiting Approval 7
REQ000001016148 01-05-15 9:29 Waiting Approval Planning 2699618
REQ000001016148 01-06-15 15:23 Planning In Progress 2596664
REQ000001016152 01-05-15 9:38 Submitted Waiting Approval 12
REQ000001016152 01-05-15 9:38 Waiting Approval Completed 163989
REQ000001016152 01-06-15 15:23 Planning In Progress 2597005
REQ000001016152 03-05-15 7:11 Completed Planning 2535090
REQ000001025292 01-06-15 15:54 Submitted Waiting Approval 8
REQ000001025292 19-01-15 14:07 Planning Cancelled 962470
REQ000001025292 30-01-15 17:28 Cancelled Submitted 10535155
REQ000001025902 01-06-15 16:09 Submitted Waiting Approval 4
REQ000001025902 19-01-15 14:07 Planning Cancelled 962506
REQ000001025902 30-01-15 17:28 Cancelled Submitted 10536018
REQ000001031739 01-07-15 14:35 Submitted Waiting Approval 5
REQ000001031739 01-07-15 14:36 Waiting Approval Planning 6932
REQ000001031739 01-07-15 16:31 Planning In Progress 2651954
REQ000001032083 01-07-15 15:29 Submitted Waiting Approval 5
REQ000001032083 01-07-15 15:29 Waiting Approval Planning 2657840
REQ000001032083 01-08-15 9:46 Planning In Progress 1426
REQ000001035294 01-08-15 8:12 Submitted Waiting Approval 6
REQ000001035294 20-01-15 17:37 Planning In Progress 580527
REQ000001035294 27-01-15 10:52 In Progress Submitted 16060808
REQ000001035820 01-08-15 8:14 Submitted Waiting Approval 4
REQ000001035820 20-01-15 17:37 Planning In Progress 580700
REQ000001035820 27-01-15 10:55 In Progress Submitted 16060765
REQ000001056784 13-01-15 7:33 Submitted Waiting Approval 3
REQ000001056784 13-01-15 7:33 Waiting Approval Planning 103291

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 98.2 490.8
Closed 1 1 11.6 11.6
Completed 8 8 103.2 825.2
Draft 7 7 0.0 0.0
In Progress 20 20 57.0 1,140.4
Pending 1 1 0.2 0.2
Planning 57 57 42.9 2,444.3
Rejected 4 4 0.0 0.0
Submitted 79 79 0.0 0.0
Waiting Approval 72 72 25.9 1,862.5

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Cancelled Draft 2 112.3 224.7
Submitted 3 88.7 266.1
Closed Completed 1 11.6 11.6
Completed Closed 3 75.1 225.2
Planning 2 62.2 124.4
Submitted 3 158.6 475.7
Draft Cancelled 3 0.0 0.0
Submitted 4 0.0 0.0
In Progress Cancelled 2 19.6 39.3
Closed 3 61.6 184.7
Completed 8 7.4 59.0
Planning 1 156.1 156.1
Submitted 6 116.9 701.3
Pending In Progress 1 0.2 0.2
Planning Cancelled 4 39.6 158.5
In Progress 51 38.6 1,969.2
Pending 2 158.3 316.5
Rejected Draft 4 0.0 0.0
Submitted Waiting Approval 79 0.0 0.0
Waiting Approval Cancelled 10 11.2 111.5
Completed 2 16.5 32.9
In Progress 1 38.3 38.3
Planning 53 31.6 1,675.8
Rejected 6 0.6 3.9