176 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.4% Cancelled 10.1% Closed 14.5% Completed 1.4% Draft 32.1% In Progress 1.1% Pending 8.5% Planning 0.5% Rejected 0.0% Submitted 29.4% 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 671

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
REQ000000708015 22-10-14 12:49 Planning Cancelled 84015
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

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 27 27 96.6 2,608.0
Completed 34 34 110.3 3,749.2
Draft 28 28 12.5 349.3
In Progress 77 77 107.4 8,270.4
Pending 3 3 91.1 273.3
Planning 157 157 14.0 2,200.4
Rejected 25 25 5.2 130.1
Submitted 166 166 0.0 5.5
Waiting Approval 148 148 51.2 7,580.5

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 12 83.2 998.9
In Progress 2 80.0 160.1
Planning 13 111.5 1,449.1
Completed Closed 10 53.5 535.5
In Progress 3 40.0 120.1
Planning 4 57.8 231.3
Rejected 1 30.3 30.3
Submitted 16 177.0 2,832.1
Draft Cancelled 6 52.3 313.6
Submitted 20 1.8 35.7
Waiting Approval 2 0.0 0.0
In Progress Cancelled 5 53.1 265.3
Closed 21 74.2 1,558.2
Completed 25 35.8 895.9
Draft 1 195.8 195.8
Pending 1 0.0 0.0
Planning 1 94.7 94.7
Submitted 23 228.7 5,260.4
Pending Closed 1 30.9 30.9
Completed 1 241.7 241.7
In Progress 1 0.7 0.7
Planning Cancelled 12 23.3 279.8
Closed 3 47.6 142.8
Completed 2 31.4 62.8
In Progress 137 11.1 1,518.4
Pending 2 0.0 0.0
Submitted 1 196.5 196.5
Rejected Draft 23 0.0 0.8
Submitted 2 64.7 129.3
Submitted Planning 2 2.7 5.4
Waiting Approval 164 0.0 0.0
Waiting Approval Cancelled 6 51.0 305.9
Closed 7 35.2 246.1
Completed 4 19.0 75.8
Planning 108 58.4 6,311.1
Rejected 23 27.9 641.5