39 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.

11.7% Closed 39.6% Completed 0.0% Draft 30.7% In Progress 8.0% Planning 0.0% Rejected 0.0% Submitted 10.1% 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 186

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
REQ000000614302 10-01-14 19:12 Submitted Waiting Approval 13
REQ000000614302 10-01-14 19:12 Waiting Approval Planning 2673372
REQ000000614302 10-02-14 17:48 Planning Completed 5269569
REQ000000614302 10-08-14 18:50 In Progress Closed 11400260
REQ000000614302 12-04-14 17:34 Completed In Progress 10372541
REQ000000646355 10-09-14 10:02 Planning In Progress 16720
REQ000000646355 10-09-14 14:40 In Progress Closed 8476865
REQ000000646355 10-09-14 9:37 Submitted Waiting Approval 9
REQ000000646355 10-09-14 9:37 Waiting Approval Planning 1466
REQ000000646355 12-02-14 10:03 Completed Submitted 18142446
REQ000000646712 10-09-14 12:26 Planning In Progress 2441
REQ000000646712 10-09-14 13:07 In Progress Closed 8482466
REQ000000646712 10-09-14 9:52 Submitted Waiting Approval 11
REQ000000646712 10-09-14 9:52 Waiting Approval Planning 9262
REQ000000646712 12-02-14 10:03 Completed Submitted 18143303
REQ000000675101 12-02-14 10:08 Completed Submitted 21181176
REQ000000675101 15-10-14 13:48 Submitted Waiting Approval 14
REQ000000675101 15-10-14 13:48 Waiting Approval Planning 63025
REQ000000675101 16-10-14 7:18 Planning In Progress 6066
REQ000000675101 16-10-14 9:00 In Progress Closed 5386913
REQ000000675142 12-02-14 10:08 Completed Submitted 21182234
REQ000000675142 15-10-14 14:05 Submitted Waiting Approval 16
REQ000000675142 15-10-14 14:05 Waiting Approval Planning 62781
REQ000000675142 16-10-14 7:31 Planning In Progress 6606
REQ000000675142 16-10-14 9:22 In Progress Closed 5385598
REQ000000675254 12-02-14 10:07 Completed Submitted 21182871
REQ000000675254 15-10-14 14:15 Submitted Waiting Approval 18
REQ000000675254 15-10-14 14:15 Waiting Approval Planning 61232
REQ000000675254 16-10-14 7:16 Planning In Progress 8170
REQ000000675254 16-10-14 9:32 In Progress Closed 5384976
REQ000000675324 12-02-14 10:35 Completed Submitted 21181571
REQ000000675324 15-10-14 14:21 Submitted Waiting Approval 15
REQ000000675324 15-10-14 14:21 Waiting Approval Planning 61061
REQ000000675324 16-10-14 7:19 Planning In Progress 3655
REQ000000675324 16-10-14 8:20 In Progress Closed 5389315
REQ000000679515 12-04-14 8:26 Completed Submitted 16160203
REQ000000679515 16-10-14 9:22 Submitted Waiting Approval 13
REQ000000679515 16-10-14 9:23 Waiting Approval Planning 1284
REQ000000679515 16-10-14 9:44 Planning In Progress 340504
REQ000000679515 20-10-14 8:19 In Progress Closed 5217063
REQ000000680751 11-03-14 23:11 In Progress Completed 35988
REQ000000680751 11-03-14 8:44 Planning In Progress 51976
REQ000000680751 12-03-14 9:10 Completed Submitted 18849001
REQ000000680751 16-10-14 13:00 Submitted Waiting Approval 11
REQ000000680751 16-10-14 13:01 Waiting Approval Closed 5459139
REQ000000680925 16-10-14 13:14 Submitted Waiting Approval 11
REQ000000680925 16-10-14 13:14 Waiting Approval Planning 7398
REQ000000680925 16-10-14 15:17 Planning Cancelled 3092703
REQ000000681285 12-02-14 10:09 Completed Submitted 21268605
REQ000000681285 16-10-14 14:06 Submitted Waiting Approval 13
REQ000000681285 16-10-14 14:06 Waiting Approval Planning 4280
REQ000000681285 16-10-14 15:17 Planning In Progress 85366
REQ000000681285 17-10-14 15:00 In Progress Closed 5278884
REQ000000681337 12-02-14 10:33 Completed Submitted 21267552
REQ000000681337 16-10-14 14:12 Submitted Waiting Approval 11
REQ000000681337 16-10-14 14:12 Waiting Approval Planning 56166
REQ000000681337 17-10-14 5:48 Planning In Progress 281941
REQ000000681337 20-10-14 12:07 In Progress Closed 5030064
REQ000000681424 11-03-14 8:44 Planning Completed 87896
REQ000000681424 11-04-14 15:34 In Progress Submitted 16239270
REQ000000681424 12-03-14 9:09 Completed In Progress 2615092
REQ000000681424 16-10-14 14:29 Submitted Waiting Approval 15
REQ000000681424 16-10-14 14:29 Waiting Approval Closed 5453830
REQ000000681656 12-03-14 8:36 Completed Submitted 18857004
REQ000000681656 16-10-14 14:39 Submitted Waiting Approval 12
REQ000000681656 16-10-14 14:40 Waiting Approval Planning 3853
REQ000000681656 16-10-14 15:44 Planning In Progress 333468
REQ000000681656 20-10-14 12:22 In Progress Closed 5115875
REQ000000702114 12-02-14 10:16 Completed Submitted 21697973
REQ000000702114 21-10-14 13:28 Submitted Waiting Approval 11
REQ000000702114 21-10-14 13:29 Waiting Approval Planning 70374
REQ000000702114 22-10-14 9:02 Planning In Progress 1503
REQ000000702114 22-10-14 9:27 In Progress Closed 4866890
REQ000000702256 21-10-14 14:02 Submitted Waiting Approval 17
REQ000000702256 21-10-14 14:02 Waiting Approval Planning 159598
REQ000000702256 23-10-14 10:22 Planning In Progress 20991
REQ000000808123 11-12-14 18:17 Submitted Waiting Approval 13
REQ000000808123 11-12-14 18:17 Waiting Approval Closed 3579053
REQ000000808123 13-11-14 15:38 Rejected Draft 166
REQ000000808123 13-11-14 15:40 Draft Submitted 149
REQ000000808123 13-11-14 15:43 Submitted Waiting Approval 1
REQ000000808123 13-11-14 15:43 Waiting Approval Planning 534847
REQ000000808123 19-11-14 20:17 Planning In Progress 76540
REQ000000808123 20-11-14 17:33 In Progress Submitted 1817065
REQ000000808123 22-01-15 4:28 Closed Completed 11270531
REQ000000808341 11-12-14 18:26 Submitted Waiting Approval 8
REQ000000808341 11-12-14 18:26 Waiting Approval Closed 3578515
REQ000000808341 13-11-14 15:39 Rejected Draft 94
REQ000000808341 13-11-14 15:40 Draft Submitted 478
REQ000000808341 13-11-14 15:48 Submitted Waiting Approval 1
REQ000000808341 13-11-14 15:48 Waiting Approval Planning 534552
REQ000000808341 19-11-14 20:17 Planning In Progress 159659
REQ000000808341 21-11-14 16:38 In Progress Submitted 1734479
REQ000000808341 22-01-15 4:28 Closed Completed 11270730
REQ000000864679 12-03-14 12:12 Completed Submitted 22277800
REQ000000864679 25-11-14 14:37 Planning In Progress 71480
REQ000000864679 25-11-14 8:29 Submitted Waiting Approval 13
REQ000000864679 25-11-14 8:29 Waiting Approval Planning 22112
REQ000000864679 26-11-14 10:29 In Progress Closed 1925816
REQ000000866036 12-03-14 10:49 Completed Submitted 22291163

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
Closed 8 8 130.5 1,043.7
Completed 17 17 208.3 3,540.5
Draft 5 5 0.0 0.0
In Progress 25 25 109.7 2,741.8
Planning 39 39 18.3 715.5
Rejected 5 5 0.0 0.1
Submitted 43 43 0.0 0.0
Waiting Approval 44 44 20.4 899.3

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Closed Completed 8 130.5 1,043.7
Completed In Progress 2 75.2 150.3
Submitted 15 226.0 3,390.2
Draft Submitted 5 0.0 0.0
In Progress Closed 19 110.4 2,098.2
Completed 2 76.7 153.4
Submitted 4 122.5 490.2
Planning Cancelled 1 35.8 35.8
Completed 2 31.0 62.0
In Progress 35 12.0 418.9
Submitted 1 198.8 198.8
Rejected Draft 5 0.0 0.1
Submitted Waiting Approval 43 0.0 0.0
Waiting Approval Closed 6 48.3 290.0
In Progress 1 49.3 49.3
Planning 34 16.5 559.9
Rejected 3 0.0 0.1