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.

7.3% Closed 4.8% Completed 0.0% Draft 12.9% In Progress 8.1% Planning 0.0% Rejected 2.6% Submitted 64.5% 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 117

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
REQ000000761086 11-03-14 16:11 Draft Completed 63227
REQ000000761086 11-04-14 7:51 Submitted Waiting Approval 10
REQ000000761086 11-04-14 7:52 Waiting Approval Planning 2620390
REQ000000761086 11-05-14 15:45 Planning In Progress 2660850
REQ000000761086 11-06-14 10:52 In Progress Closed 16439636
REQ000000761086 12-03-14 9:45 Completed Submitted 2585193
REQ000000764357 11-04-14 8:25 Submitted Waiting Approval 15
REQ000000764357 11-04-14 8:26 Waiting Approval Planning 2618357
REQ000000764357 11-05-14 15:45 Planning In Progress 2664014
REQ000000764357 11-06-14 11:45 In Progress Closed 16436458
REQ000000764357 12-03-14 10:55 Completed Submitted 2583020
REQ000000764435 11-04-14 8:03 Submitted Waiting Approval 12
REQ000000764435 11-04-14 8:04 Waiting Approval Planning 2619681
REQ000000764435 11-05-14 15:45 Planning In Progress 2662838
REQ000000764435 11-06-14 11:25 In Progress Closed 16437637
REQ000000764435 12-03-14 9:44 Completed Submitted 2585929
REQ000000839188 19-11-14 13:16 Submitted Waiting Approval 13
REQ000000839188 19-11-14 13:16 Waiting Approval Planning 13113
REQ000000839188 19-11-14 16:54 Planning In Progress 2341
REQ000000839188 19-11-14 17:33 In Progress Closed 5482499
REQ000000839188 22-01-15 4:28 Closed Completed 11273160
REQ000000839347 19-11-14 12:53 Submitted Waiting Approval 15
REQ000000839347 19-11-14 12:54 Waiting Approval Planning 14432
REQ000000839347 19-11-14 16:54 Planning In Progress 1162
REQ000000839347 19-11-14 17:13 In Progress Closed 5483688
REQ000000839347 22-01-15 4:28 Closed Completed 11273317
REQ000000848430 12-03-14 10:49 Completed Submitted 21892246
REQ000000848430 20-11-14 20:00 Submitted Waiting Approval 18
REQ000000848430 20-11-14 20:00 Waiting Approval Planning 384874
REQ000000848430 25-11-14 18:17 In Progress Closed 1984151
REQ000000848430 25-11-14 6:55 Planning In Progress 40906
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

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 4 4 130.5 521.9
Completed 4 4 85.8 343.1
Draft 3 3 0.2 0.7
In Progress 8 8 115.5 923.6
Planning 31 31 18.7 579.2
Rejected 2 2 0.0 0.0
Submitted 33 33 5.6 184.2
Waiting Approval 32 32 144.8 4,632.2

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Closed Completed 4 130.5 521.9
Completed Submitted 4 85.8 343.1
Draft Completed 1 0.7 0.7
Submitted 1 0.0 0.0
Waiting Approval 1 0.0 0.0
In Progress Closed 8 115.5 923.6
Planning In Progress 31 18.7 579.2
Rejected Draft 2 0.0 0.0
Submitted Planning 1 184.2 184.2
Waiting Approval 32 0.0 0.0
Waiting Approval Planning 30 154.4 4,632.2
Rejected 2 0.0 0.0