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.

1.9% Cancelled 5.5% Closed 28.9% Completed 0.0% Draft 21.9% In Progress 6.1% Planning 0.0% Rejected 0.0% Submitted 35.7% 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 143

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
REQ000000629417 10-06-14 13:35 Submitted Waiting Approval 8
REQ000000629417 11-03-14 21:54 Planning Cancelled 2749206
REQ000000629417 12-04-14 17:34 Cancelled Submitted 5083305
REQ000000629426 10-06-14 13:41 Submitted Waiting Approval 9
REQ000000629426 11-03-14 21:54 Planning Cancelled 2749237
REQ000000629426 12-04-14 17:34 Cancelled Submitted 5083565
REQ000000681656 12-03-14 8:36 Completed Submitted 18857004
REQ000000681656 16-10-14 14:39 Submitted Waiting Approval 12
REQ000000681656 16-10-14 14:40 Waiting Approval Planning 3853
REQ000000681656 16-10-14 15:44 Planning In Progress 333468
REQ000000681656 20-10-14 12:22 In Progress Closed 5115875
REQ000000686327 12-02-14 10:19 Completed Submitted 21350087
REQ000000686327 17-10-14 12:54 Submitted Waiting Approval 11
REQ000000686327 17-10-14 12:54 Waiting Approval Planning 256472
REQ000000686327 20-10-14 12:09 Planning In Progress 13817
REQ000000686327 20-10-14 15:59 In Progress Closed 5016137
REQ000000686714 12-03-14 8:36 Completed Submitted 18937247
REQ000000686714 17-10-14 12:57 Submitted Waiting Approval 11
REQ000000686714 17-10-14 12:57 Waiting Approval Planning 256310
REQ000000686714 20-10-14 12:09 Planning In Progress 14456
REQ000000686714 20-10-14 16:10 In Progress Closed 5102176
REQ000000686718 12-02-14 10:12 Completed Submitted 21350931
REQ000000686718 17-10-14 13:01 Submitted Waiting Approval 11
REQ000000686718 17-10-14 13:01 Waiting Approval Planning 256084
REQ000000686718 20-10-14 12:09 Planning In Progress 15086
REQ000000686718 20-10-14 16:20 In Progress Closed 5014861
REQ000000711978 12-08-14 9:35 Completed Submitted 6219847
REQ000000711978 23-10-14 12:01 Planning In Progress 10239
REQ000000711978 23-10-14 14:51 In Progress Closed 5280473
REQ000000711978 23-10-14 9:19 Submitted Waiting Approval 10
REQ000000711978 23-10-14 9:19 Waiting Approval Planning 9699
REQ000000712113 12-03-14 10:41 Completed Submitted 19434014
REQ000000712113 23-10-14 10:24 Planning In Progress 14153
REQ000000712113 23-10-14 14:20 In Progress Closed 4849597
REQ000000712113 23-10-14 9:01 Submitted Waiting Approval 18
REQ000000712113 23-10-14 9:02 Waiting Approval Planning 4917
REQ000000748775 13-11-14 17:43 In Progress Cancelled 84987
REQ000000748775 30-10-14 19:35 Submitted Waiting Approval 22
REQ000000748775 30-10-14 19:35 Waiting Approval Rejected 1360
REQ000000748775 30-10-14 19:58 Rejected Draft 280
REQ000000748775 30-10-14 20:03 Draft Waiting Approval 82
REQ000000748775 30-10-14 20:04 Submitted Planning 44656
REQ000000748775 31-10-14 8:28 Planning In Progress 1156491
REQ000000761570 11-03-14 17:31 Submitted Waiting Approval 9
REQ000000761570 11-03-14 17:31 Waiting Approval Planning 21823129
REQ000000761570 19-11-14 7:30 Planning In Progress 16
REQ000000761570 19-11-14 7:30 In Progress Cancelled 40697
REQ000000761575 11-03-14 17:33 Submitted Waiting Approval 9
REQ000000761575 11-03-14 17:33 Waiting Approval Planning 21823034
REQ000000761575 19-11-14 7:30 Planning In Progress 21
REQ000000761575 19-11-14 7:31 In Progress Cancelled 40288
REQ000000761578 11-03-14 17:37 Submitted Waiting Approval 6
REQ000000761578 11-03-14 17:37 Waiting Approval Planning 85170
REQ000000761578 12-03-14 17:17 Planning In Progress 15872934
REQ000000761578 12-09-14 10:26 In Progress Cancelled 12120584
REQ000000761598 11-03-14 18:38 Submitted Waiting Approval 9
REQ000000761598 11-03-14 18:38 Waiting Approval Planning 5258948
REQ000000761598 11-05-14 15:27 Planning Cancelled 2641
REQ000000761692 11-03-14 17:10 Submitted Waiting Approval 10
REQ000000761692 11-03-14 17:10 Waiting Approval Planning 21824386
REQ000000761692 19-11-14 7:30 Planning In Progress 21
REQ000000761692 19-11-14 7:30 In Progress Cancelled 40896
REQ000000761698 11-03-14 17:15 Submitted Waiting Approval 9
REQ000000761698 11-03-14 17:15 Waiting Approval Planning 21824105
REQ000000761698 19-11-14 7:30 Planning In Progress 23
REQ000000761698 19-11-14 7:30 In Progress Cancelled 40983
REQ000000761773 11-03-14 17:10 Submitted Waiting Approval 12
REQ000000761773 11-03-14 17:10 Waiting Approval Rejected 12846
REQ000000761773 11-03-14 20:44 Rejected Draft 930
REQ000000761773 11-03-14 20:59 Draft Cancelled 1135
REQ000000761965 11-03-14 17:07 Submitted Waiting Approval 11
REQ000000761965 11-03-14 17:07 Waiting Approval Planning 21824609
REQ000000761965 19-11-14 7:30 Planning In Progress 22
REQ000000761965 19-11-14 7:31 In Progress Cancelled 40233
REQ000000761974 11-03-14 17:17 Submitted Waiting Approval 14
REQ000000761974 11-03-14 17:17 Waiting Approval Planning 21823960
REQ000000761974 19-11-14 7:30 Planning In Progress 22
REQ000000761974 19-11-14 7:31 In Progress Cancelled 40407
REQ000000763017 11-03-14 21:34 Submitted Waiting Approval 9
REQ000000763017 11-03-14 21:35 Waiting Approval Planning 862
REQ000000763017 11-03-14 21:49 Planning Cancelled 2749408
REQ000000782454 11-06-14 23:07 Submitted Waiting Approval 24
REQ000000782454 11-06-14 23:08 Waiting Approval Planning 13893876
REQ000000782454 12-02-14 22:41 In Progress Submitted 10283193
REQ000000782454 19-11-14 18:32 Planning Cancelled 2514399
REQ000000782563 11-06-14 23:16 Submitted Waiting Approval 22
REQ000000782563 11-06-14 23:17 Waiting Approval Planning 13893211
REQ000000782563 12-03-14 17:45 In Progress Submitted 7882284
REQ000000782563 19-11-14 18:30 Planning Cancelled 2514554
REQ000000820073 12-03-14 10:39 Completed Submitted 21365447
REQ000000820073 14-11-14 17:30 Submitted Waiting Approval 13
REQ000000820073 14-11-14 17:30 Waiting Approval Planning 2270
REQ000000820073 14-11-14 18:08 Planning In Progress 234970
REQ000000820073 17-11-14 11:24 In Progress Closed 2700104
REQ000000820087 12-04-14 14:34 Completed Submitted 18673858
REQ000000820087 14-11-14 17:45 Submitted Waiting Approval 10
REQ000000820087 14-11-14 17:45 Waiting Approval Planning 1414
REQ000000820087 14-11-14 18:08 Planning In Progress 236248
REQ000000820087 17-11-14 11:46 In Progress Closed 2785446
REQ000000820273 14-11-14 17:34 Submitted Waiting Approval 12

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 2 2 58.8 117.7
Closed 4 4 83.2 332.7
Completed 10 10 174.5 1,744.5
Draft 4 4 0.0 0.0
In Progress 26 26 50.8 1,321.0
Planning 29 29 12.7 368.8
Rejected 4 4 0.0 0.0
Submitted 34 34 0.0 0.7
Waiting Approval 30 30 71.8 2,153.4

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Cancelled Submitted 2 58.8 117.7
Closed Completed 2 130.5 260.9
Submitted 2 35.9 71.7
Completed Closed 1 15.2 15.2
Submitted 9 192.2 1,729.4
Draft Cancelled 1 0.0 0.0
Submitted 1 0.0 0.0
Waiting Approval 2 0.0 0.0
In Progress Cancelled 10 21.7 216.9
Closed 10 54.7 546.5
Completed 4 86.8 347.3
Submitted 2 105.1 210.2
Planning Cancelled 6 25.6 153.7
In Progress 23 9.4 215.1
Rejected Draft 4 0.0 0.0
Submitted Planning 2 0.4 0.7
Waiting Approval 32 0.0 0.0
Waiting Approval Planning 26 82.8 2,153.2
Rejected 4 0.0 0.2