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

13.0% Closed 46.1% Completed 0.0% Draft 16.7% In Progress 10.0% Planning 0.0% Rejected 0.0% Submitted 14.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 125

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
REQ000000679147 12-02-14 10:08 Completed Submitted 21249493
REQ000000679147 16-10-14 11:19 Planning In Progress 3297
REQ000000679147 16-10-14 12:14 In Progress Closed 5375256
REQ000000679147 16-10-14 8:46 Submitted Waiting Approval 10
REQ000000679147 16-10-14 8:46 Waiting Approval Planning 9158
REQ000000781820 11-06-14 17:48 Submitted Waiting Approval 16
REQ000000781820 11-06-14 17:48 Waiting Approval Planning 13196039
REQ000000781820 11-11-14 11:22 Planning In Progress 8221
REQ000000781820 11-11-14 13:39 In Progress Closed 3210400
REQ000000781820 12-03-14 10:44 Completed Submitted 7887854
REQ000000786709 11-07-14 15:04 Submitted Waiting Approval 15
REQ000000786709 11-07-14 15:04 Waiting Approval Planning 7940408
REQ000000786709 11-10-14 12:44 Planning In Progress 2667288
REQ000000791661 11-10-14 10:49 Submitted Waiting Approval 17
REQ000000791661 11-10-14 10:49 Waiting Approval Planning 2947272
REQ000000791661 12-03-14 10:52 Completed Submitted 18402973
REQ000000791661 14-11-14 13:30 Planning In Progress 346513
REQ000000791661 18-11-14 13:45 In Progress Closed 2605243
REQ000000797710 11-11-14 9:12 Submitted Waiting Approval 20
REQ000000797710 11-11-14 9:12 Waiting Approval Planning 274663
REQ000000797710 14-11-14 13:30 Planning In Progress 339966
REQ000000797710 18-11-14 11:56 In Progress Closed 5589135
REQ000000797710 22-01-15 4:28 Closed Completed 11270388
REQ000000798065 11-11-14 9:28 Submitted Waiting Approval 15
REQ000000798065 11-11-14 9:28 Waiting Approval Planning 273702
REQ000000798065 14-11-14 13:30 Planning In Progress 342715
REQ000000798065 18-11-14 12:42 In Progress Closed 5586376
REQ000000798065 22-01-15 4:28 Closed Completed 11272985
REQ000000839484 12-03-14 10:48 Completed Submitted 21782827
REQ000000839484 19-11-14 13:35 Submitted Waiting Approval 17
REQ000000839484 19-11-14 13:36 Waiting Approval Planning 18415
REQ000000839484 19-11-14 18:43 Planning In Progress 56589
REQ000000839484 20-11-14 10:26 In Progress Closed 2444401
REQ000000839584 19-11-14 13:59 Submitted Waiting Approval 15
REQ000000839584 19-11-14 14:00 Waiting Approval Planning 16959
REQ000000839584 19-11-14 18:42 Planning In Progress 56876
REQ000000839584 20-11-14 10:30 In Progress Closed 5421487
REQ000000839584 22-01-15 4:28 Closed Completed 11270424
REQ000000839778 12-03-14 10:52 Completed Submitted 21784209
REQ000000839778 19-11-14 14:02 Submitted Waiting Approval 27
REQ000000839778 19-11-14 14:02 Waiting Approval Planning 16829
REQ000000839778 19-11-14 18:43 Planning In Progress 57283
REQ000000839778 20-11-14 10:38 In Progress Closed 2443695
REQ000000839950 12-03-14 10:49 Completed Submitted 21784587
REQ000000839950 19-11-14 14:05 Submitted Waiting Approval 18
REQ000000839950 19-11-14 14:05 Waiting Approval Planning 16614
REQ000000839950 19-11-14 18:42 Planning In Progress 57888
REQ000000839950 20-11-14 10:47 In Progress Closed 2443120
REQ000000839957 12-03-14 10:47 Completed Submitted 21785150
REQ000000839957 19-11-14 14:13 Submitted Waiting Approval 17
REQ000000839957 19-11-14 14:13 Waiting Approval Planning 16145
REQ000000839957 19-11-14 18:42 Planning In Progress 66564
REQ000000839957 20-11-14 13:12 In Progress Closed 2434456
REQ000000840036 12-03-14 10:50 Completed Submitted 21784711
REQ000000840036 19-11-14 14:09 Submitted Waiting Approval 20
REQ000000840036 19-11-14 14:09 Waiting Approval Planning 16394
REQ000000840036 19-11-14 18:42 Planning In Progress 65101
REQ000000840036 20-11-14 12:47 In Progress Closed 2435920
REQ000000840133 12-03-14 10:47 Completed Submitted 21784606
REQ000000840133 19-11-14 14:03 Submitted Waiting Approval 22
REQ000000840133 19-11-14 14:04 Waiting Approval Planning 16693
REQ000000840133 19-11-14 18:42 Planning In Progress 57545
REQ000000840133 20-11-14 10:41 In Progress Closed 2443485
REQ000000840215 19-11-14 14:07 Submitted Waiting Approval 14
REQ000000840215 19-11-14 14:07 Waiting Approval Planning 16536
REQ000000840215 19-11-14 18:43 Planning In Progress 58128
REQ000000840215 20-11-14 10:52 In Progress Closed 5420195
REQ000000840215 22-01-15 4:28 Closed Completed 11270440
REQ000000840216 12-03-14 10:45 Completed Submitted 21785118
REQ000000840216 19-11-14 14:10 Submitted Waiting Approval 18
REQ000000840216 19-11-14 14:10 Waiting Approval Planning 16257
REQ000000840216 19-11-14 18:41 Planning In Progress 66355
REQ000000840216 20-11-14 13:07 In Progress Closed 2434713
REQ000000863640 12-05-14 13:47 Planning Submitted 16981703
REQ000000863640 25-11-14 2:55 Submitted Waiting Approval 8
REQ000000863640 25-11-14 2:55 Waiting Approval Cancelled 8428518
REQ000000864980 22-01-15 4:28 Closed Completed 11273040
REQ000000864980 25-11-14 14:41 Planning In Progress 985
REQ000000864980 25-11-14 14:57 In Progress Closed 4973478
REQ000000864980 25-11-14 9:27 Submitted Waiting Approval 17
REQ000000864980 25-11-14 9:27 Waiting Approval Planning 18818
REQ000000995657 15-01-15 13:15 In Progress Planning 17115953
REQ000000995657 23-12-14 14:58 Submitted Waiting Approval 3
REQ000000995657 23-12-14 14:58 Waiting Approval In Progress 1981056
REQ000001011100 01-02-15 12:41 Submitted Waiting Approval 4
REQ000001011100 01-02-15 12:41 Waiting Approval Planning 3581
REQ000001011100 01-02-15 13:40 Planning In Progress 7673665
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
REQ000001059479 13-01-15 13:30 Submitted Waiting Approval 5
REQ000001059479 13-01-15 13:30 Waiting Approval Rejected 46
REQ000001059479 13-01-15 13:31 Rejected Draft 44
REQ000001059479 13-01-15 13:31 Draft Submitted 53
REQ000001059479 13-01-15 13:32 Submitted Waiting Approval 1
REQ000001059479 13-01-15 13:32 Waiting Approval Planning 98669
REQ000001059479 14-01-15 16:57 Planning In Progress 400473
REQ000001059479 19-01-15 8:11 In Progress Cancelled 11466
REQ000001060544 13-01-15 14:49 Submitted Waiting Approval 10
REQ000001060544 13-01-15 14:49 Waiting Approval Planning 1125993

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 5 5 130.5 652.3
Completed 10 10 231.5 2,315.2
Draft 1 1 0.0 0.0
In Progress 17 17 49.3 837.8
Planning 27 27 18.6 502.5
Rejected 1 1 0.0 0.0
Submitted 32 32 0.0 0.0
Waiting Approval 32 32 22.2 711.2

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Closed Completed 5 130.5 652.3
Completed Submitted 10 231.5 2,315.2
Draft Submitted 1 0.0 0.0
In Progress Cancelled 1 0.1 0.1
Closed 15 42.6 639.6
Planning 1 198.1 198.1
Planning In Progress 26 11.8 306.0
Submitted 1 196.5 196.5
Rejected Draft 1 0.0 0.0
Submitted Waiting Approval 32 0.0 0.0
Waiting Approval Cancelled 1 97.6 97.6
In Progress 1 22.9 22.9
Planning 29 20.4 590.7
Rejected 1 0.0 0.0