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

5.0% Closed 40.9% Completed 0.0% Draft 26.5% In Progress 0.0% Pending 11.2% Planning 0.0% Rejected 1.0% Submitted 15.4% Waiting Approval

Cause of delay This visual uses TopCause: a Gramener algorithm

Group Count Days spent
Division 7 56.4% RIBN with 1 rows; Average: 92 GRP with 73 rows; Average: 106 HP with 12 rows; Average: 220 TOC with 9 rows; Average: 231 R&Q with 14 rows; Average: 244 CA with 1 rows; Average: 281 DST with 6 rows; Average: 308
Customer 13 56.4% CON with 7 rows; Average: 3.2 BR with 2 rows; Average: 45.9 ITPH with 11 rows; Average: 58.4 SIG with 27 rows; Average: 112.9 SIGO with 22 rows; Average: 133.1 DPH with 2 rows; Average: 154.2 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 56.4% US354 with 2 rows; Average: 2.842 US002 with 12 rows; Average: 68.523 CHA28 with 9 rows; Average: 105.828 US339 with 13 rows; Average: 128.999 US014 with 49 rows; Average: 137.503 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
Org 4 14.9% FM with 1 rows; Average: 0 AS with 17 rows; Average: 26 BD with 97 rows; Average: 179 RL with 1 rows; Average: 258
Site 2 14.5% CHDQ with 17 rows; Average: 24 CZSF with 99 rows; Average: 179
Approver 18 3.1% DSWNH1 with 1 rows; Average: 0.206 BJYJZ1 with 1 rows; Average: 1.051 CHHGS1 with 6 rows; Average: 3.486 CAPNE1 with 2 rows; Average: 46.298 BEUTQ1 with 15 rows; Average: 50.412 FEDJP1 with 1 rows; Average: 64.747 DEZNE1 with 1 rows; Average: 121.732 CAKIF1 with 16 rows; Average: 144.567 HANUS1 with 40 rows; Average: 160.879 GOWAU1 with 7 rows; Average: 180.535 BAWQE1 with 2 rows; Average: 194.119 BHQOO1 with 9 rows; Average: 242.888 BUTHE1 with 2 rows; Average: 281.272 ISXKV1 with 2 rows; Average: 281.315 BHLOW1 with 2 rows; Average: 281.821 JARON1 with 2 rows; Average: 308.282 CHUIQ1 with 2 rows; Average: 308.292 GRWTH1 with 5 rows; Average: 308.302

* 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 (56% longer than average of 156 days) whereas the 12 SRs for SRs for US002 took just 69 days (56% below average.) If all Entitys perform as well as US002, the days spent can be reduced by 56%.
  • Customer is the second largest driver. The 14 SRs for DV took as long as 244 days (56% longer than average of 156 days) whereas the 11 SRs for SRs for ITPH took just 58 days (63% below average.) If all Customers perform as well as ITPH, the days spent can be reduced by 56%.
  • Division is the third largest driver. The 14 SRs for R&Q took as long as 244 days (56% longer than average of 156 days) whereas the 73 SRs for SRs for GRP took just 106 days (32% below average.) If all Divisions perform as well as GRP, the days spent can be reduced by 56%.

