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.9% Closed 0.0% Draft 45.1% In Progress 24.8% Planning 0.0% Rejected 0.0% Submitted 10.2% 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
REQ000000717583 17-11-14 11:57 In Progress Pending 2078662
REQ000000717583 24-10-14 9:27 Submitted Waiting Approval 11
REQ000000717583 24-10-14 9:28 Waiting Approval Planning 511498
REQ000000717583 30-10-14 7:33 Planning In Progress 1571060
REQ000000717590 17-11-14 11:34 In Progress Pending 2080768
REQ000000717590 24-10-14 9:33 Submitted Waiting Approval 7
REQ000000717590 24-10-14 9:33 Waiting Approval Planning 449141
REQ000000717590 29-10-14 14:19 Planning In Progress 1631691
REQ000000717594 17-11-14 9:34 In Progress Pending 2087772
REQ000000717594 24-10-14 9:36 Submitted Waiting Approval 8
REQ000000717594 24-10-14 9:36 Waiting Approval Planning 448985
REQ000000717594 29-10-14 14:19 Planning In Progress 1624512
REQ000000717655 24-10-14 9:12 Submitted Waiting Approval 12
REQ000000717655 24-10-14 9:12 Waiting Approval Planning 512480
REQ000000717655 30-10-14 7:34 Planning In Progress 1738242
REQ000000718006 17-11-14 9:23 In Progress Pending 2088563
REQ000000718006 24-10-14 9:43 Submitted Waiting Approval 9
REQ000000718006 24-10-14 9:44 Waiting Approval Planning 448538
REQ000000718006 29-10-14 14:19 Planning In Progress 1623829
REQ000000718821 19-11-14 13:29 In Progress Pending 1901137
REQ000000718821 24-10-14 12:16 Submitted Waiting Approval 8
REQ000000718821 24-10-14 12:16 Waiting Approval Planning 439341
REQ000000718821 29-10-14 14:18 Planning In Progress 1811431
REQ000000723423 11-03-14 14:03 Planning In Progress 2654834
REQ000000723423 11-04-14 7:31 In Progress Submitted 17192063
REQ000000723423 27-10-14 7:05 Submitted Waiting Approval 14
REQ000000726859 24-11-14 11:35 In Progress Pending 1464383
REQ000000726859 27-10-14 14:00 Submitted Waiting Approval 14
REQ000000726859 27-10-14 14:01 Waiting Approval Planning 163326
REQ000000726859 29-10-14 11:23 Planning In Progress 2247104
REQ000000727504 24-11-14 11:37 In Progress Pending 1464263
REQ000000727504 27-10-14 14:31 Submitted Waiting Approval 14
REQ000000727504 27-10-14 14:32 Waiting Approval Planning 161481
REQ000000727504 29-10-14 11:23 Planning In Progress 2247274
REQ000000728562 11-04-14 13:29 In Progress Submitted 17211121
REQ000000728562 27-10-14 18:21 Submitted Waiting Approval 21
REQ000000728562 27-10-14 18:22 Waiting Approval Planning 147697
REQ000000728562 29-10-14 11:23 Planning Cancelled 10723308
REQ000000808123 11-12-14 18:17 Submitted Waiting Approval 13
REQ000000808123 11-12-14 18:17 Waiting Approval Closed 3579053
REQ000000808123 13-11-14 15:38 Rejected Draft 166
REQ000000808123 13-11-14 15:40 Draft Submitted 149
REQ000000808123 13-11-14 15:43 Submitted Waiting Approval 1
REQ000000808123 13-11-14 15:43 Waiting Approval Planning 534847
REQ000000808123 19-11-14 20:17 Planning In Progress 76540
REQ000000808123 20-11-14 17:33 In Progress Submitted 1817065
REQ000000808123 22-01-15 4:28 Closed Completed 11270531
REQ000000808341 11-12-14 18:26 Submitted Waiting Approval 8
REQ000000808341 11-12-14 18:26 Waiting Approval Closed 3578515
REQ000000808341 13-11-14 15:39 Rejected Draft 94
REQ000000808341 13-11-14 15:40 Draft Submitted 478
REQ000000808341 13-11-14 15:48 Submitted Waiting Approval 1
REQ000000808341 13-11-14 15:48 Waiting Approval Planning 534552
REQ000000808341 19-11-14 20:17 Planning In Progress 159659
REQ000000808341 21-11-14 16:38 In Progress Submitted 1734479
REQ000000808341 22-01-15 4:28 Closed Completed 11270730
REQ000001286913 26-02-15 15:07 Submitted Waiting Approval 6
REQ000001286913 26-02-15 15:07 Waiting Approval Planning 80589
REQ000001286913 27-02-15 13:31 Planning In Progress 303

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 2 2 130.4 260.9
Draft 2 2 0.0 0.0
In Progress 11 11 53.8 591.7
Planning 13 13 25.0 325.3
Rejected 2 2 0.0 0.0
Submitted 15 15 0.0 0.0
Waiting Approval 14 14 9.6 134.1

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Closed Completed 2 130.4 260.9
Draft Submitted 2 0.0 0.0
In Progress Pending 7 21.8 152.4
Submitted 4 109.8 439.3
Planning Cancelled 1 124.1 124.1
In Progress 12 16.8 201.2
Rejected Draft 2 0.0 0.0
Submitted Waiting Approval 15 0.0 0.0
Waiting Approval Closed 2 41.4 82.8
Planning 12 4.3 51.3