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

10.9% Cancelled 1.4% Closed 2.2% Completed 3.5% Draft 17.7% In Progress 0.2% Pending 19.5% Planning 11.9% Rejected 0.6% Submitted 32.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 296

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
REQ000000625465 10-06-14 6:28 Submitted Waiting Approval 6
REQ000000625465 10-06-14 6:28 Waiting Approval Rejected 172
REQ000000625465 10-06-14 6:31 Rejected Draft 70
REQ000000625465 10-06-14 6:32 Draft Cancelled 2681709
REQ000000661075 13-10-14 13:02 Submitted Waiting Approval 7
REQ000000661075 13-10-14 13:02 Waiting Approval Planning 691438
REQ000000661075 21-10-14 13:06 Planning In Progress 527539
REQ000000661436 13-10-14 13:09 Submitted Waiting Approval 20
REQ000000661436 13-10-14 13:09 Waiting Approval Planning 691029
REQ000000661436 21-10-14 13:07 Planning In Progress 523971
REQ000000665365 14-10-14 7:39 Draft Submitted 277592
REQ000000665365 17-10-14 12:46 Submitted Waiting Approval 24
REQ000000665365 17-10-14 12:46 Waiting Approval Rejected 3836
REQ000000740246 20-11-14 13:35 Planning In Progress 602498
REQ000000740246 29-10-14 12:45 Submitted Waiting Approval 9
REQ000000740246 29-10-14 12:45 Waiting Approval Planning 1903765
REQ000000740252 11-11-14 15:51 Planning In Progress 2581465
REQ000000740252 29-10-14 12:48 Submitted Waiting Approval 14
REQ000000740252 29-10-14 12:48 Waiting Approval Planning 1134140
REQ000000747243 11-06-14 13:05 In Progress Submitted 12187530
REQ000000747243 30-10-14 14:31 Submitted Waiting Approval 15
REQ000000747243 30-10-14 14:31 Waiting Approval Planning 72133
REQ000000747349 11-06-14 13:09 In Progress Submitted 12187151
REQ000000747349 30-10-14 14:28 Submitted Waiting Approval 12
REQ000000747349 30-10-14 14:28 Waiting Approval Planning 72304
REQ000000768161 11-04-14 16:23 Submitted Waiting Approval 28
REQ000000768161 11-04-14 16:23 Waiting Approval Planning 19092732
REQ000000768161 18-11-14 15:56 Planning Cancelled 686184
REQ000000771086 11-05-14 15:39 Planning In Progress 2679528
REQ000000771086 11-05-14 8:04 Submitted Waiting Approval 9
REQ000000771086 11-05-14 8:04 Waiting Approval Planning 27293
REQ000000771477 11-05-14 9:05 Submitted Waiting Approval 15
REQ000000771477 11-05-14 9:05 Waiting Approval Planning 15915766
REQ000000771477 11-11-14 14:08 Planning In Progress 157823
REQ000000771699 11-05-14 9:22 Submitted Waiting Approval 12
REQ000000771699 11-05-14 9:22 Waiting Approval Planning 17017471
REQ000000771699 24-11-14 8:27 Planning In Progress 101336
REQ000000771837 11-05-14 9:27 Submitted Waiting Approval 11
REQ000000771837 11-05-14 9:27 Waiting Approval Planning 2685594
REQ000000771837 11-06-14 11:27 Planning In Progress 10547325
REQ000000771843 11-05-14 9:29 Submitted Waiting Approval 14
REQ000000771843 11-05-14 9:29 Waiting Approval Planning 2668773
REQ000000771843 11-06-14 6:49 Planning In Progress 13245776
REQ000000771848 11-05-14 9:31 Submitted Waiting Approval 15
REQ000000771848 11-05-14 9:32 Waiting Approval Planning 2668349
REQ000000771848 11-06-14 6:44 Planning In Progress 10565664
REQ000000783673 11-07-14 7:34 Submitted Waiting Approval 11
REQ000000783673 11-07-14 7:34 Waiting Approval Planning 10894047
REQ000000783673 14-11-14 9:41 Planning Cancelled 359253
REQ000000783846 11-07-14 7:43 Submitted Waiting Approval 9
REQ000000783846 11-07-14 7:43 Waiting Approval Planning 10893542
REQ000000783846 14-11-14 9:42 Planning In Progress 1057020
REQ000000783878 11-07-14 8:18 Submitted Waiting Approval 10
REQ000000783878 11-07-14 8:18 Waiting Approval Planning 10891462
REQ000000783878 12-01-14 9:28 Cancelled Submitted 15547841
REQ000000783878 14-11-14 9:43 Planning In Progress 1121120
REQ000000783880 11-07-14 8:22 Submitted Waiting Approval 8
REQ000000783880 11-07-14 8:22 Waiting Approval Planning 10891183
REQ000000783880 12-01-14 9:28 Cancelled Submitted 15548045
REQ000000783880 14-11-14 9:42 Planning In Progress 1057709
REQ000000784011 11-07-14 8:06 Submitted Waiting Approval 10
REQ000000784011 11-07-14 8:06 Waiting Approval Planning 10892119
REQ000000784011 14-11-14 9:42 Planning In Progress 359323
REQ000000784174 11-07-14 9:07 Submitted Waiting Approval 16
REQ000000784174 11-07-14 9:08 Waiting Approval Rejected 10637513
REQ000000784214 11-07-14 8:12 Submitted Waiting Approval 14
REQ000000784214 11-07-14 8:13 Waiting Approval Planning 10891787
REQ000000784214 12-01-14 9:28 Cancelled Submitted 15547435
REQ000000784214 14-11-14 9:42 Planning In Progress 1112483
REQ000000784219 11-07-14 8:16 Submitted Waiting Approval 12
REQ000000784219 11-07-14 8:16 Waiting Approval Planning 10891598
REQ000000784219 12-01-14 9:29 Cancelled Submitted 15547622
REQ000000784219 14-11-14 9:42 Planning In Progress 1117778
REQ000000784279 11-07-14 9:11 Submitted Waiting Approval 13
REQ000000784279 11-07-14 9:12 Waiting Approval Planning 10637309
REQ000000784279 11-11-14 12:00 Planning Cancelled 782258
REQ000000784294 11-07-14 9:17 Submitted Waiting Approval 11
REQ000000784294 11-07-14 9:17 Waiting Approval Planning 10641404
REQ000000784294 11-11-14 13:14 Planning In Progress 155204
REQ000000784376 11-07-14 9:43 Submitted Waiting Approval 13
REQ000000784376 11-07-14 9:43 Waiting Approval Planning 10646651
REQ000000784376 11-11-14 15:07 Planning In Progress 154659
REQ000000784389 11-07-14 9:49 Submitted Waiting Approval 13
REQ000000784389 11-07-14 9:49 Waiting Approval Planning 10629466
REQ000000784389 11-11-14 10:27 Planning In Progress 612830
REQ000000784441 11-07-14 9:04 Submitted Waiting Approval 14
REQ000000784441 11-07-14 9:04 Waiting Approval Planning 10637661
REQ000000784441 11-11-14 11:58 Planning In Progress 160169
REQ000000784441 13-11-14 12:39 Pending Cancelled 609187
REQ000000784441 13-11-14 8:28 In Progress Pending 15112
REQ000000784803 11-07-14 9:27 Submitted Waiting Approval 10
REQ000000784803 11-07-14 9:27 Waiting Approval Planning 10647319
REQ000000784803 11-11-14 15:02 Planning In Progress 154778
REQ000000784807 11-07-14 9:30 Submitted Waiting Approval 15
REQ000000784807 11-07-14 9:30 Waiting Approval Planning 10647518
REQ000000784807 11-11-14 15:08 Planning In Progress 155113
REQ000000784807 13-11-14 10:14 In Progress Completed 5363159
REQ000000784807 14-01-15 12:00 Completed Closed 1336077
REQ000000784833 11-07-14 9:52 Submitted Waiting Approval 15
REQ000000784833 11-07-14 9:52 Waiting Approval Planning 10659034

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 211.1 1,266.8
Closed 1 1 159.2 159.2
Completed 3 3 83.7 251.2
Draft 14 14 29.5 413.6
In Progress 15 15 137.7 2,065.7
Pending 4 4 6.1 24.3
Planning 63 63 36.2 2,278.1
Rejected 16 16 86.6 1,386.3
Submitted 95 95 0.7 67.0
Waiting Approval 79 79 47.4 3,745.7

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Cancelled Draft 1 259.0 259.0
Submitted 5 201.6 1,007.8
Closed Completed 1 159.2 159.2
Completed Closed 1 15.5 15.5
Planning 2 117.9 235.7
Draft Cancelled 2 15.5 31.0
Completed 1 90.2 90.2
Submitted 10 29.2 292.4
Waiting Approval 1 0.0 0.0
In Progress Closed 1 56.7 56.7
Completed 2 38.0 75.9
Draft 1 259.0 259.0
Pending 3 11.4 34.3
Submitted 8 205.0 1,639.7
Pending Cancelled 1 7.1 7.1
In Progress 3 5.7 17.2
Planning Cancelled 4 5.3 21.2
In Progress 56 40.1 2,244.1
Pending 3 4.3 12.8
Rejected Draft 10 1.5 14.5
Submitted 6 228.6 1,371.7
Submitted Completed 1 67.0 67.0
Waiting Approval 94 0.0 0.0
Waiting Approval Cancelled 3 34.4 103.3
In Progress 1 53.2 53.2
Planning 62 55.5 3,443.0
Rejected 13 11.2 146.2