225 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.6% Cancelled 4.0% Closed 19.4% Completed 0.0% Draft 28.4% In Progress 2.8% Pending 29.5% Planning 0.0% Rejected 0.0% Submitted 14.2% Waiting Approval

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

Group Count Days spent

* Empty cell implies no impact

Summary of the causes

There are no significant causes of delay that we can infer for this segment from the data.

Service requests status Showing 100 out of 859

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
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
REQ000000614302 10-01-14 19:12 Submitted Waiting Approval 13
REQ000000614302 10-01-14 19:12 Waiting Approval Planning 2673372
REQ000000614302 10-02-14 17:48 Planning Completed 5269569
REQ000000614302 10-08-14 18:50 In Progress Closed 11400260
REQ000000614302 12-04-14 17:34 Completed In Progress 10372541
REQ000000626045 10-06-14 11:38 Planning Pending 10812920
REQ000000626045 10-06-14 6:58 Submitted Waiting Approval 6
REQ000000626045 10-06-14 6:58 Waiting Approval Planning 16750
REQ000000626045 13-10-14 15:13 Pending In Progress 1276723
REQ000000626045 15-11-14 10:50 Pending In Progress 249902
REQ000000626045 28-10-14 9:52 In Progress Pending 1558724
REQ000000626119 10-06-14 6:52 Submitted Waiting Approval 6
REQ000000626119 10-06-14 6:52 Waiting Approval Planning 15983000
REQ000000626119 12-12-14 6:35 Planning In Progress 288198
REQ000000641411 10-08-14 12:13 Submitted Waiting Approval 16
REQ000000641411 10-08-14 12:13 Waiting Approval Planning 272
REQ000000641411 10-08-14 12:18 Planning In Progress 2656352
REQ000000641411 10-09-14 6:11 In Progress Closed 8507458
REQ000000641411 12-02-14 9:48 Completed Submitted 15474322
REQ000000646355 10-09-14 10:02 Planning In Progress 16720
REQ000000646355 10-09-14 14:40 In Progress Closed 8476865
REQ000000646355 10-09-14 9:37 Submitted Waiting Approval 9
REQ000000646355 10-09-14 9:37 Waiting Approval Planning 1466
REQ000000646355 12-02-14 10:03 Completed Submitted 18142446
REQ000000646712 10-09-14 12:26 Planning In Progress 2441
REQ000000646712 10-09-14 13:07 In Progress Closed 8482466
REQ000000646712 10-09-14 9:52 Submitted Waiting Approval 11
REQ000000646712 10-09-14 9:52 Waiting Approval Planning 9262
REQ000000646712 12-02-14 10:03 Completed Submitted 18143303
REQ000000661616 11-03-14 16:45 Planning Pending 7924299
REQ000000661616 11-06-14 9:57 Pending Submitted 10726312
REQ000000661616 12-02-14 16:06 In Progress Planning 2335143
REQ000000661616 13-10-14 13:29 Submitted Waiting Approval 11
REQ000000668299 11-05-14 10:23 In Progress Draft 13492691
REQ000000668299 14-10-14 14:21 Draft Submitted 491863
REQ000000668299 20-10-14 6:59 Submitted Waiting Approval 17
REQ000000668299 20-10-14 6:59 Waiting Approval Planning 839833
REQ000000668299 30-10-14 0:17 Planning Pending 140347
REQ000000675101 12-02-14 10:08 Completed Submitted 21181176
REQ000000675101 15-10-14 13:48 Submitted Waiting Approval 14
REQ000000675101 15-10-14 13:48 Waiting Approval Planning 63025
REQ000000675101 16-10-14 7:18 Planning In Progress 6066
REQ000000675101 16-10-14 9:00 In Progress Closed 5386913
REQ000000675142 12-02-14 10:08 Completed Submitted 21182234
REQ000000675142 15-10-14 14:05 Submitted Waiting Approval 16
REQ000000675142 15-10-14 14:05 Waiting Approval Planning 62781
REQ000000675142 16-10-14 7:31 Planning In Progress 6606
REQ000000675142 16-10-14 9:22 In Progress Closed 5385598
REQ000000675254 12-02-14 10:07 Completed Submitted 21182871
REQ000000675254 15-10-14 14:15 Submitted Waiting Approval 18
REQ000000675254 15-10-14 14:15 Waiting Approval Planning 61232
REQ000000675254 16-10-14 7:16 Planning In Progress 8170
REQ000000675254 16-10-14 9:32 In Progress Closed 5384976
REQ000000675324 12-02-14 10:35 Completed Submitted 21181571
REQ000000675324 15-10-14 14:21 Submitted Waiting Approval 15
REQ000000675324 15-10-14 14:21 Waiting Approval Planning 61061
REQ000000675324 16-10-14 7:19 Planning In Progress 3655
REQ000000675324 16-10-14 8:20 In Progress Closed 5389315
REQ000000675376 15-10-14 15:06 Draft Submitted 402465
REQ000000675376 20-10-14 6:53 Submitted Waiting Approval 20
REQ000000675376 20-10-14 6:54 Waiting Approval Rejected 4000
REQ000000675376 20-10-14 8:00 Rejected Draft 523
REQ000000675376 20-10-14 8:09 Draft Submitted 78
REQ000000675376 20-10-14 8:10 Submitted Waiting Approval 1
REQ000000675376 20-10-14 8:10 Waiting Approval Planning 835551
REQ000000675376 30-10-14 0:16 Planning In Progress 139841
REQ000000679515 12-04-14 8:26 Completed Submitted 16160203
REQ000000679515 16-10-14 9:22 Submitted Waiting Approval 13
REQ000000679515 16-10-14 9:23 Waiting Approval Planning 1284
REQ000000679515 16-10-14 9:44 Planning In Progress 340504
REQ000000679515 20-10-14 8:19 In Progress Closed 5217063
REQ000000680751 11-03-14 23:11 In Progress Completed 35988
REQ000000680751 11-03-14 8:44 Planning In Progress 51976
REQ000000680751 12-03-14 9:10 Completed Submitted 18849001
REQ000000680751 16-10-14 13:00 Submitted Waiting Approval 11
REQ000000680751 16-10-14 13:01 Waiting Approval Closed 5459139
REQ000000680925 16-10-14 13:14 Submitted Waiting Approval 11
REQ000000680925 16-10-14 13:14 Waiting Approval Planning 7398
REQ000000680925 16-10-14 15:17 Planning Cancelled 3092703
REQ000000681285 12-02-14 10:09 Completed Submitted 21268605
REQ000000681285 16-10-14 14:06 Submitted Waiting Approval 13
REQ000000681285 16-10-14 14:06 Waiting Approval Planning 4280
REQ000000681285 16-10-14 15:17 Planning In Progress 85366
REQ000000681285 17-10-14 15:00 In Progress Closed 5278884
REQ000000681337 12-02-14 10:33 Completed Submitted 21267552
REQ000000681337 16-10-14 14:12 Submitted Waiting Approval 11
REQ000000681337 16-10-14 14:12 Waiting Approval Planning 56166
REQ000000681337 17-10-14 5:48 Planning In Progress 281941
REQ000000681337 20-10-14 12:07 In Progress Closed 5030064
REQ000000681424 11-03-14 8:44 Planning Completed 87896
REQ000000681424 11-04-14 15:34 In Progress Submitted 16239270
REQ000000681424 12-03-14 9:09 Completed In Progress 2615092
REQ000000681424 16-10-14 14:29 Submitted Waiting Approval 15
REQ000000681424 16-10-14 14:29 Waiting Approval Closed 5453830
REQ000000681656 12-03-14 8:36 Completed Submitted 18857004
REQ000000681656 16-10-14 14:39 Submitted Waiting Approval 12
REQ000000681656 16-10-14 14:40 Waiting Approval Planning 3853

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 3 3 194.1 582.2
Closed 11 11 130.5 1,435.0
Completed 36 36 194.2 6,991.3
Draft 10 10 1.4 14.4
In Progress 127 127 80.6 10,234.4
Pending 11 11 92.4 1,015.9
Planning 205 205 52.0 10,652.1
Rejected 7 7 0.0 0.1
Submitted 231 231 0.0 0.0
Waiting Approval 218 218 23.6 5,136.2

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Cancelled Planning 1 213.1 213.1
Submitted 2 184.5 369.0
Closed Completed 11 130.5 1,435.0
Completed Closed 5 110.1 550.7
In Progress 2 75.2 150.3
Planning 3 213.2 639.5
Submitted 26 217.3 5,650.8
Draft Submitted 10 1.4 14.4
In Progress Cancelled 3 15.7 47.1
Closed 32 93.6 2,993.7
Completed 9 66.1 594.6
Draft 1 156.2 156.2
In Progress 1 22.0 22.0
Pending 43 39.7 1,708.7
Planning 5 50.0 249.9
Submitted 33 135.2 4,462.2
Pending In Progress 7 20.2 141.5
Submitted 4 218.6 874.4
Planning Cancelled 2 80.0 159.9
Completed 3 32.0 96.1
In Progress 172 33.4 5,749.9
Pending 8 63.3 506.2
Submitted 20 207.0 4,140.0
Rejected Draft 7 0.0 0.1
Submitted Waiting Approval 231 0.0 0.0
Waiting Approval Closed 10 46.1 461.5
In Progress 23 33.1 761.5
Planning 180 21.7 3,913.1
Rejected 5 0.0 0.1