754 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.0% Cancelled 4.8% Closed 21.9% Completed 0.2% Draft 35.5% In Progress 2.3% Pending 17.4% Planning 0.4% Rejected 0.2% Submitted 16.3% Waiting Approval

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

Group Count Days spent
Site 10 189.6% CHDQ with 1 rows; Average: 0.0 TWTF with 4 rows; Average: 1.0 INYG with 2 rows; Average: 1.8 MYEO with 4 rows; Average: 25.2 INIU with 4 rows; Average: 28.1 BRMY with 8 rows; Average: 48.4 INTU with 16 rows; Average: 58.8 INIO with 3 rows; Average: 60.8 SGQJ with 2 rows; Average: 92.1 CZSF with 11 rows; Average: 239.6
Org 5 189.6% FM with 1 rows; Average: 0 RL with 2 rows; Average: 2 FT with 4 rows; Average: 28 AS with 37 rows; Average: 49 BD with 11 rows; Average: 240
Country 6 165.4% Taiwan with 3 rows; Average: 1.0 Brazil with 12 rows; Average: 41.6 USA with 22 rows; Average: 47.5 India with 3 rows; Average: 60.8 Singapore with 3 rows; Average: 61.7 United Kingdom with 12 rows; Average: 219.6
Region 3 165.4% APAC with 35 rows; Average: 44 LAC with 8 rows; Average: 48 EMEA with 12 rows; Average: 220
Entity 10 162.7% SG015 with 1 rows; Average: 1.035 TW003 with 3 rows; Average: 1.043 CH024 with 2 rows; Average: 1.838 CH018 with 1 rows; Average: 7.712 BR003 with 12 rows; Average: 41.627 CH028 with 19 rows; Average: 54.397 IN001 with 3 rows; Average: 60.792 SG012 with 2 rows; Average: 92.063 US014 with 11 rows; Average: 217.322 US002 with 1 rows; Average: 244.922

* Empty cell implies no impact

Summary of the causes

For this segment:

  • Org is the largest driver. The 11 SRs for BD took as long as 240 days (190% longer than average of 83 days) whereas the 37 SRs for SRs for AS took just 49 days (41% below average.) If all Orgs perform as well as AS, the days spent can be reduced by 190%.
  • Site is the second largest driver. The 11 SRs for CZSF took as long as 240 days (190% longer than average of 83 days) whereas the 16 SRs for SRs for INTU took just 59 days (29% below average.) If all Sites perform as well as INTU, the days spent can be reduced by 190%.
  • Region is the third largest driver. The 12 SRs for EMEA took as long as 220 days (165% longer than average of 83 days) whereas the 35 SRs for SRs for APAC took just 44 days (47% below average.) If all Regions perform as well as APAC, the days spent can be reduced by 165%.

Service requests status Showing 100 out of 2,867

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
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
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
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
REQ000000625488 10-06-14 6:49 Submitted Waiting Approval 6
REQ000000625488 10-06-14 6:49 Waiting Approval Planning 5301095
REQ000000625488 10-08-14 15:21 Planning Pending 1709
REQ000000625488 10-08-14 15:49 Pending In Progress 6733192
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
REQ000000625762 10-06-14 12:07 Planning Pending 10811155
REQ000000625762 10-06-14 6:25 Submitted Waiting Approval 9

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 6 6 191.4 1,148.3
Closed 46 46 122.0 5,613.1
Completed 139 139 184.4 25,634.7
Draft 51 51 5.6 284.5
In Progress 336 336 123.9 41,645.9
Pending 58 58 46.7 2,708.0
Planning 683 683 29.8 20,357.6
Rejected 37 37 11.6 429.5
Submitted 789 789 0.3 247.0
Waiting Approval 722 722 26.5 19,126.5

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Cancelled Submitted 6 191.4 1,148.3
Closed Completed 37 117.5 4,346.2
Planning 2 73.8 147.6
Submitted 7 159.9 1,119.4
Completed Closed 18 69.8 1,256.7
In Progress 3 144.3 433.0
Planning 11 108.6 1,194.6
Submitted 107 212.6 22,750.4
Draft Completed 1 90.2 90.2
Submitted 42 4.6 194.3
Waiting Approval 8 0.0 0.0
In Progress Cancelled 7 62.5 437.4
Closed 141 76.4 10,766.6
Completed 27 78.0 2,106.8
Draft 7 141.2 988.2
In Progress 1 24.1 24.1
Pending 7 24.1 168.4
Planning 13 85.3 1,109.4
Submitted 133 195.8 26,045.1
Pending Cancelled 1 276.2 276.2
Draft 1 132.1 132.1
In Progress 55 39.4 2,165.0
Submitted 1 134.7 134.7
Planning Cancelled 10 67.8 678.0
Closed 7 22.3 155.9
Completed 8 43.0 344.1
Draft 2 19.8 39.7
In Progress 581 28.0 16,241.8
Pending 56 24.1 1,349.7
Rejected 3 13.9 41.6
Submitted 16 94.2 1,506.8
Rejected Draft 34 8.2 278.8
Planning 2 12.9 25.8
Rejected 1 124.9 124.9
Submitted Closed 1 49.0 49.0
Completed 2 43.0 86.0
In Progress 1 5.0 5.0
Planning 4 26.7 106.9
Waiting Approval 781 0.0 0.1
Waiting Approval Cancelled 2 51.1 102.3
Closed 5 45.7 228.4
Completed 11 26.1 286.9
Draft 4 58.5 233.8
In Progress 28 62.8 1,759.1
Planning 635 24.8 15,734.1
Rejected 35 10.7 375.9
Submitted 2 203.1 406.1