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

5.7% Closed 0.0% Draft 25.3% In Progress 0.0% Pending 35.8% Planning 4.9% Rejected 0.0% Submitted 28.3% 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 57 out of 57

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
REQ000000968236 01-04-15 19:24 Planning Pending 2543843
REQ000000968236 01-05-15 6:01 Pending In Progress 7399
REQ000000968236 16-12-14 15:20 Submitted Waiting Approval 5
REQ000000968236 16-12-14 15:20 Waiting Approval Planning 9173043
REQ000000979269 18-12-14 14:24 Submitted Waiting Approval 7
REQ000000979269 18-12-14 14:24 Waiting Approval Planning 81818
REQ000000979269 19-12-14 13:08 Planning In Progress 9012
REQ000001058063 13-01-15 10:05 Submitted Waiting Approval 3
REQ000001058063 13-01-15 10:05 Waiting Approval Planning 80995
REQ000001058063 14-01-15 8:35 Planning In Progress 169250
REQ000001079891 16-01-15 13:34 Submitted Waiting Approval 4
REQ000001079891 16-01-15 13:34 Waiting Approval Planning 9878
REQ000001079891 16-01-15 16:18 Planning In Progress 236065
REQ000001079909 16-01-15 13:19 Submitted Waiting Approval 9
REQ000001079909 16-01-15 13:20 Waiting Approval Planning 10722
REQ000001079909 16-01-15 16:18 Planning In Progress 234435
REQ000001087738 19-01-15 13:01 Submitted Waiting Approval 4
REQ000001087738 19-01-15 13:01 Waiting Approval Rejected 2693
REQ000001087738 19-01-15 13:46 Rejected Draft 1543
REQ000001087738 19-01-15 14:12 Draft Submitted 111
REQ000001087738 19-01-15 14:14 Submitted Waiting Approval 1
REQ000001087738 19-01-15 14:14 Waiting Approval Planning 757
REQ000001087738 19-01-15 14:26 Planning In Progress 88304
REQ000001133897 02-02-15 15:07 Planning In Progress 5097261
REQ000001133897 27-01-15 21:14 Submitted Waiting Approval 4
REQ000001133897 27-01-15 21:14 Waiting Approval Planning 496370
REQ000001133940 27-01-15 19:14 Submitted Waiting Approval 11
REQ000001133940 27-01-15 19:15 Waiting Approval Planning 54979
REQ000001133940 28-01-15 10:31 Planning Pending 17857
REQ000001133940 28-01-15 15:29 Pending In Progress 1547
REQ000001134072 02-02-15 15:07 Planning In Progress 5097683
REQ000001134072 27-01-15 21:12 Submitted Waiting Approval 4
REQ000001134072 27-01-15 21:12 Waiting Approval Planning 496533
REQ000001134303 02-02-15 15:08 Planning In Progress 5098431
REQ000001134303 27-01-15 21:02 Submitted Waiting Approval 7
REQ000001134303 27-01-15 21:02 Waiting Approval Planning 497157
REQ000001174146 02-04-15 14:57 Submitted Waiting Approval 14
REQ000001174146 02-04-15 14:57 Waiting Approval Rejected 2715
REQ000001174146 02-04-15 15:43 Rejected Draft 2557363
REQ000001174146 02-05-15 6:05 Draft Submitted 195
REQ000001174146 02-05-15 6:09 Submitted Waiting Approval 1
REQ000001174146 02-05-15 6:09 Waiting Approval Planning 2688146
REQ000001174146 02-06-15 10:05 In Progress Completed 13218601
REQ000001174146 02-06-15 8:51 Planning In Progress 4453
REQ000001174146 27-02-15 1:48 Closed Submitted 2984972
REQ000001244490 18-02-15 13:42 Submitted Waiting Approval 7
REQ000001244490 18-02-15 13:42 Waiting Approval Planning 594327
REQ000001244490 25-02-15 10:48 Planning In Progress 22002
REQ000001244836 18-02-15 13:32 Submitted Waiting Approval 9
REQ000001244836 18-02-15 13:32 Waiting Approval Planning 594961
REQ000001244836 25-02-15 10:48 Planning In Progress 21071
REQ000001264583 23-02-15 15:37 Submitted Waiting Approval 7
REQ000001264583 23-02-15 15:37 Waiting Approval Planning 1573
REQ000001264583 23-02-15 16:03 Planning In Progress 4838
REQ000001270613 24-02-15 13:30 Submitted Waiting Approval 7
REQ000001270613 24-02-15 13:30 Waiting Approval Planning 10969
REQ000001270613 24-02-15 16:33 Planning In Progress 65327

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 1 1 34.5 34.5
Draft 2 2 0.0 0.0
In Progress 1 1 153.0 153.0
Pending 2 2 0.1 0.1
Planning 15 15 14.4 216.5
Rejected 2 2 14.8 29.6
Submitted 17 17 0.0 0.0
Waiting Approval 17 17 10.1 171.3

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Closed Submitted 1 34.5 34.5
Draft Submitted 2 0.0 0.0
In Progress Completed 1 153.0 153.0
Pending In Progress 2 0.1 0.1
Planning In Progress 13 14.4 186.9
Pending 2 14.8 29.6
Rejected Draft 2 14.8 29.6
Submitted Waiting Approval 17 0.0 0.0
Waiting Approval Planning 15 11.4 171.2
Rejected 2 0.0 0.1