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.

0.0% In Progress 3.9% Pending 57.7% Planning 0.0% Submitted 38.4% 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 44 out of 44

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
REQ000000625469 10-06-14 6:31 Submitted Waiting Approval 8
REQ000000625469 10-06-14 6:31 Waiting Approval Planning 6045
REQ000000625469 10-06-14 8:12 Planning Pending 10825247
REQ000000625469 13-10-14 15:13 Pending In Progress 937583
REQ000000625480 10-06-14 6:40 Submitted Waiting Approval 8
REQ000000625480 10-06-14 6:41 Waiting Approval Planning 5438
REQ000000625480 10-06-14 8:11 Planning Pending 10825266
REQ000000625480 13-10-14 15:12 Pending In Progress 936501
REQ000000625595 10-06-14 6:33 Submitted Waiting Approval 7
REQ000000625595 10-06-14 6:34 Waiting Approval Planning 5833
REQ000000625595 10-06-14 8:11 Planning Pending 10824676
REQ000000625595 13-10-14 15:02 Pending In Progress 938697
REQ000000684279 17-10-14 13:03 Planning In Progress 513929
REQ000000684279 17-10-14 6:57 Submitted Waiting Approval 8
REQ000000684279 17-10-14 6:57 Waiting Approval Planning 21991
REQ000000684312 17-10-14 6:14 Submitted Waiting Approval 7
REQ000000684312 17-10-14 6:14 Waiting Approval Planning 8127
REQ000000684312 17-10-14 8:30 Planning In Progress 530845
REQ000000685446 17-10-14 12:51 Planning In Progress 590439
REQ000000685446 17-10-14 9:32 Submitted Waiting Approval 12
REQ000000685446 17-10-14 9:33 Waiting Approval Planning 11935
REQ000000718913 24-10-14 12:23 Submitted Waiting Approval 9
REQ000000718913 24-10-14 12:23 Waiting Approval Rejected 331643
REQ000000995719 14-01-15 10:31 Planning In Progress 432794
REQ000000995719 19-01-15 10:44 In Progress Cancelled 1774
REQ000000995719 23-12-14 14:13 Submitted Waiting Approval 5
REQ000000995719 23-12-14 14:13 Waiting Approval Planning 1887451
REQ000000995722 23-12-14 14:16 Submitted Waiting Approval 5
REQ000000995722 23-12-14 14:16 Waiting Approval Rejected 1887366
REQ000001007471 14-01-15 10:32 Planning In Progress 432400
REQ000001007471 30-12-14 17:32 Submitted Waiting Approval 4
REQ000001007471 30-12-14 17:32 Waiting Approval Planning 1270829
REQ000001007472 14-01-15 10:32 Planning In Progress 432122
REQ000001007472 30-12-14 17:33 Submitted Waiting Approval 3
REQ000001007472 30-12-14 17:33 Waiting Approval Planning 1270753
REQ000001007929 14-01-15 10:33 Planning In Progress 431768
REQ000001007929 30-12-14 17:36 Submitted Waiting Approval 5
REQ000001007929 30-12-14 17:36 Waiting Approval Planning 1270633
REQ000001059987 13-01-15 14:09 Submitted Waiting Approval 3
REQ000001059987 13-01-15 14:09 Waiting Approval Planning 162808
REQ000001059987 15-01-15 11:22 Planning In Progress 333775
REQ000001095756 02-09-15 14:30 Planning In Progress 5252063
REQ000001095756 20-01-15 14:34 Submitted Waiting Approval 7
REQ000001095756 20-01-15 14:34 Waiting Approval Planning 19439752

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
In Progress 1 1 0.0 0.0
Pending 3 3 10.9 32.6
Planning 12 12 40.0 479.5
Submitted 14 14 0.0 0.0
Waiting Approval 14 14 22.8 319.2

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
In Progress Cancelled 1 0.0 0.0
Pending In Progress 3 10.9 32.6
Planning In Progress 9 11.5 103.6
Pending 3 125.3 375.9
Submitted Waiting Approval 14 0.0 0.0
Waiting Approval Planning 12 24.5 293.5
Rejected 2 12.8 25.7