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

4.2% Cancelled 8.9% Closed 23.9% Completed 0.3% Draft 34.8% In Progress 0.0% Pending 3.5% Planning 2.2% Rejected 0.1% Submitted 22.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 100 out of 462

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
REQ000000648239 10-09-14 14:12 Submitted Waiting Approval 14
REQ000000648239 10-09-14 14:12 Waiting Approval Planning 3094472
REQ000000648239 16-10-14 9:47 Planning In Progress 82707
REQ000000668299 11-05-14 10:23 In Progress Draft 13492691
REQ000000668299 14-10-14 14:21 Draft Submitted 491863
REQ000000668299 20-10-14 6:59 Submitted Waiting Approval 17
REQ000000668299 20-10-14 6:59 Waiting Approval Planning 839833
REQ000000668299 30-10-14 0:17 Planning Pending 140347
REQ000000675376 15-10-14 15:06 Draft Submitted 402465
REQ000000675376 20-10-14 6:53 Submitted Waiting Approval 20
REQ000000675376 20-10-14 6:54 Waiting Approval Rejected 4000
REQ000000675376 20-10-14 8:00 Rejected Draft 523
REQ000000675376 20-10-14 8:09 Draft Submitted 78
REQ000000675376 20-10-14 8:10 Submitted Waiting Approval 1
REQ000000675376 20-10-14 8:10 Waiting Approval Planning 835551
REQ000000675376 30-10-14 0:16 Planning In Progress 139841
REQ000000692521 20-10-14 7:37 Submitted Waiting Approval 16
REQ000000692521 20-10-14 7:37 Waiting Approval Rejected 2097264
REQ000000692533 20-10-14 7:42 Submitted Waiting Approval 16
REQ000000692533 20-10-14 7:42 Waiting Approval Rejected 2096972
REQ000000693082 20-10-14 8:43 Submitted Waiting Approval 21
REQ000000693082 20-10-14 8:44 Waiting Approval Planning 833547
REQ000000693082 30-10-14 0:16 Planning In Progress 141747
REQ000000693082 31-10-14 15:38 In Progress Completed 9989800
REQ000000696261 11-06-14 16:00 Rejected Draft 134
REQ000000696261 11-06-14 16:02 Draft Submitted 82
REQ000000696261 11-06-14 16:04 Submitted Waiting Approval 2
REQ000000696261 11-06-14 16:04 Waiting Approval Draft 11313954
REQ000000696261 18-11-14 13:51 In Progress Planning 1977645
REQ000000696261 20-10-14 14:50 Draft Submitted 863598
REQ000000696261 30-10-14 14:43 Submitted Waiting Approval 34
REQ000000696261 30-10-14 14:43 Waiting Approval Rejected 90789
REQ000000696261 31-10-14 15:57 Rejected Draft 882
REQ000000696261 31-10-14 16:11 Draft Submitted 65
REQ000000696261 31-10-14 16:12 Submitted Waiting Approval 1
REQ000000696261 31-10-14 16:12 Waiting Approval In Progress 1546733
REQ000000714210 23-10-14 14:26 Submitted Waiting Approval 27
REQ000000714210 23-10-14 14:26 Waiting Approval Cancelled 700844
REQ000000714222 23-10-14 14:31 Submitted Waiting Approval 24
REQ000000714222 23-10-14 14:32 Waiting Approval Cancelled 700570
REQ000000717278 24-10-14 8:13 Submitted Waiting Approval 8
REQ000000717278 24-10-14 8:13 Waiting Approval Planning 535944
REQ000000717278 30-10-14 13:06 Planning In Progress 73964
REQ000000717278 31-10-14 9:38 In Progress Cancelled 2321298
REQ000000717407 24-10-14 8:19 Submitted Waiting Approval 11
REQ000000717407 24-10-14 8:19 Waiting Approval Planning 535612
REQ000000717407 30-10-14 13:06 Planning In Progress 73993
REQ000000717407 31-10-14 9:39 In Progress Cancelled 2321180
REQ000000717507 11-05-14 17:24 Planning In Progress 723
REQ000000717507 11-05-14 17:36 In Progress Submitted 14309783
REQ000000717507 12-01-14 8:52 Closed Planning 10312316
REQ000000717507 24-10-14 8:32 Submitted Waiting Approval 18
REQ000000717507 24-10-14 8:32 Waiting Approval Completed 1942682
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
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
REQ000000724794 27-10-14 10:16 Submitted Waiting Approval 9
REQ000000724794 27-10-14 10:16 Waiting Approval Cancelled 7882208
REQ000000725308 27-10-14 10:20 Submitted Waiting Approval 16
REQ000000725308 27-10-14 10:20 Waiting Approval Cancelled 7882020
REQ000000726194 11-11-14 7:50 Planning In Progress 2592420
REQ000000726194 11-12-14 7:57 In Progress Completed 4669369
REQ000000726194 27-10-14 13:25 Draft Submitted 350875
REQ000000726194 31-10-14 14:52 Submitted Waiting Approval 12
REQ000000726194 31-10-14 14:53 Waiting Approval Planning 925038
REQ000000740302 11-05-14 13:29 Planning In Progress 8765
REQ000000740302 11-05-14 15:55 In Progress Submitted 14762165
REQ000000740302 14-11-14 15:08 Completed Closed 1359769
REQ000000740302 29-10-14 12:31 Submitted Waiting Approval 31
REQ000000740302 29-10-14 12:32 Waiting Approval Completed 1391808
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
REQ000000740607 19-11-14 14:06 Planning In Progress 601691
REQ000000740607 29-10-14 12:54 Submitted Waiting Approval 24
REQ000000740607 29-10-14 12:54 Waiting Approval Planning 1818727
REQ000000740986 12-01-14 14:09 Cancelled Submitted 25058562
REQ000000740986 29-10-14 14:51 Submitted Waiting Approval 31
REQ000000741325 12-01-14 14:08 Cancelled Submitted 25059107
REQ000000741325 29-10-14 14:59 Submitted Waiting Approval 34
REQ000000745836 11-05-14 13:29 Planning In Progress 9306
REQ000000745836 11-05-14 16:04 In Progress Submitted 14843051
REQ000000745836 14-11-14 15:17 Completed Closed 1359258
REQ000000745836 30-10-14 11:09 Submitted Waiting Approval 25
REQ000000745836 30-10-14 11:09 Waiting Approval Completed 1310875
REQ000000753120 31-10-14 13:56 Submitted Waiting Approval 12
REQ000000753120 31-10-14 13:56 Waiting Approval Rejected 2251457

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 3 3 264.4 793.2
Closed 14 14 121.2 1,696.4
Completed 26 26 175.3 4,558.4
Draft 30 30 1.8 55.1
In Progress 63 63 105.7 6,656.9
Pending 2 2 0.5 1.1
Planning 76 76 8.7 662.2
Rejected 21 21 20.3 426.5
Submitted 119 119 0.1 13.0
Waiting Approval 108 108 39.3 4,241.9

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Cancelled Planning 1 213.1 213.1
Submitted 2 290.0 580.1
Closed Completed 13 121.3 1,577.0
Planning 1 119.4 119.4
Completed Closed 3 44.9 134.6
Planning 4 213.2 852.9
Submitted 19 187.9 3,570.9
Draft Completed 1 0.7 0.7
Submitted 28 1.9 54.4
Waiting Approval 1 0.0 0.0
In Progress Cancelled 4 45.7 182.9
Closed 25 67.6 1,688.8
Completed 6 99.0 593.8
Draft 2 122.7 245.4
Planning 1 22.9 22.9
Submitted 25 156.9 3,923.2
Pending In Progress 2 0.5 1.1
Planning Closed 2 44.3 88.6
Draft 1 14.1 14.1
In Progress 65 7.3 477.5
Pending 3 0.8 2.4
Rejected 3 13.9 41.6
Submitted 2 19.0 38.1
Rejected Draft 18 15.3 275.8
Planning 2 12.9 25.8
Rejected 1 124.9 124.9
Submitted Planning 1 12.9 12.9
Waiting Approval 118 0.0 0.0
Waiting Approval Cancelled 4 49.7 198.7
Closed 9 43.5 391.5
Completed 4 13.6 54.6
Draft 4 58.5 233.8
In Progress 2 18.8 37.6
Planning 61 39.5 2,408.1
Rejected 22 23.2 511.4
Submitted 2 203.1 406.1