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

18.1% Completed 0.0% Draft 81.5% In Progress 0.0% Pending 0.3% Planning 0.0% Rejected 0.0% Submitted 0.1% 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 84 out of 84

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
REQ000000694664 12-02-14 10:13 Completed Submitted 21607281
REQ000000694664 20-10-14 12:15 Submitted Waiting Approval 13
REQ000000694664 20-10-14 12:15 Waiting Approval Planning 3373
REQ000000694664 20-10-14 13:11 Planning In Progress 744
REQ000000694664 20-10-14 13:23 In Progress Closed 5025478
REQ000000694839 12-02-14 10:12 Completed Submitted 21607140
REQ000000694839 20-10-14 12:11 Submitted Waiting Approval 12
REQ000000694839 20-10-14 12:11 Waiting Approval Planning 3570
REQ000000694839 20-10-14 13:11 Planning In Progress 732
REQ000000694839 20-10-14 13:23 In Progress Closed 5025498
REQ000000810274 12-03-14 9:54 Completed Submitted 21247900
REQ000000810274 13-11-14 10:08 Planning In Progress 95463
REQ000000810274 13-11-14 8:06 Submitted Waiting Approval 16
REQ000000810274 13-11-14 8:06 Waiting Approval Planning 7282
REQ000000810274 14-11-14 12:39 In Progress Closed 2954842
REQ000001054469 01-12-15 18:38 Submitted Waiting Approval 5
REQ000001054469 13-01-15 17:09 Planning In Progress 4155
REQ000001054469 13-01-15 18:18 In Progress Submitted 27821994
REQ000001054474 01-12-15 18:40 Submitted Waiting Approval 5
REQ000001054474 13-01-15 17:09 Planning In Progress 3553
REQ000001054474 13-01-15 18:08 In Progress Submitted 27822735
REQ000001054622 01-12-15 17:52 Submitted Waiting Approval 3
REQ000001054622 13-01-15 17:08 Planning In Progress 4533
REQ000001054622 13-01-15 18:24 In Progress Submitted 27818886
REQ000001054692 01-12-15 19:57 Submitted Waiting Approval 6
REQ000001054692 13-01-15 17:10 Planning In Progress 2582
REQ000001054692 13-01-15 17:53 In Progress Submitted 27828241
REQ000001054698 01-12-15 20:00 Submitted Waiting Approval 4
REQ000001054698 13-01-15 17:10 Planning In Progress 1920
REQ000001054698 13-01-15 17:42 In Progress Submitted 27829070
REQ000001054699 01-12-15 20:02 Submitted Waiting Approval 4
REQ000001054699 13-01-15 17:10 Planning In Progress 1367
REQ000001054699 13-01-15 17:33 In Progress Submitted 27829737
REQ000001054706 01-12-15 17:57 Submitted Waiting Approval 7
REQ000001054706 14-01-15 20:56 In Progress Pending 1640
REQ000001054706 14-01-15 21:24 Pending In Progress 64085
REQ000001054706 14-01-15 9:57 Planning In Progress 39597
REQ000001054706 15-01-15 15:12 In Progress Submitted 27657917
REQ000001055044 01-12-15 20:32 Submitted Waiting Approval 3
REQ000001055044 01-12-15 20:32 Waiting Approval Rejected 3480
REQ000001055044 01-12-15 21:30 Rejected Draft 249
REQ000001055044 01-12-15 21:34 Draft Submitted 54
REQ000001055044 01-12-15 21:35 Submitted Waiting Approval 1
REQ000001055044 14-01-15 20:19 In Progress Submitted 27735168
REQ000001055044 14-01-15 9:57 Planning In Progress 37315
REQ000001055238 01-12-15 21:21 Submitted Waiting Approval 7
REQ000001055238 14-01-15 19:41 In Progress Submitted 27740398
REQ000001055238 14-01-15 9:57 Planning In Progress 35015
REQ000001055302 01-12-15 20:05 Submitted Waiting Approval 3
REQ000001055302 01-12-15 20:05 Waiting Approval Rejected 5154
REQ000001055302 01-12-15 21:31 Rejected Draft 190
REQ000001055302 01-12-15 21:34 Draft Submitted 49
REQ000001055302 13-01-15 17:10 Planning In Progress 949
REQ000001055302 13-01-15 17:26 In Progress Submitted 27830346
REQ000001061451 13-01-15 16:58 Submitted Waiting Approval 6
REQ000001061451 13-01-15 16:58 Waiting Approval Planning 788
REQ000001061451 13-01-15 17:11 Planning In Progress 141735
REQ000001061611 13-01-15 16:45 Submitted Waiting Approval 5
REQ000001061611 13-01-15 16:45 Waiting Approval Planning 1523
REQ000001061611 13-01-15 17:11 Planning In Progress 77873
REQ000001064079 14-01-15 8:16 Submitted Waiting Approval 9
REQ000001064079 14-01-15 8:16 Waiting Approval Planning 6104
REQ000001064079 14-01-15 9:58 Planning In Progress 84257
REQ000001064741 14-01-15 8:47 Submitted Waiting Approval 7
REQ000001064741 14-01-15 8:47 Waiting Approval Planning 4284
REQ000001064741 14-01-15 9:59 Planning In Progress 85898
REQ000001064848 14-01-15 9:10 Submitted Waiting Approval 6
REQ000001064848 14-01-15 9:10 Waiting Approval Planning 2930
REQ000001064848 14-01-15 9:59 Planning In Progress 89364
REQ000001065074 14-01-15 9:28 Submitted Waiting Approval 6
REQ000001065074 14-01-15 9:28 Waiting Approval Planning 1846
REQ000001065074 14-01-15 9:59 Planning In Progress 95577
REQ000001065365 14-01-15 10:38 Submitted Waiting Approval 5
REQ000001065365 14-01-15 10:38 Waiting Approval Planning 2294
REQ000001065365 14-01-15 11:16 Planning In Progress 93233
REQ000001065524 14-01-15 10:11 Submitted Waiting Approval 5
REQ000001065524 14-01-15 10:11 Waiting Approval Planning 899
REQ000001065524 14-01-15 10:26 Planning In Progress 95140
REQ000001271803 24-02-15 15:31 Submitted Waiting Approval 7
REQ000001271803 24-02-15 15:31 Waiting Approval Planning 143375
REQ000001271803 26-02-15 7:21 Planning In Progress 10194
REQ000001272002 24-02-15 15:39 Submitted Waiting Approval 6
REQ000001272002 24-02-15 15:39 Waiting Approval Planning 142991
REQ000001272002 26-02-15 7:22 Planning In Progress 21087

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
Completed 3 3 248.7 746.1
Draft 2 2 0.0 0.0
In Progress 14 14 240.5 3,367.2
Pending 1 1 0.7 0.7
Planning 23 23 0.5 11.8
Rejected 2 2 0.0 0.0
Submitted 24 24 0.0 0.0
Waiting Approval 15 15 0.3 3.8

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Completed Submitted 3 248.7 746.1
Draft Submitted 2 0.0 0.0
In Progress Closed 3 50.2 150.5
Pending 1 0.0 0.0
Submitted 10 321.7 3,216.6
Pending In Progress 1 0.7 0.7
Planning In Progress 23 0.5 11.8
Rejected Draft 2 0.0 0.0
Submitted Waiting Approval 24 0.0 0.0
Waiting Approval Planning 13 0.3 3.7
Rejected 2 0.0 0.1