1,247 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.6% Cancelled 4.7% Closed 22.7% Completed 0.4% Draft 33.1% In Progress 2.1% Pending 16.2% Planning 1.6% Rejected 0.2% Submitted 14.4% Waiting Approval

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

Group Count Days spent
Division 6 36.1% GRP with 56 rows; Average: 127 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.1% CON with 2 rows; Average: 1.95 SIG with 27 rows; Average: 112.94 SIGO with 20 rows; Average: 133.48 DPH with 2 rows; Average: 154.25 CAL with 8 rows; Average: 207.49 TOC with 9 rows; Average: 231.15 GAPH with 6 rows; Average: 243.94 DV with 14 rows; Average: 244.21 HA with 1 rows; Average: 281.32 ITPH with 1 rows; Average: 308.31 ROSD with 6 rows; Average: 308.37 ONPH with 1 rows; Average: 310.09
Entity 10 36.1% US354 with 1 rows; Average: 2.847 US002 with 12 rows; Average: 68.523 CHA28 with 9 rows; Average: 105.828 US014 with 35 rows; Average: 172.956 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 (36% 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 36%.
  • Customer is the second largest driver. The 14 SRs for DV took as long as 244 days (36% 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 36%.
  • Division is the third largest driver. The 14 SRs for R&Q took as long as 244 days (36% longer than average of 179 days) whereas the 56 SRs for SRs for GRP took just 127 days (29% below average.) If all Divisions perform as well as GRP, the days spent can be reduced by 36%.

Service requests status Showing 100 out of 4,736

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 70 70 130.1 9,106.7
Closed 87 87 107.6 9,361.7
Completed 276 276 163.3 45,062.8
Draft 114 114 7.5 849.3
In Progress 630 630 104.0 65,520.1
Pending 70 70 58.4 4,090.8
Planning 981 981 32.8 32,152.6
Rejected 83 83 38.7 3,210.4
Submitted 1274 1274 0.3 416.0
Waiting Approval 1151 1151 24.7 28,446.5

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 1 60.0 60.0
Planning 10 90.7 907.3
Submitted 32 159.4 5,100.7
Closed Completed 59 115.2 6,798.8
In Progress 5 60.9 304.3
Planning 6 51.9 311.5
Submitted 17 114.5 1,947.1
Completed Closed 51 81.1 4,138.6
Completed 1 0.0 0.0
In Progress 10 64.2 642.2
Planning 20 123.0 2,459.5
Submitted 194 195.0 37,822.5
Draft Cancelled 11 22.4 246.7
Completed 2 45.5 90.9
Submitted 91 5.6 511.6
Waiting Approval 10 0.0 0.0
In Progress Cancelled 40 32.8 1,310.4
Closed 241 82.1 19,785.5
Completed 76 74.1 5,631.5
Draft 8 153.6 1,228.6
In Progress 2 11.0 22.0
Pending 50 37.5 1,877.3
Planning 18 53.6 964.7
Submitted 195 177.9 34,700.2
Pending Cancelled 2 141.6 283.2
Draft 1 132.1 132.1
In Progress 60 40.1 2,407.2
Submitted 7 181.2 1,268.2
Planning Cancelled 32 51.6 1,651.5
Closed 12 47.1 564.7
Completed 22 49.7 1,093.7
Draft 1 14.1 14.1
In Progress 815 26.8 21,853.3
Pending 59 22.5 1,326.6
Rejected 3 13.9 41.6
Submitted 37 151.5 5,607.1
Rejected Cancelled 1 0.0 0.0
Draft 69 11.7 805.3
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 1 67.0 67.0
Planning 8 36.6 292.5
Waiting Approval 1264 0.0 7.4
Waiting Approval Cancelled 75 29.1 2,181.1
Closed 20 32.8 656.2
Completed 15 28.0 420.4
Draft 4 58.5 233.8
In Progress 56 54.7 3,064.2
Planning 881 22.0 19,358.1
Rejected 97 21.7 2,109.2
Submitted 3 141.1 423.4