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

2.5% Cancelled 10.7% Closed 14.2% Completed 1.4% Draft 33.1% In Progress 1.1% Pending 8.3% Planning 0.5% Rejected 0.0% Submitted 28.1% 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 587

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
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
REQ000000663527 12-10-14 16:59 Cancelled Submitted 94079
REQ000000663527 13-10-14 19:07 Submitted Waiting Approval 7
REQ000000749306 11-04-14 17:21 Rejected Draft 209
REQ000000749306 11-04-14 17:25 Draft Submitted 67
REQ000000749306 11-04-14 17:26 Submitted Waiting Approval 1
REQ000000749306 11-04-14 17:26 Waiting Approval Planning 6429
REQ000000749306 11-04-14 19:13 Planning In Progress 4924
REQ000000749306 11-04-14 20:35 In Progress Submitted 17454751
REQ000000749306 12-03-14 9:41 Completed Rejected 2619624
REQ000000749306 30-10-14 21:08 Submitted Waiting Approval 14
REQ000000749306 30-10-14 21:08 Waiting Approval Closed 4220289
REQ000000753405 11-03-14 12:13 Planning In Progress 42249
REQ000000753405 11-03-14 23:57 In Progress Completed 32254
REQ000000753405 12-03-14 8:55 Completed Submitted 20153535
REQ000000753405 31-10-14 15:07 Submitted Waiting Approval 15
REQ000000753405 31-10-14 15:07 Waiting Approval Closed 4155541
REQ000000761598 11-03-14 18:38 Submitted Waiting Approval 9
REQ000000761598 11-03-14 18:38 Waiting Approval Planning 5258948
REQ000000761598 11-05-14 15:27 Planning Cancelled 2641
REQ000000761773 11-03-14 17:10 Submitted Waiting Approval 12
REQ000000761773 11-03-14 17:10 Waiting Approval Rejected 12846
REQ000000761773 11-03-14 20:44 Rejected Draft 930
REQ000000761773 11-03-14 20:59 Draft Cancelled 1135
REQ000000762055 11-03-14 17:02 Submitted Waiting Approval 11
REQ000000762055 11-03-14 17:02 Waiting Approval Planning 16122
REQ000000762055 11-03-14 21:30 Planning In Progress 18448445
REQ000000762055 11-10-14 10:05 In Progress Completed 2771166
REQ000000762055 12-11-14 11:51 Completed Closed 3823213
REQ000000763017 11-03-14 21:34 Submitted Waiting Approval 9
REQ000000763017 11-03-14 21:35 Waiting Approval Planning 862
REQ000000763017 11-03-14 21:49 Planning Cancelled 2749408
REQ000000782454 11-06-14 23:07 Submitted Waiting Approval 24
REQ000000782454 11-06-14 23:08 Waiting Approval Planning 13893876
REQ000000782454 12-02-14 22:41 In Progress Submitted 10283193
REQ000000782454 19-11-14 18:32 Planning Cancelled 2514399
REQ000000782563 11-06-14 23:16 Submitted Waiting Approval 22
REQ000000782563 11-06-14 23:17 Waiting Approval Planning 13893211
REQ000000782563 12-03-14 17:45 In Progress Submitted 7882284
REQ000000782563 19-11-14 18:30 Planning Cancelled 2514554
REQ000000782605 11-06-14 21:04 Submitted Waiting Approval 14
REQ000000782605 11-06-14 21:04 Waiting Approval Planning 1085
REQ000000782605 11-06-14 21:22 Planning In Progress 766
REQ000000782605 11-06-14 21:35 In Progress Closed 16401058
REQ000000782605 12-03-14 9:57 Completed Submitted 7902394
REQ000000782717 11-06-14 22:38 Draft Cancelled 15869736
REQ000000787237 11-07-14 17:18 Draft Cancelled 11225797
REQ000000787264 11-07-14 18:19 Submitted Waiting Approval 13
REQ000000787264 11-07-14 18:19 Waiting Approval Planning 10591964
REQ000000787264 11-11-14 16:39 In Progress Closed 3199603
REQ000000787264 11-11-14 8:32 Planning In Progress 29233
REQ000000787264 12-03-14 10:33 Completed Submitted 10482394
REQ000000787688 11-07-14 21:22 Submitted Waiting Approval 8
REQ000000787688 11-07-14 21:22 Waiting Approval Planning 10587355
REQ000000787688 11-11-14 10:18 Planning In Progress 35740
REQ000000787688 11-11-14 20:14 In Progress Closed 3186735
REQ000000787688 12-03-14 10:33 Completed Submitted 10493351
REQ000000787953 11-07-14 21:46 Draft Cancelled 871
REQ000000794581 11-10-14 16:54 Submitted Waiting Approval 12
REQ000000794581 11-10-14 16:54 Waiting Approval Rejected 546
REQ000000794581 11-10-14 17:03 Rejected Draft 1065
REQ000000794581 11-10-14 17:21 Draft Submitted 2934167
REQ000000794581 14-11-14 16:24 Submitted Waiting Approval 2
REQ000000794581 14-11-14 16:24 Waiting Approval Rejected 14509023
REQ000000795181 11-10-14 18:28 Submitted Waiting Approval 17
REQ000000795181 11-10-14 18:28 Waiting Approval Planning 2649644
REQ000000795181 11-11-14 10:29 Planning In Progress 1156750
REQ000000795181 12-03-14 21:27 Completed Submitted 18392441
REQ000000795181 24-11-14 19:48 In Progress Closed 2151744
REQ000000801251 11-11-14 16:56 Planning In Progress 1
REQ000000801251 11-11-14 16:56 In Progress Completed 16283
REQ000000801251 11-11-14 21:28 Completed Closed 1312542
REQ000000801667 11-11-14 19:13 Planning In Progress 1
REQ000000801667 11-11-14 19:13 In Progress Completed 10217
REQ000000801667 11-11-14 22:03 Completed Closed 1310335
REQ000000801693 11-11-14 20:19 Planning In Progress 29
REQ000000801693 11-11-14 20:19 In Progress Completed 5587
REQ000000801693 11-11-14 21:52 Completed Closed 1310912
REQ000000802258 11-11-14 22:43 Planning Closed 1395045
REQ000000802258 28-11-14 2:14 Closed Completed 1176767
REQ000000807679 11-12-14 17:02 Submitted Waiting Approval 11
REQ000000807679 18-11-14 15:33 Rejected Submitted 1992581
REQ000000808123 11-12-14 18:17 Submitted Waiting Approval 13
REQ000000808123 11-12-14 18:17 Waiting Approval Closed 3579053
REQ000000808123 13-11-14 15:38 Rejected Draft 166
REQ000000808123 13-11-14 15:40 Draft Submitted 149
REQ000000808123 13-11-14 15:43 Submitted Waiting Approval 1
REQ000000808123 13-11-14 15:43 Waiting Approval Planning 534847
REQ000000808123 19-11-14 20:17 Planning In Progress 76540
REQ000000808123 20-11-14 17:33 In Progress Submitted 1817065
REQ000000808123 22-01-15 4:28 Closed Completed 11270531
REQ000000808290 11-12-14 19:30 Planning In Progress 1
REQ000000808290 11-12-14 19:30 In Progress Completed 10940
REQ000000808290 28-11-14 2:01 Closed Planning 1186118
REQ000000808341 11-12-14 18:26 Submitted Waiting Approval 8
REQ000000808341 11-12-14 18:26 Waiting Approval Closed 3578515

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 101.2 607.3
Closed 26 26 99.9 2,598.0
Completed 31 31 110.6 3,429.8
Draft 23 23 15.2 349.0
In Progress 74 74 108.2 8,010.5
Pending 3 3 91.1 273.3
Planning 136 136 14.8 2,006.9
Rejected 17 17 7.6 129.7
Submitted 144 144 0.0 5.2
Waiting Approval 127 127 53.6 6,812.3

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Cancelled Planning 3 61.7 185.1
Submitted 3 140.7 422.2
Closed Completed 11 89.9 988.9
In Progress 2 80.0 160.1
Planning 13 111.5 1,449.1
Completed Closed 8 52.2 417.3
In Progress 3 40.0 120.1
Planning 4 57.8 231.3
Rejected 1 30.3 30.3
Submitted 15 175.4 2,630.9
Draft Cancelled 6 52.3 313.6
Submitted 16 2.2 35.4
Waiting Approval 1 0.0 0.0
In Progress Cancelled 5 53.1 265.3
Closed 21 74.2 1,558.2
Completed 23 38.8 893.1
Draft 1 195.8 195.8
Pending 1 0.0 0.0
Planning 1 94.7 94.7
Submitted 22 227.4 5,003.3
Pending Closed 1 30.9 30.9
Completed 1 241.7 241.7
In Progress 1 0.7 0.7
Planning Cancelled 7 36.1 253.0
Closed 3 47.6 142.8
Completed 2 31.4 62.8
In Progress 121 11.2 1,351.7
Pending 2 0.0 0.0
Submitted 1 196.5 196.5
Rejected Draft 15 0.0 0.3
Submitted 2 64.7 129.3
Submitted Planning 1 5.2 5.2
Waiting Approval 143 0.0 0.0
Waiting Approval Cancelled 9 34.0 306.0
Closed 7 35.2 246.1
Completed 4 19.0 75.8
Planning 90 62.0 5,581.4
Rejected 16 36.6 585.8
Submitted 1 17.3 17.3