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

1.3% Cancelled 4.8% Closed 32.8% Completed 0.7% Draft 39.2% In Progress 0.0% Pending 12.7% Planning 0.0% Rejected 0.5% Submitted 8.0% 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 100 out of 293

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
REQ000000666019 12-03-14 9:26 Completed Submitted 18657844
REQ000000666019 14-10-14 13:09 In Progress Closed 5631414
REQ000000666019 14-10-14 8:10 Submitted Waiting Approval 17
REQ000000666019 14-10-14 8:11 Waiting Approval Planning 1078
REQ000000666019 14-10-14 8:29 Planning In Progress 16840
REQ000000699203 11-03-14 16:46 Planning In Progress 2667677
REQ000000699203 11-04-14 13:47 In Progress Submitted 16647121
REQ000000699203 21-10-14 5:59 Submitted Waiting Approval 10
REQ000000705937 12-02-14 10:28 Completed Submitted 21763788
REQ000000705937 22-10-14 10:55 Planning In Progress 72520
REQ000000705937 22-10-14 7:58 Submitted Waiting Approval 10
REQ000000705937 22-10-14 7:58 Waiting Approval Planning 10596
REQ000000705937 23-10-14 7:03 In Progress Closed 4789092
REQ000000705948 12-02-14 10:29 Completed Submitted 21763986
REQ000000705948 22-10-14 10:55 Planning In Progress 72538
REQ000000705948 22-10-14 8:03 Submitted Waiting Approval 12
REQ000000705948 22-10-14 8:03 Waiting Approval Planning 10341
REQ000000705948 23-10-14 7:04 In Progress Closed 4789043
REQ000000705951 12-02-14 10:30 Completed Submitted 21764104
REQ000000705951 22-10-14 10:55 Planning In Progress 72583
REQ000000705951 22-10-14 8:05 Submitted Waiting Approval 11
REQ000000705951 22-10-14 8:05 Waiting Approval Planning 10214
REQ000000705951 23-10-14 7:05 In Progress Closed 4788993
REQ000000706020 12-02-14 10:28 Completed Submitted 21763921
REQ000000706020 22-10-14 10:55 Planning In Progress 72526
REQ000000706020 22-10-14 8:00 Submitted Waiting Approval 13
REQ000000706020 22-10-14 8:00 Waiting Approval Planning 10464
REQ000000706020 23-10-14 7:04 In Progress Closed 4789068
REQ000000706105 12-02-14 10:30 Completed Submitted 21764259
REQ000000706105 22-10-14 10:55 Planning In Progress 72559
REQ000000706105 22-10-14 8:08 Submitted Waiting Approval 10
REQ000000706105 22-10-14 8:08 Waiting Approval Planning 10036
REQ000000706105 23-10-14 7:04 In Progress Closed 4789017
REQ000000708094 12-02-14 10:31 Completed Submitted 21784615
REQ000000708094 22-10-14 13:48 Submitted Waiting Approval 12
REQ000000708094 22-10-14 13:48 Waiting Approval Planning 149395
REQ000000708094 24-10-14 12:10 In Progress Closed 4684284
REQ000000708094 24-10-14 7:18 Planning In Progress 17510
REQ000000708164 12-02-14 10:30 Completed Submitted 21784231
REQ000000708164 22-10-14 13:41 Submitted Waiting Approval 15
REQ000000708164 22-10-14 13:41 Waiting Approval Planning 81615
REQ000000708164 23-10-14 12:21 Planning In Progress 9679
REQ000000708164 23-10-14 15:03 In Progress Closed 4760326
REQ000000708360 12-02-14 10:16 Completed Submitted 21787043
REQ000000708360 22-10-14 14:14 Submitted Waiting Approval 15
REQ000000708360 22-10-14 14:14 Waiting Approval Planning 60481
REQ000000708360 23-10-14 7:02 Planning In Progress 5338
REQ000000708360 23-10-14 8:31 In Progress Closed 4783822
REQ000000708458 12-02-14 10:10 Completed Submitted 21787608
REQ000000708458 22-10-14 14:17 Submitted Waiting Approval 13
REQ000000708458 22-10-14 14:17 Waiting Approval Planning 60333
REQ000000708458 23-10-14 7:02 Planning In Progress 5526
REQ000000708458 23-10-14 8:34 In Progress Closed 4783615
REQ000000708469 12-02-14 10:10 Completed Submitted 21788028
REQ000000708469 22-10-14 14:23 Submitted Waiting Approval 12
REQ000000708469 22-10-14 14:24 Waiting Approval Planning 59915
REQ000000708469 23-10-14 7:02 Planning In Progress 5742
REQ000000708469 23-10-14 8:38 In Progress Closed 4783408
REQ000000708604 12-02-14 10:09 Completed Submitted 21786464
REQ000000708604 22-10-14 13:57 Submitted Waiting Approval 13
REQ000000708604 22-10-14 13:57 Waiting Approval Planning 61474
REQ000000708604 23-10-14 7:02 Planning In Progress 5062
REQ000000708604 23-10-14 8:26 In Progress Closed 4784113
REQ000000708803 12-02-14 10:31 Completed Submitted 21787584
REQ000000708803 22-10-14 14:37 Submitted Waiting Approval 11
REQ000000708803 22-10-14 14:37 Waiting Approval Planning 78258
REQ000000708803 23-10-14 12:21 Planning In Progress 9243
REQ000000708803 23-10-14 14:55 In Progress Closed 4760755
REQ000000708842 12-02-14 10:31 Completed Submitted 21789236
REQ000000708842 22-10-14 15:05 Submitted Waiting Approval 7
REQ000000708842 22-10-14 15:05 Waiting Approval Planning 76565
REQ000000708842 23-10-14 12:22 Planning In Progress 9898
REQ000000708842 23-10-14 15:07 In Progress Closed 4760094
REQ000000709028 12-03-14 8:48 Completed Submitted 19377469
REQ000000709028 22-10-14 15:26 Submitted Waiting Approval 14
REQ000000709028 22-10-14 15:26 Waiting Approval Planning 412523
REQ000000709028 27-10-14 10:02 Planning In Progress 2024
REQ000000709028 27-10-14 10:36 In Progress Closed 4517437
REQ000000709051 12-03-14 8:54 Completed Submitted 19377363
REQ000000709051 22-10-14 15:30 Submitted Waiting Approval 9
REQ000000709051 22-10-14 15:30 Waiting Approval Planning 412309
REQ000000709051 27-10-14 10:02 Planning In Progress 3149
REQ000000709051 27-10-14 10:55 In Progress Closed 4516299
REQ000000709083 11-06-14 9:54 In Progress Submitted 11513596
REQ000000709083 22-10-14 16:08 Submitted Waiting Approval 10
REQ000000709083 22-10-14 16:08 Waiting Approval Planning 603991
REQ000000712331 11-06-14 23:03 Completed Submitted 11529984
REQ000000712331 23-10-14 14:18 Planning Pending 6762
REQ000000712331 23-10-14 16:11 Pending In Progress 337047
REQ000000712331 23-10-14 9:49 Submitted Waiting Approval 20
REQ000000712331 23-10-14 9:50 Waiting Approval Planning 16112
REQ000000712331 27-10-14 13:48 In Progress Closed 2280256
REQ000000718571 11-03-14 10:56 In Progress Submitted 19618706
REQ000000718571 24-10-14 12:35 Submitted Waiting Approval 19
REQ000000718571 24-10-14 12:35 Waiting Approval Planning 273137
REQ000000723179 11-06-14 9:32 In Progress Submitted 11914010
REQ000000723179 27-10-14 6:59 Submitted Waiting Approval 9
REQ000000723179 27-10-14 6:59 Waiting Approval Planning 23354
REQ000000725168 11-06-14 9:03 In Progress Submitted 11927968
REQ000000725168 27-10-14 10:23 Submitted Waiting Approval 9

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 171.9 171.9
Closed 5 5 130.5 652.3
Completed 21 21 210.3 4,416.8
Draft 5 5 18.0 90.2
In Progress 41 41 128.6 5,271.6
Pending 1 1 3.9 3.9
Planning 66 66 25.8 1,703.0
Rejected 4 4 0.5 2.2
Submitted 78 78 0.9 67.0
Waiting Approval 71 71 15.1 1,071.8

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Cancelled Submitted 1 171.9 171.9
Closed Completed 5 130.5 652.3
Completed Closed 1 15.1 15.1
Planning 2 117.9 235.7
Submitted 18 231.4 4,165.9
Draft Completed 1 90.2 90.2
Submitted 3 0.0 0.0
Waiting Approval 1 0.0 0.0
In Progress Closed 23 83.4 1,917.4
Completed 1 13.9 13.9
Draft 1 259.0 259.0
Pending 1 17.1 17.1
Planning 1 159.2 159.2
Submitted 14 207.5 2,905.1
Pending In Progress 1 3.9 3.9
Planning In Progress 60 24.1 1,446.1
Pending 3 61.2 183.6
Submitted 3 24.4 73.3
Rejected Draft 4 0.5 2.2
Submitted Completed 1 67.0 67.0
Waiting Approval 77 0.0 0.0
Waiting Approval Cancelled 1 4.7 4.7
Completed 1 93.8 93.8
In Progress 4 32.0 127.9
Planning 61 13.7 833.1
Rejected 4 3.1 12.2