1,242 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.

4.7% Cancelled 4.7% Closed 23.1% Completed 0.3% Draft 32.8% In Progress 2.1% Pending 16.2% Planning 1.6% Rejected 0.2% Submitted 14.2% Waiting Approval

Cause of delay This visual uses Group-Means: a Gramener algorithm

Group Count Days spent
Division 6 36.7% GRP with 58 rows; Average: 128 TOC with 9 rows; Average: 231 HP with 11 rows; Average: 240 R&Q with 14 rows; Average: 244 CA with 1 rows; Average: 281 DST with 6 rows; Average: 308
Customer 12 36.7% CON with 2 rows; Average: 1.9 SIG with 27 rows; Average: 112.9 SIGO with 21 rows; Average: 139.4 DPH with 2 rows; Average: 154.2 ITPH with 2 rows; Average: 169.1 CAL with 8 rows; Average: 207.5 TOC with 9 rows; Average: 231.1 GAPH with 6 rows; Average: 243.9 DV with 14 rows; Average: 244.2 HA with 1 rows; Average: 281.3 ROSD with 6 rows; Average: 308.4 ONPH with 1 rows; Average: 310.1
Entity 10 36.7% US354 with 1 rows; Average: 2.847 US002 with 12 rows; Average: 68.523 CHA28 with 9 rows; Average: 105.828 US014 with 37 rows; Average: 171.391 US339 with 9 rows; Average: 184.553 US015 with 9 rows; Average: 231.146 US077 with 14 rows; Average: 244.205 US061 with 1 rows; Average: 281.320 US005 with 1 rows; Average: 281.323 US023 with 6 rows; Average: 308.374

* Empty cell implies no impact

Summary of the causes

For this segment:

  • Entity is the largest driver. The 14 SRs for US077 took as long as 244 days (37% longer than average of 179 days) whereas the 12 SRs for SRs for US002 took just 69 days (62% below average.) If all Entitys perform as well as US002, the days spent can be reduced by 37%.
  • Customer is the second largest driver. The 14 SRs for DV took as long as 244 days (37% longer than average of 179 days) whereas the 27 SRs for SRs for SIG took just 113 days (37% below average.) If all Customers perform as well as SIG, the days spent can be reduced by 37%.
  • Division is the third largest driver. The 14 SRs for R&Q took as long as 244 days (37% longer than average of 179 days) whereas the 58 SRs for SRs for GRP took just 128 days (28% below average.) If all Divisions perform as well as GRP, the days spent can be reduced by 37%.

