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

18.6% Cancelled 11.0% Closed 46.1% Completed 0.0% Draft 14.0% In Progress 1.7% Planning 0.0% Rejected 0.0% Submitted 8.6% 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 62 out of 62

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
REQ000000726995 27-10-14 14:33 Submitted Waiting Approval 15
REQ000000726995 27-10-14 14:33 Waiting Approval Planning 258950
REQ000000726995 30-10-14 14:29 Planning In Progress 4509
REQ000000726995 30-10-14 15:44 In Progress Cancelled 1210699
REQ000000727080 12-03-14 8:33 Completed Submitted 19808549
REQ000000727080 27-10-14 14:56 Submitted Waiting Approval 9
REQ000000727080 27-10-14 14:56 Waiting Approval Planning 257814
REQ000000727080 30-10-14 14:33 Planning In Progress 8283
REQ000000727080 30-10-14 16:51 In Progress Closed 4235714
REQ000000727421 22-01-15 4:28 Closed Completed 11270209
REQ000000727421 27-10-14 14:47 Submitted Waiting Approval 16
REQ000000727421 27-10-14 14:47 Waiting Approval Planning 257792
REQ000000727421 30-10-14 14:23 Planning In Progress 6214
REQ000000727421 30-10-14 16:07 In Progress Closed 7215682
REQ000000727435 12-03-14 8:33 Completed Submitted 19808365
REQ000000727435 27-10-14 14:52 Submitted Waiting Approval 15
REQ000000727435 27-10-14 14:53 Waiting Approval Planning 257975
REQ000000727435 30-10-14 14:32 Planning In Progress 7798
REQ000000727435 30-10-14 16:42 In Progress Closed 4236236
REQ000000727509 12-03-14 11:01 Cancelled Submitted 19798919
REQ000000727509 27-10-14 14:43 Submitted Waiting Approval 14
REQ000000727509 27-10-14 14:43 Waiting Approval Planning 258373
REQ000000727509 30-10-14 14:29 Planning In Progress 3261
REQ000000740371 11-10-14 13:54 Planning In Progress 10051
REQ000000740371 11-10-14 16:41 In Progress Submitted 1544063
REQ000000740371 12-03-14 9:25 Completed Planning 18419349
REQ000000740371 29-10-14 13:36 Submitted Waiting Approval 15
REQ000000740371 29-10-14 13:36 Waiting Approval Closed 4333808
REQ000000740582 11-10-14 13:53 Planning In Progress 10397
REQ000000740582 11-10-14 16:46 In Progress Submitted 1543894
REQ000000740582 12-03-14 9:24 Completed Planning 18419313
REQ000000740582 29-10-14 13:38 Submitted Waiting Approval 16
REQ000000740582 29-10-14 13:38 Waiting Approval Closed 4333682
REQ000000740589 11-10-14 13:55 Planning Submitted 1554794
REQ000000740589 12-03-14 10:25 Cancelled Planning 18415812
REQ000000740589 29-10-14 13:48 Submitted Waiting Approval 13
REQ000000753494 11-10-14 13:49 Planning In Progress 12903
REQ000000753494 11-10-14 17:24 In Progress Submitted 1722836
REQ000000753494 12-03-14 9:44 Completed Planning 18417911
REQ000000753494 31-10-14 15:58 Submitted Waiting Approval 13
REQ000000753494 31-10-14 15:58 Waiting Approval Closed 4152466
REQ000000753592 11-10-14 13:52 Planning In Progress 10811
REQ000000753592 11-10-14 16:52 In Progress Submitted 1724617
REQ000000753592 31-10-14 15:56 Submitted Waiting Approval 15
REQ000000753722 11-10-14 13:51 Planning Submitted 1735153
REQ000000753722 20-11-14 9:15 In Progress Closed 5426014
REQ000000753722 22-01-15 4:28 Closed Completed 11270194
REQ000000753722 31-10-14 15:50 Submitted Waiting Approval 9
REQ000000753722 31-10-14 15:50 Waiting Approval In Progress 1704270
REQ000001074972 15-01-15 17:14 Submitted Waiting Approval 7
REQ000001074972 15-01-15 17:14 Waiting Approval Planning 924821
REQ000001074972 26-01-15 10:08 Planning In Progress 16474
REQ000001245020 18-02-15 13:42 Submitted Waiting Approval 7
REQ000001245020 18-02-15 13:43 Waiting Approval Rejected 181
REQ000001245020 18-02-15 13:46 Rejected Draft 36
REQ000001245020 18-02-15 13:46 Draft Submitted 58
REQ000001245020 18-02-15 13:47 Submitted Waiting Approval 1
REQ000001245020 18-02-15 13:47 Waiting Approval Planning 491621
REQ000001245020 24-02-15 6:21 Planning In Progress 11471
REQ000001245053 18-02-15 13:55 Submitted Waiting Approval 6
REQ000001245053 18-02-15 13:55 Waiting Approval Planning 491139
REQ000001245053 24-02-15 6:21 Planning In Progress 11461

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 2 2 221.2 442.3
Closed 2 2 130.4 260.9
Completed 5 5 219.6 1,098.1
Draft 1 1 0.0 0.0
In Progress 9 9 37.1 334.0
Planning 14 14 2.8 39.4
Rejected 1 1 0.0 0.0
Submitted 15 15 0.0 0.0
Waiting Approval 13 13 15.8 205.1

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Cancelled Planning 1 213.1 213.1
Submitted 1 229.2 229.2
Closed Completed 2 130.4 260.9
Completed Planning 3 213.2 639.5
Submitted 2 229.3 458.5
Draft Submitted 1 0.0 0.0
In Progress Cancelled 1 14.0 14.0
Closed 4 61.1 244.4
Submitted 4 18.9 75.6
Planning In Progress 12 0.1 1.3
Submitted 2 19.0 38.1
Rejected Draft 1 0.0 0.0
Submitted Waiting Approval 15 0.0 0.0
Waiting Approval Closed 3 49.5 148.4
In Progress 1 19.7 19.7
Planning 8 4.6 37.0
Rejected 1 0.0 0.0