168 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.8% Cancelled 2.2% Closed 3.9% Completed 0.2% Draft 36.0% In Progress 3.9% Pending 24.4% Planning 6.4% Rejected 0.0% Submitted 21.3% 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 535

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
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
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
REQ000000625856 10-06-14 6:26 Submitted Waiting Approval 12
REQ000000625856 10-06-14 6:26 Waiting Approval Planning 5312203
REQ000000625856 10-08-14 18:03 Planning Pending 14300
REQ000000625856 10-08-14 22:01 Pending In Progress 5237022
REQ000000625856 10-10-14 12:45 In Progress Completed 15129033
REQ000000626847 10-06-14 8:27 Submitted Waiting Approval 17
REQ000000626847 10-06-14 8:27 Waiting Approval Planning 5304986
REQ000000626847 10-08-14 18:03 Planning Pending 14427
REQ000000626847 10-08-14 22:04 Pending In Progress 5236922
REQ000000626847 10-10-14 12:46 In Progress Completed 15129063
REQ000000632086 10-07-14 5:19 Draft Submitted 2683574
REQ000000632086 10-08-14 6:46 Submitted Waiting Approval 24
REQ000000632086 10-08-14 6:46 Waiting Approval Planning 6359252
REQ000000632086 11-04-14 10:36 In Progress Draft 7757009
REQ000000638173 10-08-14 21:01 Planning In Progress 6787986
REQ000000638173 10-08-14 5:40 Submitted Waiting Approval 9
REQ000000638173 10-08-14 5:40 Waiting Approval Planning 55285
REQ000000638176 10-08-14 21:01 Planning In Progress 6787565
REQ000000638176 10-08-14 5:42 Submitted Waiting Approval 8
REQ000000638176 10-08-14 5:42 Waiting Approval Planning 55153
REQ000000638283 10-08-14 21:00 Planning In Progress 6788944
REQ000000638283 10-08-14 5:36 Submitted Waiting Approval 11
REQ000000638283 10-08-14 5:36 Waiting Approval Planning 55448
REQ000000638477 10-08-14 21:02 Planning Pending 4001
REQ000000638477 10-08-14 22:09 Pending In Progress 6438880
REQ000000638477 10-08-14 6:47 Submitted Waiting Approval 11
REQ000000638477 10-08-14 6:47 Waiting Approval Planning 51308
REQ000000638483 10-08-14 6:50 Submitted Waiting Approval 13
REQ000000638483 10-08-14 6:51 Waiting Approval Planning 5296163
REQ000000638483 10-10-14 14:00 Planning Pending 263709
REQ000000638483 13-10-14 15:15 Pending In Progress 929924
REQ000000638490 10-08-14 6:54 Submitted Waiting Approval 8
REQ000000638490 10-08-14 6:55 Waiting Approval Planning 5295953
REQ000000638490 10-10-14 14:00 Planning Pending 263701
REQ000000638490 13-10-14 15:15 Pending In Progress 929743
REQ000000638571 10-08-14 21:02 Planning Pending 3672
REQ000000638571 10-08-14 22:03 Pending In Progress 6440912
REQ000000638571 10-08-14 6:44 Submitted Waiting Approval 12
REQ000000638571 10-08-14 6:45 Waiting Approval Planning 51429
REQ000000651212 10-10-14 6:47 Submitted Waiting Approval 17
REQ000000651212 10-10-14 6:47 Waiting Approval Rejected 646566
REQ000000652789 10-10-14 11:50 Submitted Waiting Approval 10
REQ000000652789 10-10-14 11:50 Waiting Approval Planning 16755
REQ000000652789 10-10-14 16:29 Planning Pending 254794
REQ000000652789 13-10-14 15:16 Pending In Progress 1275451
REQ000000652981 10-10-14 11:52 Submitted Waiting Approval 8
REQ000000652981 10-10-14 11:52 Waiting Approval Planning 16599
REQ000000652981 10-10-14 16:29 Planning Pending 254797
REQ000000652981 13-10-14 15:16 Pending In Progress 927867
REQ000000652981 24-10-14 9:00 In Progress Pending 546
REQ000000652981 24-10-14 9:09 Pending In Progress 346659
REQ000000653235 10-10-14 12:09 Submitted Waiting Approval 17
REQ000000653235 10-10-14 12:09 Waiting Approval Rejected 69
REQ000000687260 11-07-14 8:14 In Progress Submitted 8492157
REQ000000687260 17-10-14 15:10 Submitted Waiting Approval 26
REQ000000687260 17-10-14 15:10 Waiting Approval Planning 283708
REQ000000687260 20-10-14 21:59 Planning Completed 14240848
REQ000000687613 12-04-14 21:05 Completed Submitted 16224963
REQ000000687613 17-10-14 16:01 Submitted Waiting Approval 18
REQ000000687613 17-10-14 16:02 Waiting Approval Planning 280656
REQ000000687613 20-10-14 21:59 Planning In Progress 313841
REQ000000687613 24-10-14 13:10 In Progress Closed 4940666
REQ000000691928 20-10-14 6:44 Submitted Waiting Approval 20
REQ000000691928 20-10-14 6:45 Waiting Approval Rejected 6341
REQ000000691928 20-10-14 8:30 Rejected Cancelled 122
REQ000000692041 11-07-14 16:07 Completed Submitted 8694190
REQ000000692041 20-10-14 7:10 Submitted Waiting Approval 18
REQ000000692041 20-10-14 7:10 Waiting Approval Planning 81417
REQ000000692041 21-10-14 14:20 In Progress Closed 2796771
REQ000000692041 21-10-14 5:47 Planning In Progress 30769
REQ000000692055 11-07-14 16:06 Completed Submitted 8694523
REQ000000692055 20-10-14 7:15 Submitted Waiting Approval 23
REQ000000692055 20-10-14 7:15 Waiting Approval Planning 81207
REQ000000692055 21-10-14 14:20 In Progress Closed 2796786
REQ000000692055 21-10-14 5:49 Planning In Progress 30675
REQ000000692138 20-10-14 22:00 Planning In Progress 313307
REQ000000692138 20-10-14 7:09 Submitted Waiting Approval 16
REQ000000692138 20-10-14 7:09 Waiting Approval Planning 53417
REQ000000695867 11-03-14 10:15 In Progress Submitted 19282668
REQ000000695867 20-10-14 14:32 Submitted Waiting Approval 18
REQ000000695867 20-10-14 14:33 Waiting Approval Planning 3240
REQ000000695867 20-10-14 15:27 Planning Pending 5662
REQ000000695967 20-10-14 14:41 Submitted Waiting Approval 20
REQ000000695967 20-10-14 14:41 Waiting Approval Planning 90375
REQ000000695967 21-10-14 15:47 Planning Pending 10379
REQ000000695967 21-10-14 18:40 Pending In Progress 828641
REQ000000700209 21-10-14 11:45 Planning In Progress 248643
REQ000000700209 21-10-14 8:35 Submitted Waiting Approval 10

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 2 2 163.2 326.5
Closed 5 5 79.6 398.1
Completed 5 5 139.1 695.6
Draft 7 7 4.4 31.1
In Progress 59 59 109.7 6,471.8
Pending 20 20 34.8 696.9
Planning 103 103 42.6 4,390.5
Rejected 13 13 88.1 1,145.9
Submitted 173 173 0.0 2.1
Waiting Approval 148 148 26.0 3,842.1

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Cancelled Planning 1 161.6 161.6
Submitted 1 164.9 164.9
Closed Completed 3 10.6 31.7
Submitted 2 183.2 366.4
Completed Closed 1 18.9 18.9
Submitted 4 169.2 676.7
Draft Submitted 5 6.2 31.1
Waiting Approval 2 0.0 0.0
In Progress Cancelled 1 0.0 0.0
Closed 7 66.6 466.4
Completed 6 86.1 516.5
Draft 1 89.8 89.8
Pending 12 54.6 655.7
Planning 2 157.6 315.2
Submitted 30 147.6 4,428.2
Pending In Progress 19 29.6 562.1
Submitted 1 134.7 134.7
Planning Cancelled 1 34.5 34.5
Completed 1 164.8 164.8
In Progress 77 46.0 3,538.8
Pending 22 18.5 406.4
Submitted 2 123.0 246.0
Rejected Cancelled 1 0.0 0.0
Draft 7 0.2 1.7
Submitted 5 228.8 1,144.1
Submitted Planning 2 1.0 2.0
Waiting Approval 171 0.0 0.0
Waiting Approval Cancelled 9 49.7 447.5
In Progress 4 27.8 111.4
Planning 113 18.7 2,118.6
Rejected 22 52.9 1,164.6