Service requests status Showing 100 out of 4,735

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
REQ000000610710 10-01-14 10:42 In Progress Pending 3696
REQ000000610710 10-01-14 11:43 Pending In Progress 24718091
REQ000000610710 10-01-14 8:31 Submitted Waiting Approval 11
REQ000000610710 10-01-14 8:31 Waiting Approval Planning 4414
REQ000000610710 10-01-14 9:45 Planning In Progress 3397
REQ000000610717 10-01-14 11:13 Planning Pending 188
REQ000000610717 10-01-14 11:16 Pending Cancelled 23859847
REQ000000610717 10-01-14 8:57 Submitted Waiting Approval 16
REQ000000610717 10-01-14 8:57 Waiting Approval Planning 8141
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
REQ000000611023 10-01-14 9:42 Submitted Waiting Approval 21
REQ000000611023 10-01-14 9:43 Waiting Approval Planning 2652416
REQ000000611023 10-02-14 2:29 Planning Pending 16010
REQ000000611023 10-02-14 6:56 Pending In Progress 21196714
REQ000000611023 13-10-14 14:55 In Progress Completed 1204222
REQ000000611023 26-02-15 1:42 Closed Completed 18873661
REQ000000611023 27-10-14 13:25 Completed In Progress 170129
REQ000000611023 29-10-14 12:41 In Progress Closed 10328469
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
REQ000000612161 10-01-14 12:51 Submitted Waiting Approval 10
REQ000000612161 10-01-14 12:51 Waiting Approval Planning 5912
REQ000000612161 10-01-14 14:30 Planning Completed 5249743
REQ000000612161 10-06-14 6:09 In Progress Closed 16543031
REQ000000612161 12-03-14 8:46 Completed In Progress 7766599
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
REQ000000618164 10-02-14 14:54 Submitted Waiting Approval 11
REQ000000618164 10-02-14 14:55 Waiting Approval Completed 154426
REQ000000618164 10-05-14 18:39 Planning In Progress 7914316
REQ000000618164 10-08-14 9:04 In Progress Closed 11175438
REQ000000618164 12-02-14 9:48 Completed Planning 7548638
REQ000000618166 10-02-14 14:56 Submitted Waiting Approval 10
REQ000000618166 10-02-14 14:56 Waiting Approval Completed 155569
REQ000000618166 10-05-14 18:39 Planning In Progress 7914565
REQ000000618166 10-08-14 9:08 In Progress Closed 11175183
REQ000000618166 12-02-14 10:09 Completed Planning 7547433
REQ000000618272 10-02-14 15:12 Submitted Waiting Approval 10
REQ000000618272 10-02-14 15:13 Waiting Approval Completed 153389
REQ000000618272 10-03-14 12:20 Planning In Progress 9303
REQ000000618272 10-03-14 14:55 In Progress Closed 24373576
REQ000000618272 12-02-14 9:49 Completed Planning 2255474
REQ000000618529 10-02-14 14:53 Submitted Waiting Approval 12
REQ000000618529 10-02-14 14:53 Waiting Approval Completed 154741
REQ000000618529 10-05-14 18:39 Planning In Progress 2647496
REQ000000618529 10-06-14 10:04 In Progress Closed 16442267
REQ000000618529 12-02-14 9:52 Completed Planning 7548406
REQ000000622323 10-03-14 14:09 Submitted Waiting Approval 11
REQ000000622323 10-03-14 14:10 Waiting Approval Planning 1640
REQ000000622323 10-03-14 14:37 Planning In Progress 7940628
REQ000000622323 10-06-14 12:21 In Progress Closed 16434053
REQ000000622323 12-02-14 10:20 Completed Submitted 2260178
REQ000000622606 10-03-14 14:11 Submitted Waiting Approval 13
REQ000000622606 10-03-14 14:11 Waiting Approval Planning 1567
REQ000000622606 10-03-14 14:37 Planning In Progress 7941190
REQ000000622606 10-06-14 12:31 In Progress Closed 16433454
REQ000000622606 12-02-14 10:18 Completed Submitted 2260380
REQ000000622696 10-03-14 15:34 Submitted Waiting Approval 7
REQ000000622696 10-03-14 15:35 Waiting Approval Planning 30148
REQ000000622696 10-03-14 23:57 Planning In Progress 13191512
REQ000000622696 10-08-14 16:16 In Progress Closed 11149558
REQ000000622696 12-02-14 10:06 Completed Submitted 2266121
REQ000000622729 10-03-14 15:16 Submitted Waiting Approval 7
REQ000000622729 10-03-14 15:16 Waiting Approval Planning 31261
REQ000000622729 10-03-14 23:57 Planning In Progress 13193803
REQ000000622729 10-08-14 16:54 In Progress Closed 11147256
REQ000000622729 12-02-14 10:07 Completed Submitted 2264974
REQ000000622732 10-03-14 15:29 Submitted Waiting Approval 8

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 72 72 129.2 9,299.7
Closed 87 87 107.5 9,355.4
Completed 281 281 161.9 45,503.7
Draft 110 110 5.1 560.8
In Progress 632 632 102.4 64,697.0
Pending 70 70 58.7 4,107.6
Planning 985 985 32.5 31,990.2
Rejected 83 83 38.3 3,174.9
Submitted 1268 1268 0.3 438.3
Waiting Approval 1147 1147 24.4 27,959.8

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Cancelled Draft 26 116.6 3,030.5
In Progress 1 8.2 8.2
Pending 2 30.0 60.0
Planning 10 90.7 907.3
Submitted 33 160.4 5,293.8
Closed Completed 59 115.2 6,798.8
In Progress 5 60.9 304.3
Planning 7 48.5 339.8
Submitted 16 119.5 1,912.5
Completed Closed 53 79.2 4,200.1
Completed 1 0.0 0.0
In Progress 10 64.2 642.2
Planning 22 120.4 2,649.1
Submitted 195 194.9 38,012.2
Draft Cancelled 11 22.4 246.7
Completed 2 45.5 90.9
Submitted 82 2.7 223.1
Waiting Approval 15 0.0 0.0
In Progress Cancelled 41 32.0 1,310.7
Closed 241 82.1 19,785.5
Completed 79 69.8 5,515.9
Draft 8 153.6 1,228.6
In Progress 2 11.0 22.0
Pending 50 37.5 1,877.3
Planning 17 41.7 709.0
Submitted 194 176.5 34,248.1
Pending Cancelled 3 145.5 436.5
Draft 1 132.1 132.1
In Progress 59 38.5 2,270.7
Submitted 7 181.2 1,268.2
Planning Cancelled 32 51.6 1,651.5
Closed 12 47.1 564.7
Completed 23 49.1 1,128.9
Draft 2 19.8 39.7
In Progress 818 26.4 21,630.2
Pending 58 22.9 1,326.5
Rejected 3 13.9 41.6
Submitted 37 151.5 5,607.1
Rejected Cancelled 1 0.0 0.0
Draft 69 11.2 769.8
Planning 2 12.9 25.8
Rejected 1 124.9 124.9
Submitted 10 225.4 2,254.5
Submitted Closed 1 49.0 49.0
Completed 2 43.0 86.0
In Progress 1 5.0 5.0
Planning 11 26.4 290.9
Waiting Approval 1253 0.0 7.4
Waiting Approval Cancelled 72 30.3 2,181.1
Closed 20 32.8 656.2
Completed 16 27.8 445.1
Draft 4 58.5 233.8
In Progress 56 54.3 3,043.0
Planning 881 21.5 18,898.8
Rejected 96 21.8 2,095.7
Submitted 2 203.1 406.1