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

1.9% Cancelled 2.7% Closed 14.4% Completed 0.2% Draft 38.2% In Progress 1.9% Pending 22.1% Planning 0.0% Rejected 0.1% Submitted 18.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 1,688

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
REQ000000609793 10-01-14 7:02 Submitted Waiting Approval 16
REQ000000609793 10-01-14 7:02 Waiting Approval Completed 2862945
REQ000000609793 12-02-14 10:18 Completed Planning 21174035
REQ000000609793 15-10-14 11:58 Planning In Progress 1415
REQ000000609793 15-10-14 12:22 In Progress Closed 5461173
REQ000000609958 10-01-14 7:04 Submitted Waiting Approval 19
REQ000000609958 10-01-14 7:05 Waiting Approval Planning 3216
REQ000000609958 10-01-14 7:58 Planning In Progress 2130
REQ000000609958 10-01-14 8:34 In Progress Completed 2855126
REQ000000609958 12-02-14 9:39 Completed Closed 26638933
REQ000000610897 10-01-14 11:18 Planning In Progress 4041
REQ000000610897 10-01-14 12:25 In Progress Completed 2841606
REQ000000610897 10-01-14 9:30 Submitted Waiting Approval 12
REQ000000610897 10-01-14 9:30 Waiting Approval Planning 6466
REQ000000610897 12-02-14 9:45 Completed Closed 26638582
REQ000000612117 10-01-14 12:20 Submitted Waiting Approval 11
REQ000000612117 10-01-14 12:20 Waiting Approval Planning 5139386
REQ000000612117 10-03-14 23:57 Planning In Progress 19577427
REQ000000613161 10-01-14 14:51 Submitted Waiting Approval 11
REQ000000613161 10-01-14 14:51 Waiting Approval Planning 23949139
REQ000000613161 14-10-14 19:23 Planning In Progress 60262
REQ000000613161 15-10-14 12:08 In Progress Closed 8526047
REQ000000613161 22-01-15 4:28 Closed Completed 11270138
REQ000000617052 10-02-14 11:50 Submitted Waiting Approval 9
REQ000000617052 10-02-14 11:50 Waiting Approval Planning 20885223
REQ000000617052 10-10-14 5:17 Planning In Progress 1148598
REQ000000617398 10-02-14 13:44 Submitted Waiting Approval 11
REQ000000617398 10-02-14 13:44 Waiting Approval Planning 6032
REQ000000617398 10-02-14 15:25 Planning In Progress 2413006
REQ000000617406 10-02-14 13:23 Submitted Waiting Approval 10
REQ000000617406 10-02-14 13:23 Waiting Approval Planning 7268
REQ000000617406 10-02-14 15:24 Planning In Progress 2414704
REQ000000617920 10-02-14 13:50 Submitted Waiting Approval 10
REQ000000617920 10-02-14 13:51 Waiting Approval Planning 2570
REQ000000617920 10-02-14 14:33 Planning In Progress 2418086
REQ000000617920 10-03-14 14:15 In Progress Completed 24535772
REQ000000617920 19-12-14 13:44 Completed Closed 8862129
REQ000000625439 03-02-15 5:03 Closed Completed 869458
REQ000000625439 10-06-14 6:14 Submitted Waiting Approval 20
REQ000000625439 10-06-14 6:14 Waiting Approval Planning 5312908
REQ000000625439 10-08-14 18:03 Planning Pending 14196
REQ000000625439 10-08-14 21:59 Pending In Progress 5237105
REQ000000625439 10-10-14 12:44 In Progress Closed 9994704
REQ000000625469 10-06-14 6:31 Submitted Waiting Approval 8
REQ000000625469 10-06-14 6:31 Waiting Approval Planning 6045
REQ000000625469 10-06-14 8:12 Planning Pending 10825247
REQ000000625469 13-10-14 15:13 Pending In Progress 937583
REQ000000625480 10-06-14 6:40 Submitted Waiting Approval 8
REQ000000625480 10-06-14 6:41 Waiting Approval Planning 5438
REQ000000625480 10-06-14 8:11 Planning Pending 10825266
REQ000000625480 13-10-14 15:12 Pending In Progress 936501
REQ000000625595 10-06-14 6:33 Submitted Waiting Approval 7
REQ000000625595 10-06-14 6:34 Waiting Approval Planning 5833
REQ000000625595 10-06-14 8:11 Planning Pending 10824676
REQ000000625595 13-10-14 15:02 Pending In Progress 938697
REQ000000625671 03-02-15 5:03 Closed Completed 869406
REQ000000625671 10-06-14 6:22 Submitted Waiting Approval 17
REQ000000625671 10-06-14 6:22 Waiting Approval Planning 5312450
REQ000000625671 10-08-14 18:03 Planning Pending 14267
REQ000000625671 10-08-14 22:01 Pending In Progress 5225567
REQ000000625671 10-10-14 9:33 In Progress Closed 10006157
REQ000000625699 10-06-14 6:36 Submitted Waiting Approval 6
REQ000000625699 10-06-14 6:36 Waiting Approval Planning 2646535
REQ000000625699 10-07-14 21:45 Planning Pending 2630892
REQ000000625699 10-08-14 8:33 Pending In Progress 6490873
REQ000000625846 10-06-14 10:47 Planning In Progress 12023188
REQ000000625846 10-06-14 6:14 Submitted Waiting Approval 7
REQ000000625846 10-06-14 6:14 Waiting Approval Planning 16355
REQ000000625856 10-06-14 6:26 Submitted Waiting Approval 12
REQ000000625856 10-06-14 6:26 Waiting Approval Planning 5312203
REQ000000625856 10-08-14 18:03 Planning Pending 14300
REQ000000625856 10-08-14 22:01 Pending In Progress 5237022
REQ000000625856 10-10-14 12:45 In Progress Completed 15129033
REQ000000625909 10-06-14 6:43 Submitted Waiting Approval 6
REQ000000625909 10-06-14 6:43 Waiting Approval Planning 8001440
REQ000000625909 10-09-14 21:20 Planning Pending 2829249
REQ000000625909 13-10-14 15:15 Pending In Progress 936693
REQ000000626847 10-06-14 8:27 Submitted Waiting Approval 17
REQ000000626847 10-06-14 8:27 Waiting Approval Planning 5304986
REQ000000626847 10-08-14 18:03 Planning Pending 14427
REQ000000626847 10-08-14 22:04 Pending In Progress 5236922
REQ000000626847 10-10-14 12:46 In Progress Completed 15129063
REQ000000632086 10-07-14 5:19 Draft Submitted 2683574
REQ000000632086 10-08-14 6:46 Submitted Waiting Approval 24
REQ000000632086 10-08-14 6:46 Waiting Approval Planning 6359252
REQ000000632086 11-04-14 10:36 In Progress Draft 7757009
REQ000000632518 10-07-14 15:46 Planning Pending 383
REQ000000632518 10-07-14 15:52 Pending In Progress 9397065
REQ000000632518 10-07-14 5:38 Submitted Waiting Approval 9
REQ000000632518 10-07-14 5:38 Waiting Approval Planning 36470
REQ000000633405 10-07-14 11:41 Planning In Progress 5369351
REQ000000633405 10-07-14 8:25 Submitted Waiting Approval 11
REQ000000633405 10-07-14 8:25 Waiting Approval Planning 11777
REQ000000633409 10-07-14 11:42 Planning In Progress 5370087
REQ000000633409 10-07-14 8:27 Submitted Waiting Approval 8
REQ000000633409 10-07-14 8:27 Waiting Approval Planning 11701
REQ000000634352 10-07-14 11:38 Submitted Waiting Approval 10
REQ000000634352 10-07-14 11:39 Waiting Approval Planning 36591
REQ000000634352 10-07-14 21:48 Planning In Progress 2621747
REQ000000634352 10-08-14 6:04 In Progress Closed 11186241

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 7 7 180.6 1,264.5
Closed 17 17 105.5 1,794.2
Completed 52 52 181.2 9,421.8
Draft 37 37 2.8 103.0
In Progress 179 179 140.0 25,066.7
Pending 35 35 36.0 1,261.0
Planning 411 411 35.3 14,503.3
Rejected 32 32 0.8 26.0
Submitted 484 484 0.1 54.1
Waiting Approval 434 434 28.0 12,161.7

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Cancelled Submitted 7 180.6 1,264.5
Closed Completed 16 111.6 1,785.1
Submitted 1 9.1 9.1
Completed Closed 12 101.1 1,212.8
Planning 6 122.1 732.7
Submitted 34 219.9 7,476.4
Draft Submitted 31 3.3 103.0
Waiting Approval 6 0.0 0.0
In Progress Cancelled 7 111.9 783.3
Closed 40 71.3 2,852.5
Completed 22 82.8 1,821.3
Draft 2 120.8 241.6
In Progress 1 24.1 24.1
Pending 4 37.6 150.3
Planning 10 72.9 729.3
Submitted 93 198.5 18,464.4
Pending Draft 1 132.1 132.1
In Progress 33 30.1 994.2
Submitted 1 134.7 134.7
Planning Cancelled 5 48.4 242.1
Closed 5 28.0 140.0
Completed 3 77.5 232.5
Draft 1 25.6 25.6
In Progress 357 33.7 12,047.7
Pending 34 27.4 931.2
Submitted 6 147.4 884.3
Rejected Draft 30 0.0 0.2
Planning 2 12.9 25.8
Submitted Closed 1 49.0 49.0
In Progress 1 5.0 5.0
Planning 4 0.0 0.1
Waiting Approval 478 0.0 0.1
Waiting Approval Closed 8 35.2 281.5
Completed 2 17.5 35.0
In Progress 15 99.6 1,494.0
Planning 375 26.4 9,903.1
Rejected 32 1.3 41.9
Submitted 2 203.1 406.1