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

3.0% Closed 1.9% Completed 36.8% In Progress 7.5% Pending 27.2% Planning 0.0% Submitted 23.6% 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 183

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
REQ000000610717 10-01-14 11:13 Planning Pending 188
REQ000000610717 10-01-14 11:16 Pending Cancelled 23859847
REQ000000610717 10-01-14 8:57 Submitted Waiting Approval 16
REQ000000610717 10-01-14 8:57 Waiting Approval Planning 8141
REQ000000611023 10-01-14 9:42 Submitted Waiting Approval 21
REQ000000611023 10-01-14 9:43 Waiting Approval Planning 2652416
REQ000000611023 10-02-14 2:29 Planning Pending 16010
REQ000000611023 10-02-14 6:56 Pending In Progress 21196714
REQ000000611023 13-10-14 14:55 In Progress Completed 1204222
REQ000000611023 26-02-15 1:42 Closed Completed 18873661
REQ000000611023 27-10-14 13:25 Completed In Progress 170129
REQ000000611023 29-10-14 12:41 In Progress Closed 10328469
REQ000000647656 10-09-14 12:52 Submitted Waiting Approval 8
REQ000000647656 10-09-14 12:52 Waiting Approval Cancelled 4369
REQ000000660584 13-10-14 12:00 Submitted Waiting Approval 14
REQ000000660584 13-10-14 12:00 Waiting Approval Planning 263135
REQ000000660584 16-10-14 13:06 Planning In Progress 676153
REQ000000684562 17-10-14 7:37 Submitted Waiting Approval 11
REQ000000684562 17-10-14 7:37 Waiting Approval Planning 338949
REQ000000684562 21-10-14 5:46 Planning In Progress 197926
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
REQ000000740747 11-06-14 12:41 Pending In Progress 6
REQ000000740747 11-06-14 12:41 In Progress Submitted 12100115
REQ000000740747 29-10-14 13:50 Submitted Waiting Approval 11
REQ000000740747 29-10-14 13:50 Waiting Approval Planning 85316
REQ000000740921 11-06-14 12:36 In Progress Submitted 12100933
REQ000000740921 29-10-14 13:58 Submitted Waiting Approval 12
REQ000000740921 29-10-14 13:58 Waiting Approval Planning 84041
REQ000000744442 30-10-14 10:29 Planning In Progress 3638720
REQ000000744442 30-10-14 7:48 Submitted Waiting Approval 10
REQ000000744442 30-10-14 7:48 Waiting Approval Planning 9693
REQ000000744505 30-10-14 10:29 Planning In Progress 3638909
REQ000000744505 30-10-14 7:45 Submitted Waiting Approval 11
REQ000000744505 30-10-14 7:45 Waiting Approval Planning 9852
REQ000000745329 30-10-14 13:32 Planning In Progress 1035271
REQ000000745329 30-10-14 9:39 Submitted Waiting Approval 13
REQ000000745329 30-10-14 9:39 Waiting Approval Planning 14017
REQ000000831599 18-11-14 10:54 Submitted Waiting Approval 32
REQ000000831599 18-11-14 10:55 Waiting Approval Planning 75680
REQ000000831599 19-11-14 7:56 Planning In Progress 625066
REQ000000831599 26-11-14 13:34 In Progress Cancelled 7074529
REQ000000838008 19-11-14 9:52 Submitted Waiting Approval 25
REQ000000838008 19-11-14 9:53 Waiting Approval Planning 120417
REQ000000838008 20-11-14 19:20 Planning In Progress 498927
REQ000000839367 19-11-14 12:52 Submitted Waiting Approval 8
REQ000000839367 19-11-14 12:52 Waiting Approval Rejected 92835
REQ000000839376 19-11-14 12:55 Submitted Waiting Approval 13
REQ000000839376 19-11-14 12:55 Waiting Approval Rejected 92737
REQ000000839551 12-01-14 10:59 In Progress Submitted 26877965
REQ000000839551 19-11-14 13:05 Submitted Waiting Approval 16
REQ000000839551 19-11-14 13:06 Waiting Approval Planning 758399
REQ000000880520 12-02-14 10:42 In Progress Submitted 24896499
REQ000000880520 12-02-14 8:38 Planning In Progress 7406
REQ000000880520 27-11-14 14:23 Submitted Waiting Approval 10
REQ000000884589 18-12-14 18:19 Planning In Progress 14248641
REQ000000884589 28-11-14 13:12 Submitted Waiting Approval 10
REQ000000884589 28-11-14 13:12 Waiting Approval Planning 1746397
REQ000000884733 12-03-14 18:36 Planning In Progress 21147422
REQ000000884733 12-11-14 12:53 In Progress Submitted 1382378
REQ000000884733 28-11-14 12:53 Submitted Waiting Approval 10
REQ000000884832 12-03-14 18:36 Planning In Progress 21147256
REQ000000884832 12-11-14 12:50 In Progress Submitted 1382341
REQ000000884832 28-11-14 12:49 Submitted Waiting Approval 7
REQ000000913985 12-04-14 14:29 Submitted Waiting Approval 22
REQ000000913985 12-04-14 14:29 Waiting Approval Cancelled 25483712
REQ000000914136 12-04-14 14:24 Submitted Waiting Approval 28
REQ000000914136 12-04-14 14:24 Waiting Approval Cancelled 25483788
REQ000000995181 23-12-14 13:30 Submitted Waiting Approval 8
REQ000000995426 23-12-14 12:57 Submitted Waiting Approval 4
REQ000000995426 23-12-14 12:57 Waiting Approval Rejected 3093807
REQ000001007765 15-01-15 12:57 In Progress Planning 1471785
REQ000001007765 30-12-14 17:42 Submitted Waiting Approval 5
REQ000001007765 30-12-14 17:42 Waiting Approval In Progress 1365304
REQ000001008028 01-05-15 7:57 Planning In Progress 7958844
REQ000001008028 30-12-14 17:23 Submitted Waiting Approval 3
REQ000001008028 30-12-14 17:23 Waiting Approval Planning 10506879
REQ000001010989 01-02-15 13:13 Submitted Waiting Approval 10
REQ000001010989 13-01-15 17:08 Planning In Progress 503094
REQ000001010989 19-01-15 12:53 In Progress Submitted 1124386
REQ000001011170 01-02-15 12:48 Submitted Waiting Approval 4
REQ000001011170 01-02-15 12:48 Waiting Approval Planning 12960679
REQ000001011170 01-07-15 12:59 Planning In Progress 11520
REQ000001011316 01-02-15 12:26 Submitted Waiting Approval 4
REQ000001011316 01-02-15 12:26 Waiting Approval Rejected 10362297
REQ000001011320 01-02-15 12:30 Submitted Waiting Approval 8
REQ000001011320 01-02-15 12:30 Waiting Approval Rejected 10362070
REQ000001011604 01-02-15 13:18 Submitted Waiting Approval 11
REQ000001011604 13-01-15 16:54 Planning In Progress 503735
REQ000001011604 19-01-15 12:49 In Progress Submitted 1124903
REQ000001031479 01-07-15 14:34 Submitted Waiting Approval 4
REQ000001031479 19-01-15 14:56 Planning In Progress 91591
REQ000001031479 20-01-15 16:22 In Progress Submitted 13990277
REQ000001035828 01-08-15 8:31 Submitted Waiting Approval 7
REQ000001052338 01-12-15 13:22 Submitted Waiting Approval 5
REQ000001052338 01-12-15 13:22 Waiting Approval Planning 16654

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 1 1 218.4 218.4
Completed 2 2 67.7 135.4
In Progress 20 20 133.6 2,672.7
Pending 6 6 91.0 546.2
Planning 41 41 48.2 1,978.2
Submitted 63 63 0.0 0.0
Waiting Approval 50 50 34.4 1,718.8

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Closed Completed 1 218.4 218.4
Completed In Progress 1 2.0 2.0
Submitted 1 133.4 133.4
In Progress Cancelled 1 81.9 81.9
Closed 2 73.0 145.9
Completed 1 13.9 13.9
Planning 1 17.0 17.0
Submitted 15 160.9 2,413.9
Pending Cancelled 1 276.2 276.2
In Progress 5 54.0 270.0
Planning In Progress 36 54.9 1,977.9
Pending 5 0.1 0.3
Submitted Waiting Approval 63 0.0 0.0
Waiting Approval Cancelled 6 135.1 810.3
In Progress 1 15.8 15.8
Planning 38 16.2 614.8
Rejected 5 55.6 277.8