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

16.9% Closed 28.2% Completed 46.5% In Progress 5.7% Planning 0.0% Submitted 2.7% 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 51 out of 51

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
REQ000000726504 11-03-14 9:42 Planning In Progress 2670157
REQ000000726504 11-04-14 7:25 In Progress Submitted 17214108
REQ000000726504 27-10-14 13:06 Submitted Waiting Approval 19
REQ000000858668 12-05-14 13:16 Completed Submitted 16923235
REQ000000858668 24-11-14 10:10 Submitted Waiting Approval 14
REQ000000858668 24-11-14 10:10 Waiting Approval Planning 1257
REQ000000858668 24-11-14 10:31 Planning In Progress 6728
REQ000000858668 24-11-14 12:23 In Progress Closed 2265039
REQ000000876005 12-01-14 12:57 Planning In Progress 12854
REQ000000876005 12-01-14 16:31 In Progress Completed 7768583
REQ000000876005 12-04-14 14:27 Completed Submitted 19710089
REQ000000876005 26-11-14 17:29 Submitted Waiting Approval 13
REQ000000876005 26-11-14 17:29 Waiting Approval Closed 1987234
REQ000000876014 12-01-14 12:57 Planning In Progress 13681
REQ000000876014 12-01-14 16:45 In Progress Completed 7767929
REQ000000876014 12-04-14 14:30 Completed Submitted 19710994
REQ000000876014 26-11-14 17:47 Submitted Waiting Approval 10
REQ000000876014 26-11-14 17:47 Waiting Approval Closed 1986145
REQ000000918482 12-05-14 14:07 Planning In Progress 6766
REQ000000918482 12-05-14 16:00 In Progress Closed 21990502
REQ000000918482 12-05-14 9:29 Submitted Waiting Approval 20
REQ000000918482 12-05-14 9:29 Waiting Approval Planning 16665
REQ000000918482 22-01-15 4:28 Closed Completed 11270661
REQ000000919144 12-05-14 10:47 Submitted Waiting Approval 13
REQ000000919144 12-05-14 10:47 Waiting Approval Planning 11964
REQ000000919144 12-05-14 14:06 Planning In Progress 8336
REQ000000919144 12-05-14 16:25 In Progress Closed 21988967
REQ000000919144 22-01-15 4:28 Closed Completed 11270817
REQ000000919560 12-05-14 13:07 Submitted Waiting Approval 14
REQ000000919560 12-05-14 13:07 Waiting Approval Planning 3555
REQ000000919560 12-05-14 14:07 Planning In Progress 7932999
REQ000000919560 12-08-14 9:43 In Progress Closed 14064292
REQ000000919560 22-01-15 4:28 Closed Completed 11271068
REQ000001109663 22-01-15 12:36 Submitted Waiting Approval 6
REQ000001109663 22-01-15 12:36 Waiting Approval Planning 5971
REQ000001109663 22-01-15 14:15 Planning In Progress 63251
REQ000001110043 22-01-15 12:41 Submitted Waiting Approval 6
REQ000001110043 22-01-15 12:41 Waiting Approval Planning 5658
REQ000001110043 22-01-15 14:16 Planning In Progress 63455
REQ000001111611 22-01-15 15:02 Submitted Waiting Approval 8
REQ000001111611 22-01-15 15:03 Waiting Approval Planning 517199
REQ000001111611 28-01-15 14:43 Planning In Progress 70660
REQ000001199735 02-10-15 13:13 Planning In Progress 4303
REQ000001199735 02-10-15 7:41 Submitted Waiting Approval 9
REQ000001199735 02-10-15 7:41 Waiting Approval Planning 19902
REQ000001246976 18-02-15 19:10 Submitted Waiting Approval 7
REQ000001246976 18-02-15 19:11 Waiting Approval Planning 420360
REQ000001246976 23-02-15 15:57 Planning In Progress 258252
REQ000001246982 18-02-15 19:19 Submitted Waiting Approval 4
REQ000001246982 18-02-15 19:19 Waiting Approval Planning 419845
REQ000001246982 23-02-15 15:57 Planning In Progress 257853

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
Closed 3 3 130.4 391.3
Completed 3 3 217.4 652.1
In Progress 7 7 153.9 1,077.1
Planning 13 13 10.1 131.6
Submitted 13 13 0.0 0.0
Waiting Approval 12 12 5.2 62.5

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Closed Completed 3 130.4 391.3
Completed Submitted 3 217.4 652.1
In Progress Closed 4 174.5 698.0
Completed 2 89.9 179.8
Submitted 1 199.2 199.2
Planning In Progress 13 10.1 131.6
Submitted Waiting Approval 13 0.0 0.0
Waiting Approval Closed 2 23.0 46.0
Planning 10 1.6 16.5