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.

19.6% Cancelled 19.5% Draft 1.8% In Progress 41.4% Planning 0.6% Rejected 0.0% Submitted 17.1% Waiting Approval

Cause of delay This visual uses TopCause: 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 46 out of 46

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
REQ000001010989 01-02-15 13:13 Submitted Waiting Approval 10
REQ000001010989 13-01-15 17:08 Planning In Progress 503094
REQ000001010989 19-01-15 12:53 In Progress Submitted 1124386
REQ000001011604 01-02-15 13:18 Submitted Waiting Approval 11
REQ000001011604 13-01-15 16:54 Planning In Progress 503735
REQ000001011604 19-01-15 12:49 In Progress Submitted 1124903
REQ000001152668 02-04-15 15:45 Planning In Progress 18470345
REQ000001152668 30-01-15 16:20 Submitted Waiting Approval 7
REQ000001152668 30-01-15 16:20 Waiting Approval Planning 5354691
REQ000001216560 02-12-15 14:01 Submitted Waiting Approval 14
REQ000001216560 13-02-15 8:09 Rejected Draft 368303
REQ000001216560 17-02-15 14:27 Draft Cancelled 270
REQ000001216560 17-02-15 14:32 Cancelled Submitted 24881341
REQ000001216725 02-12-15 13:47 Submitted Waiting Approval 7
REQ000001216725 13-02-15 8:09 Rejected Draft 368196
REQ000001216725 17-02-15 14:25 Draft Submitted 100
REQ000001216725 17-02-15 14:27 Submitted Waiting Approval 1
REQ000001216725 17-02-15 14:27 Waiting Approval Rejected 327
REQ000001216725 17-02-15 14:32 Rejected Draft 68886
REQ000001216725 18-02-15 9:40 Draft Submitted 24811574
REQ000001220293 13-02-15 7:24 Submitted Waiting Approval 8
REQ000001220293 13-02-15 7:24 Waiting Approval Planning 923447
REQ000001220293 23-02-15 23:55 Planning In Progress 125388
REQ000001231710 16-02-15 13:33 Submitted Waiting Approval 6
REQ000001231710 16-02-15 13:33 Waiting Approval Planning 100430
REQ000001231710 17-02-15 17:27 Planning In Progress 165364
REQ000001267884 03-05-15 7:26 Draft Submitted 20
REQ000001267884 03-05-15 7:27 Submitted Waiting Approval 1
REQ000001267884 03-05-15 7:27 Waiting Approval Rejected 1
REQ000001267884 24-02-15 8:22 Submitted Rejected 6
REQ000001267884 24-02-15 8:22 Rejected Waiting Approval 1
REQ000001267884 24-02-15 8:22 Waiting Approval Draft 5871849
REQ000001272048 24-02-15 16:23 Submitted Waiting Approval 9
REQ000001272048 24-02-15 16:23 Waiting Approval Planning 90842
REQ000001272048 25-02-15 17:37 Planning In Progress 3187852
REQ000001272231 24-02-15 16:27 Submitted Waiting Approval 13
REQ000001272231 24-02-15 16:27 Waiting Approval Planning 90389
REQ000001272231 25-02-15 17:34 Planning In Progress 3191340
REQ000001289823 03-04-15 23:59 Planning In Progress 13179612
REQ000001289823 27-02-15 7:32 Submitted Waiting Approval 15
REQ000001289823 27-02-15 7:32 Waiting Approval Planning 3083178
REQ000001289838 27-02-15 7:38 Submitted Waiting Approval 10
REQ000001289838 27-02-15 7:38 Waiting Approval Planning 3082791
REQ000001290002 03-04-15 23:58 Planning In Progress 13179816
REQ000001290002 27-02-15 7:36 Submitted Waiting Approval 14
REQ000001290002 27-02-15 7:36 Waiting Approval Planning 3082956

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 1 1 288.0 288.0
Draft 4 4 71.8 287.2
In Progress 2 2 13.0 26.0
Planning 9 9 67.5 607.7
Rejected 4 4 2.3 9.3
Submitted 15 15 0.0 0.0
Waiting Approval 11 11 22.8 250.9

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Cancelled Submitted 1 288.0 288.0
Draft Cancelled 1 0.0 0.0
Submitted 3 95.7 287.2
In Progress Submitted 2 13.0 26.0
Planning In Progress 9 67.5 607.7
Rejected Draft 3 3.1 9.3
Waiting Approval 1 0.0 0.0
Submitted Rejected 1 0.0 0.0
Waiting Approval 14 0.0 0.0
Waiting Approval Draft 1 68.0 68.0
Planning 8 22.9 183.0
Rejected 2 0.0 0.0