38 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.6% Closed 0.0% Draft 2.8% In Progress 0.1% Pending 15.6% Planning 0.0% Rejected 2.5% Submitted 75.3% 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 130

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
REQ000000625909 10-06-14 6:43 Submitted Waiting Approval 6
REQ000000625909 10-06-14 6:43 Waiting Approval Planning 8001440
REQ000000625909 10-09-14 21:20 Planning Pending 2829249
REQ000000625909 13-10-14 15:15 Pending In Progress 936693
REQ000000900576 12-02-14 14:44 Submitted Waiting Approval 13
REQ000000900576 12-02-14 14:44 Waiting Approval Planning 18336538
REQ000000900576 12-09-14 20:13 Planning In Progress 2567732
REQ000000907078 12-03-14 14:20 Submitted Waiting Approval 44
REQ000000907078 12-03-14 14:20 Waiting Approval Planning 18487633
REQ000000907078 12-10-14 13:47 Planning In Progress 1798
REQ000000907178 12-03-14 14:15 Submitted Waiting Approval 56
REQ000000907178 12-03-14 14:16 Waiting Approval Planning 18487877
REQ000000907178 12-10-14 13:47 Planning In Progress 824
REQ000000907288 12-03-14 14:45 Submitted Waiting Approval 49
REQ000000907288 12-03-14 14:46 Waiting Approval Planning 18486088
REQ000000907288 12-10-14 13:47 Planning In Progress 2598
REQ000000907422 12-03-14 14:12 Submitted Waiting Approval 48
REQ000000907422 12-03-14 14:13 Waiting Approval Rejected 764
REQ000000907422 12-03-14 14:26 Rejected Draft 994
REQ000000907422 12-03-14 14:42 Draft Waiting Approval 19
REQ000000907422 12-03-14 14:43 Submitted Planning 15917391
REQ000000907422 12-09-14 20:12 Planning In Progress 2568102
REQ000000907467 12-03-14 14:46 Submitted Waiting Approval 40
REQ000000907467 12-03-14 14:47 Waiting Approval Rejected 345
REQ000000907467 12-03-14 14:53 Rejected Draft 19
REQ000000907467 12-03-14 14:53 Draft Submitted 14
REQ000000907467 12-03-14 14:53 Submitted Waiting Approval 1
REQ000000907467 12-03-14 14:53 Waiting Approval Planning 15916763
REQ000000907467 12-09-14 20:13 Planning In Progress 2574212
REQ000000907520 12-03-14 14:22 Submitted Waiting Approval 39
REQ000000907520 12-03-14 14:22 Waiting Approval Planning 18487476
REQ000000907520 12-10-14 13:47 Planning In Progress 2322
REQ000000907720 12-03-14 14:51 Submitted Waiting Approval 43
REQ000000907720 12-03-14 14:52 Waiting Approval Planning 15916872
REQ000000907720 12-09-14 20:13 Planning In Progress 2574760
REQ000000907809 12-03-14 14:50 Submitted Waiting Approval 37
REQ000000907809 12-03-14 14:50 Waiting Approval Planning 18485814
REQ000000907809 12-10-14 13:47 Planning In Progress 5723
REQ000000907809 12-10-14 15:22 In Progress Closed 8773548
REQ000000907809 22-01-15 4:28 Closed Completed 11273333
REQ000000908899 12-03-14 19:59 Submitted Waiting Approval 43
REQ000000908899 12-03-14 20:00 Waiting Approval Planning 15898214
REQ000000908899 12-09-14 20:10 Planning In Progress 2575716
REQ000000909069 12-03-14 19:21 Submitted Waiting Approval 36
REQ000000909069 12-03-14 19:22 Waiting Approval Planning 15900682
REQ000000909069 12-09-14 20:13 Planning In Progress 2585019
REQ000000909069 12-10-14 18:17 In Progress Closed 8763074
REQ000000909069 22-01-15 4:28 Closed Completed 11273352
REQ000000909099 12-03-14 20:02 Submitted Waiting Approval 34
REQ000000909099 12-03-14 20:03 Waiting Approval Planning 15898167
REQ000000909099 12-09-14 20:12 Planning In Progress 2576121
REQ000000909365 12-03-14 19:55 Submitted Waiting Approval 40
REQ000000909365 12-03-14 19:55 Waiting Approval Planning 15898472
REQ000000909365 12-09-14 20:10 Planning In Progress 2575126
REQ000000909452 12-03-14 20:06 Submitted Waiting Approval 37
REQ000000909452 12-03-14 20:06 Waiting Approval Planning 15897952
REQ000000909452 12-09-14 20:12 Planning In Progress 2581520
REQ000000909454 12-03-14 20:11 Submitted Waiting Approval 35
REQ000000909454 12-03-14 20:12 Waiting Approval Planning 18466576
REQ000000909454 12-10-14 13:48 Planning In Progress 14398
REQ000000909528 12-03-14 20:15 Submitted Waiting Approval 35
REQ000000909528 12-03-14 20:16 Waiting Approval Planning 15897391
REQ000000909528 12-09-14 20:12 Planning In Progress 2584377
REQ000000909607 12-03-14 20:08 Submitted Waiting Approval 33
REQ000000909607 12-03-14 20:09 Waiting Approval Planning 18466773
REQ000000909607 12-10-14 13:49 Planning In Progress 13372
REQ000000909617 12-03-14 20:40 Submitted Waiting Approval 31
REQ000000909617 12-03-14 20:41 Waiting Approval Planning 15895966
REQ000000909617 12-09-14 20:13 Planning In Progress 2583311
REQ000000909723 12-03-14 21:23 Submitted Waiting Approval 12
REQ000000909723 12-03-14 21:23 Waiting Approval Planning 26451533
REQ000000909723 13-01-15 1:02 Planning In Progress 139779
REQ000000909810 12-03-14 20:19 Submitted Waiting Approval 34
REQ000000909810 12-03-14 20:19 Waiting Approval Planning 15897186
REQ000000909810 12-09-14 20:12 Planning In Progress 2584903
REQ000000912581 12-04-14 10:39 Submitted Waiting Approval 30
REQ000000912581 12-04-14 10:40 Waiting Approval Planning 24377911
REQ000000912581 19-01-15 14:18 Planning In Progress 322550
REQ000000912735 12-04-14 10:34 Submitted Waiting Approval 37
REQ000000912735 12-04-14 10:34 Waiting Approval Planning 24378233
REQ000000912735 19-01-15 14:18 Planning In Progress 328523
REQ000000915494 12-04-14 18:16 Submitted Waiting Approval 10
REQ000000915494 12-04-14 18:17 Waiting Approval Planning 23784343
REQ000000915494 13-01-15 1:02 Planning In Progress 142677
REQ000000915832 12-04-14 18:23 Submitted Waiting Approval 9
REQ000000915832 12-04-14 18:23 Waiting Approval Planning 23783966
REQ000000915832 13-01-15 1:02 Planning In Progress 144242
REQ000000959154 13-01-15 1:05 Planning In Progress 227846
REQ000000959154 15-12-14 10:17 Submitted Waiting Approval 12
REQ000000959154 15-12-14 10:17 Waiting Approval Planning 2472478
REQ000000959232 15-12-14 9:56 Submitted Waiting Approval 10
REQ000000959232 15-12-14 9:56 Waiting Approval Planning 3039743
REQ000000959232 19-01-15 14:18 Planning In Progress 607813
REQ000000959304 13-01-15 1:05 Planning In Progress 289206
REQ000000959304 15-12-14 9:45 Submitted Waiting Approval 10
REQ000000959304 15-12-14 9:45 Waiting Approval Planning 2474375
REQ000000967962 13-01-15 1:05 Planning In Progress 289636
REQ000000967962 16-12-14 15:19 Submitted Waiting Approval 6
REQ000000967962 16-12-14 15:19 Waiting Approval Planning 2367952
REQ000000967969 13-01-15 1:05 Planning In Progress 288750

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 2 2 130.5 261.0
Draft 6 6 0.0 0.1
In Progress 2 2 101.5 203.0
Pending 1 1 10.8 10.8
Planning 38 38 30.0 1,139.5
Rejected 2 2 0.0 0.0
Submitted 40 40 4.6 184.2
Waiting Approval 39 39 140.9 5,496.3

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Closed Completed 2 130.5 261.0
Draft Submitted 5 0.0 0.1
Waiting Approval 1 0.0 0.0
In Progress Closed 2 101.5 203.0
Pending In Progress 1 10.8 10.8
Planning In Progress 37 29.9 1,106.8
Pending 1 32.7 32.7
Rejected Draft 2 0.0 0.0
Submitted Planning 1 184.2 184.2
Waiting Approval 39 0.0 0.0
Waiting Approval Planning 37 148.5 5,496.3
Rejected 2 0.0 0.0