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

3.9% Closed 31.7% Completed 0.0% Draft 26.7% In Progress 10.6% Planning 0.0% Rejected 0.0% Submitted 27.1% Waiting Approval

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

Group Count Days spent
Approver 9 81.8% CHHGS1 with 1 rows; Average: 0.1 DSWNH1 with 1 rows; Average: 0.2 BEUTQ1 with 15 rows; Average: 50.4 FEDJP1 with 1 rows; Average: 64.7 CAPNE1 with 1 rows; Average: 91.7 CAKIF1 with 12 rows; Average: 102.0 GOWAU1 with 2 rows; Average: 155.1 HANUS1 with 11 rows; Average: 250.0 GRWTH1 with 5 rows; Average: 308.3
Org 4 25.8% FM with 1 rows; Average: 0 AS with 12 rows; Average: 36 BD with 35 rows; Average: 173 RL with 1 rows; Average: 258
Site 2 24.6% CHDQ with 12 rows; Average: 33 CZSF with 37 rows; Average: 171

* Empty cell implies no impact

Summary of the causes

For this segment:

  • Approver is the largest driver. The 11 SRs for HANUS1 took as long as 250 days (82% longer than average of 138 days) whereas the 15 SRs for SRs for BEUTQ1 took just 50 days (63% below average.) If all Approvers perform as well as BEUTQ1, the days spent can be reduced by 82%.
  • Org is the second largest driver. The 35 SRs for BD took as long as 173 days (26% longer than average of 138 days) whereas the 12 SRs for SRs for AS took just 36 days (74% below average.) If all Orgs perform as well as AS, the days spent can be reduced by 26%.
  • Site is the third largest driver. The 37 SRs for CZSF took as long as 171 days (25% longer than average of 138 days) whereas the 12 SRs for SRs for CHDQ took just 33 days (76% below average.) If all Sites perform as well as CHDQ, the days spent can be reduced by 25%.

Service requests status Showing 100 out of 303

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
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
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
REQ000000686528 17-10-14 12:51 Submitted Waiting Approval 10
REQ000000686528 17-10-14 12:51 Waiting Approval Planning 3969
REQ000000686528 17-10-14 13:57 Planning In Progress 242632
REQ000000686528 20-10-14 9:21 In Progress Closed 5040036
REQ000000717278 24-10-14 8:13 Submitted Waiting Approval 8
REQ000000717278 24-10-14 8:13 Waiting Approval Planning 535944
REQ000000717278 30-10-14 13:06 Planning In Progress 73964
REQ000000717278 31-10-14 9:38 In Progress Cancelled 2321298
REQ000000717407 24-10-14 8:19 Submitted Waiting Approval 11
REQ000000717407 24-10-14 8:19 Waiting Approval Planning 535612
REQ000000717407 30-10-14 13:06 Planning In Progress 73993
REQ000000717407 31-10-14 9:39 In Progress Cancelled 2321180
REQ000000738990 12-02-14 10:32 Completed Submitted 22375149
REQ000000738990 29-10-14 17:22 Planning In Progress 49460
REQ000000738990 29-10-14 9:51 Submitted Waiting Approval 10
REQ000000738990 29-10-14 9:51 Waiting Approval Planning 27047
REQ000000738990 30-10-14 7:06 In Progress Closed 4184095
REQ000000764663 11-04-14 10:01 Planning In Progress 2614047
REQ000000764663 11-04-14 9:15 Submitted Waiting Approval 18
REQ000000764663 11-04-14 9:15 Waiting Approval Planning 2748
REQ000000764663 11-05-14 16:09 In Progress Closed 19099049
REQ000000764663 12-03-14 10:41 Completed Submitted 2586819
REQ000000781820 11-06-14 17:48 Submitted Waiting Approval 16
REQ000000781820 11-06-14 17:48 Waiting Approval Planning 13196039
REQ000000781820 11-11-14 11:22 Planning In Progress 8221
REQ000000781820 11-11-14 13:39 In Progress Closed 3210400
REQ000000781820 12-03-14 10:44 Completed Submitted 7887854
REQ000000791661 11-10-14 10:49 Submitted Waiting Approval 17
REQ000000791661 11-10-14 10:49 Waiting Approval Planning 2947272
REQ000000791661 12-03-14 10:52 Completed Submitted 18402973
REQ000000791661 14-11-14 13:30 Planning In Progress 346513
REQ000000791661 18-11-14 13:45 In Progress Closed 2605243
REQ000000797710 11-11-14 9:12 Submitted Waiting Approval 20

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 3 3 130.5 391.4
Completed 21 21 151.2 3,174.7
Draft 6 6 0.0 0.0
In Progress 29 29 92.1 2,670.2
Planning 77 77 13.8 1,064.4
Rejected 6 6 0.1 0.3
Submitted 82 82 0.0 0.3
Waiting Approval 79 79 34.4 2,716.8

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Closed Completed 3 130.5 391.4
Completed Closed 2 194.8 389.6
Planning 1 26.1 26.1
Submitted 18 153.3 2,758.9
Draft Submitted 5 0.0 0.0
Waiting Approval 1 0.0 0.0
In Progress Cancelled 2 26.9 53.7
Closed 21 90.3 1,895.3
Completed 3 64.9 194.8
Submitted 3 175.5 526.4
Planning Cancelled 1 127.1 127.1
Closed 1 34.1 34.1
In Progress 75 12.0 903.2
Rejected Draft 6 0.1 0.3
Submitted Planning 1 0.3 0.3
Waiting Approval 81 0.0 0.0
Waiting Approval Completed 1 1.8 1.8
Planning 73 36.4 2,655.1
Rejected 5 12.0 59.9