58 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.7% Closed 3.0% Completed 0.0% Draft 17.0% In Progress 0.0% Pending 21.0% Planning 0.0% Rejected 1.6% Submitted 49.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 213

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
REQ000000718653 11-05-14 12:45 In Progress Submitted 14341588
REQ000000718653 12-03-14 9:04 Closed In Progress 5197255
REQ000000718653 24-10-14 12:31 Submitted Waiting Approval 20
REQ000000718653 24-10-14 12:31 Waiting Approval Planning 518666
REQ000000718653 30-10-14 12:36 Planning Completed 1544646
REQ000000723198 11-05-14 12:53 In Progress Submitted 14581587
REQ000000723198 12-03-14 9:04 Closed In Progress 5197750
REQ000000723198 27-10-14 7:19 Submitted Waiting Approval 17
REQ000000723198 27-10-14 7:20 Waiting Approval Planning 278157
REQ000000723198 30-10-14 12:35 Planning Completed 1544621
REQ000000725610 21-11-14 11:08 Planning In Progress 513547
REQ000000725610 27-10-14 10:44 Submitted Waiting Approval 8
REQ000000725610 27-10-14 10:44 Waiting Approval Planning 2161447
REQ000000728704 11-06-14 10:33 In Progress Submitted 11947979
REQ000000728704 27-10-14 17:26 Submitted Waiting Approval 10
REQ000000728704 27-10-14 17:26 Waiting Approval Planning 153879
REQ000000728706 11-06-14 10:28 In Progress Submitted 11948473
REQ000000728706 27-10-14 17:29 Submitted Waiting Approval 9
REQ000000728706 27-10-14 17:29 Waiting Approval Planning 153751
REQ000000739280 11-07-14 13:48 Planning In Progress 7946320
REQ000000739280 11-10-14 13:07 In Progress Submitted 1546182
REQ000000739280 29-10-14 10:36 Submitted Waiting Approval 13
REQ000000739283 11-07-14 13:47 Planning Submitted 9492692
REQ000000739283 29-10-14 10:39 Submitted Waiting Approval 13
REQ000000739283 29-10-14 10:39 Waiting Approval In Progress 1133048
REQ000000740051 11-05-14 13:07 In Progress Closed 2751743
REQ000000740051 12-06-14 9:30 Closed Submitted 12018513
REQ000000740051 29-10-14 11:58 Submitted Waiting Approval 27
REQ000000740051 29-10-14 11:59 Waiting Approval Planning 88634
REQ000000740051 30-10-14 12:36 Planning Completed 1808865
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
REQ000000812725 13-11-14 13:31 Submitted Waiting Approval 33
REQ000000812725 13-11-14 13:31 Waiting Approval Planning 610916
REQ000000812725 20-11-14 15:13 Planning In Progress 80935
REQ000000812725 21-02-15 1:17 Closed Completed 3502801
REQ000000812725 21-11-14 13:42 In Progress Closed 7904100
REQ000000812847 13-11-14 13:36 Submitted Waiting Approval 24
REQ000000812847 13-11-14 13:36 Waiting Approval Planning 610645
REQ000000812847 20-11-14 15:14 Planning In Progress 81243
REQ000000812847 21-02-15 1:17 Closed Completed 3503027
REQ000000812847 21-11-14 13:48 In Progress Closed 7903768
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
REQ000000850226 21-11-14 7:43 Submitted Waiting Approval 16
REQ000000850226 21-11-14 7:43 Waiting Approval Planning 262819
REQ000000850226 24-11-14 8:43 Planning In Progress 93479
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
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

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 9 9 95.8 862.4
Completed 4 4 85.8 343.1
Draft 7 7 0.1 0.8
In Progress 19 19 100.6 1,911.8
Pending 1 1 1.5 1.5
Planning 55 55 43.0 2,362.9
Rejected 2 2 0.0 0.0
Submitted 60 60 3.1 184.2
Waiting Approval 56 56 99.8 5,590.9

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Closed Completed 6 100.5 603.0
In Progress 2 60.2 120.3
Submitted 1 139.1 139.1
Completed Submitted 4 85.8 343.1
Draft Completed 1 0.7 0.7
Submitted 5 0.0 0.1
Waiting Approval 1 0.0 0.0
In Progress Closed 11 103.5 1,138.4
Completed 1 112.2 112.2
Submitted 7 94.5 661.2
Pending In Progress 1 1.5 1.5
Planning Completed 3 18.9 56.7
In Progress 50 43.9 2,196.3
Pending 1 0.1 0.1
Submitted 1 109.9 109.9
Rejected Draft 2 0.0 0.0
Submitted Planning 1 184.2 184.2
Waiting Approval 59 0.0 0.0
Waiting Approval In Progress 1 13.1 13.1
Planning 53 105.2 5,577.8
Rejected 2 0.0 0.0