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.

25.7% Completed 40.6% In Progress 31.2% Planning 0.0% Submitted 2.5% 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 59 out of 59

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
REQ000000617398 10-02-14 13:44 Submitted Waiting Approval 11
REQ000000617398 10-02-14 13:44 Waiting Approval Planning 6032
REQ000000617398 10-02-14 15:25 Planning In Progress 2413006
REQ000000617406 10-02-14 13:23 Submitted Waiting Approval 10
REQ000000617406 10-02-14 13:23 Waiting Approval Planning 7268
REQ000000617406 10-02-14 15:24 Planning In Progress 2414704
REQ000000622696 10-03-14 15:34 Submitted Waiting Approval 7
REQ000000622696 10-03-14 15:35 Waiting Approval Planning 30148
REQ000000622696 10-03-14 23:57 Planning In Progress 13191512
REQ000000622696 10-08-14 16:16 In Progress Closed 11149558
REQ000000622696 12-02-14 10:06 Completed Submitted 2266121
REQ000000622729 10-03-14 15:16 Submitted Waiting Approval 7
REQ000000622729 10-03-14 15:16 Waiting Approval Planning 31261
REQ000000622729 10-03-14 23:57 Planning In Progress 13193803
REQ000000622729 10-08-14 16:54 In Progress Closed 11147256
REQ000000622729 12-02-14 10:07 Completed Submitted 2264974
REQ000000622732 10-03-14 15:29 Submitted Waiting Approval 8
REQ000000622732 10-03-14 15:29 Waiting Approval Planning 30503
REQ000000622732 10-03-14 23:57 Planning In Progress 13192837
REQ000000622732 10-08-14 16:38 In Progress Closed 11148227
REQ000000622732 12-02-14 10:06 Completed Submitted 2265757
REQ000000623101 10-03-14 15:42 Submitted Waiting Approval 8
REQ000000623101 10-03-14 15:42 Waiting Approval Planning 29701
REQ000000623101 10-03-14 23:57 Planning In Progress 13195625
REQ000000623101 10-08-14 17:24 In Progress Closed 11145429
REQ000000623101 12-02-14 10:06 Completed Submitted 2266556
REQ000000623104 10-03-14 15:45 Submitted Waiting Approval 10
REQ000000623104 10-03-14 15:45 Waiting Approval Planning 2621683
REQ000000623104 10-04-14 0:00 Planning In Progress 10597568
REQ000000623104 10-08-14 15:46 In Progress Closed 11151312
REQ000000623104 12-02-14 10:07 Completed Submitted 2266717
REQ000000641168 10-08-14 12:38 Submitted Waiting Approval 11
REQ000000641168 10-08-14 12:38 Waiting Approval Planning 2655583
REQ000000641168 10-09-14 16:10 In Progress Closed 8558197
REQ000000641168 10-09-14 6:17 Planning In Progress 35530
REQ000000641168 12-03-14 8:47 Completed Submitted 13060243
REQ000000646355 10-09-14 10:02 Planning In Progress 16720
REQ000000646355 10-09-14 14:40 In Progress Closed 8476865
REQ000000646355 10-09-14 9:37 Submitted Waiting Approval 9
REQ000000646355 10-09-14 9:37 Waiting Approval Planning 1466
REQ000000646355 12-02-14 10:03 Completed Submitted 18142446
REQ000000646712 10-09-14 12:26 Planning In Progress 2441
REQ000000646712 10-09-14 13:07 In Progress Closed 8482466
REQ000000646712 10-09-14 9:52 Submitted Waiting Approval 11
REQ000000646712 10-09-14 9:52 Waiting Approval Planning 9262
REQ000000646712 12-02-14 10:03 Completed Submitted 18143303
REQ000000700077 20-11-14 16:19 In Progress Cancelled 5544650
REQ000000700077 21-10-14 8:57 Submitted Waiting Approval 9
REQ000000700077 21-10-14 8:57 Waiting Approval Planning 177620
REQ000000700077 23-10-14 10:17 Planning In Progress 2440896
REQ000000700339 20-11-14 17:24 In Progress Cancelled 5541248
REQ000000700339 21-10-14 9:00 Submitted Waiting Approval 14
REQ000000700339 21-10-14 9:00 Waiting Approval Planning 177457
REQ000000700339 23-10-14 10:18 Planning In Progress 2444792
REQ000000700524 20-11-14 17:32 In Progress Completed 5876030
REQ000000700524 21-10-14 9:15 Submitted Waiting Approval 18
REQ000000700524 21-10-14 9:15 Waiting Approval Planning 176648
REQ000000700524 23-10-14 10:19 Planning In Progress 2445200
REQ000000700524 27-01-15 17:46 Completed Closed 1537451

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
Completed 9 9 80.0 720.1
In Progress 11 11 103.3 1,136.8
Planning 13 13 67.3 874.8
Submitted 13 13 0.0 0.0
Waiting Approval 13 13 5.3 68.9

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Completed Closed 1 17.8 17.8
Submitted 8 87.8 702.3
In Progress Cancelled 2 64.2 128.3
Closed 8 117.6 940.5
Completed 1 68.0 68.0
Planning In Progress 13 67.3 874.8
Submitted Waiting Approval 13 0.0 0.0
Waiting Approval Planning 13 5.3 68.9