Service requests status Showing 100 out of 469

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
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
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
REQ000000622732 10-03-14 15:29 Waiting Approval Planning 30503
REQ000000622732 10-03-14 23:57 Planning In Progress 13192837
REQ000000622732 10-08-14 16:38 In Progress Closed 11148227
REQ000000622732 12-02-14 10:06 Completed Submitted 2265757
REQ000000623101 10-03-14 15:42 Submitted Waiting Approval 8
REQ000000623101 10-03-14 15:42 Waiting Approval Planning 29701
REQ000000623101 10-03-14 23:57 Planning In Progress 13195625
REQ000000623101 10-08-14 17:24 In Progress Closed 11145429
REQ000000623101 12-02-14 10:06 Completed Submitted 2266556
REQ000000623104 10-03-14 15:45 Submitted Waiting Approval 10
REQ000000623104 10-03-14 15:45 Waiting Approval Planning 2621683
REQ000000623104 10-04-14 0:00 Planning In Progress 10597568
REQ000000623104 10-08-14 15:46 In Progress Closed 11151312
REQ000000623104 12-02-14 10:07 Completed Submitted 2266717
REQ000000629357 10-06-14 14:01 Submitted Waiting Approval 15
REQ000000629357 10-06-14 14:01 Waiting Approval Planning 5703
REQ000000629357 10-06-14 15:37 Planning In Progress 2568854
REQ000000629357 10-07-14 9:11 In Progress Closed 13853447
REQ000000629357 12-02-14 10:21 Completed Submitted 10208421
REQ000000629369 10-06-14 14:04 Submitted Waiting Approval 11
REQ000000629369 10-06-14 14:04 Waiting Approval Planning 21224
REQ000000629369 10-06-14 19:58 Planning In Progress 2553329
REQ000000629369 10-07-14 9:13 In Progress Closed 13853287
REQ000000629369 12-02-14 10:22 Completed Submitted 10208533
REQ000000671704 12-02-14 10:02 Completed Submitted 21152701
REQ000000671704 15-10-14 13:05 Planning In Progress 802
REQ000000671704 15-10-14 13:18 In Progress Closed 5457795
REQ000000671704 15-10-14 5:47 Submitted Waiting Approval 10
REQ000000671704 15-10-14 5:47 Waiting Approval Planning 26256
REQ000000672251 12-03-14 9:52 Completed Submitted 18740722
REQ000000672251 15-10-14 7:37 Submitted Waiting Approval 11
REQ000000672251 15-10-14 7:38 Waiting Approval Planning 740409
REQ000000672251 23-10-14 21:18 Planning In Progress 41718
REQ000000672251 24-10-14 8:53 In Progress Closed 4782790
REQ000000672259 15-10-14 7:39 Submitted Waiting Approval 11
REQ000000672259 15-10-14 7:39 Waiting Approval Planning 740295
REQ000000672259 23-10-14 21:17 Planning In Progress 49009
REQ000000672340 15-10-14 7:47 Submitted Waiting Approval 9
REQ000000672340 15-10-14 7:47 Waiting Approval Planning 739832
REQ000000672340 23-10-14 21:17 Planning In Progress 44193
REQ000000672608 15-10-14 7:41 Submitted Waiting Approval 13
REQ000000672608 15-10-14 7:41 Waiting Approval Planning 740193
REQ000000672608 23-10-14 21:17 Planning In Progress 43394
REQ000000672621 15-10-14 7:49 Submitted Waiting Approval 15
REQ000000672621 15-10-14 7:49 Waiting Approval Planning 739702
REQ000000672621 23-10-14 21:17 Planning In Progress 45512
REQ000000672622 15-10-14 7:51 Submitted Waiting Approval 12
REQ000000672622 15-10-14 7:51 Waiting Approval Planning 739613
REQ000000672622 23-10-14 21:18 Planning In Progress 49340
REQ000000672626 15-10-14 7:52 Submitted Waiting Approval 12
REQ000000672626 15-10-14 7:52 Waiting Approval Planning 739489
REQ000000672626 23-10-14 21:17 Planning In Progress 42361
REQ000000678384 16-10-14 13:06 Planning In Progress 61660
REQ000000678384 16-10-14 7:31 Submitted Waiting Approval 13
REQ000000678384 16-10-14 7:31 Waiting Approval Planning 20113
REQ000000678620 16-10-14 13:06 Planning In Progress 61655
REQ000000678620 16-10-14 7:28 Submitted Waiting Approval 13
REQ000000678620 16-10-14 7:28 Waiting Approval Planning 20271
REQ000000679147 12-02-14 10:08 Completed Submitted 21249493
REQ000000679147 16-10-14 11:19 Planning In Progress 3297
REQ000000679147 16-10-14 12:14 In Progress Closed 5375256
REQ000000679147 16-10-14 8:46 Submitted Waiting Approval 10
REQ000000679147 16-10-14 8:46 Waiting Approval Planning 9158
REQ000000685097 12-02-14 10:11 Completed Submitted 21338765
REQ000000685097 17-10-14 13:56 Planning In Progress 236365
REQ000000685097 17-10-14 9:37 Submitted Waiting Approval 11
REQ000000685097 17-10-14 9:38 Waiting Approval Planning 15535
REQ000000685097 20-10-14 7:36 In Progress Closed 5046335
REQ000000685899 12-02-14 10:10 Completed Submitted 21348755
REQ000000685899 17-10-14 12:23 Submitted Waiting Approval 6
REQ000000685899 17-10-14 12:23 Waiting Approval Planning 5642
REQ000000685899 17-10-14 13:57 Planning In Progress 241126
REQ000000685899 20-10-14 8:56 In Progress Closed 5041535
REQ000000686119 12-02-14 10:10 Completed Submitted 21346686
REQ000000686119 17-10-14 11:48 Submitted Waiting Approval 12
REQ000000686119 17-10-14 11:48 Waiting Approval Planning 7707
REQ000000686119 17-10-14 13:57 Planning In Progress 238109
REQ000000686119 20-10-14 8:05 In Progress Closed 5044570
REQ000000686142 12-02-14 10:11 Completed Submitted 21347284
REQ000000686142 17-10-14 11:59 Submitted Waiting Approval 16
REQ000000686142 17-10-14 11:59 Waiting Approval Planning 7035
REQ000000686142 17-10-14 13:57 Planning In Progress 238899
REQ000000686142 20-10-14 8:18 In Progress Closed 5043794
REQ000000686528 12-02-14 10:11 Completed Submitted 21350397

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 7 7 130.5 913.3
Completed 43 43 172.1 7,398.4
Draft 5 5 0.1 0.7
In Progress 56 56 85.6 4,795.6
Pending 1 1 0.0 0.0
Planning 116 116 17.5 2,034.3
Rejected 4 4 0.0 0.0
Submitted 120 120 1.5 184.5
Waiting Approval 117 117 23.8 2,780.3

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Closed Completed 7 130.5 913.3
Completed Closed 2 149.1 298.1
Planning 1 26.1 26.1
Submitted 40 176.9 7,074.1
Draft Completed 1 0.7 0.7
Submitted 2 0.0 0.0
Waiting Approval 2 0.0 0.0
In Progress Cancelled 5 29.2 146.1
Closed 47 90.4 4,247.7
Completed 3 48.2 144.7
Submitted 1 257.1 257.1
Pending In Progress 1 0.0 0.0
Planning Cancelled 2 0.8 1.6
Closed 1 48.2 48.2
In Progress 112 17.7 1,984.2
Pending 1 0.2 0.2
Rejected Draft 4 0.0 0.0
Submitted Planning 2 92.3 184.5
Waiting Approval 118 0.0 0.0
Waiting Approval Completed 1 1.8 1.8
Planning 113 24.6 2,778.6
Rejected 3 0.0 0.0