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

5.3% Cancelled 7.3% Closed 37.8% Completed 0.0% Draft 27.3% In Progress 0.3% Pending 12.4% Planning 0.0% Rejected 0.0% Submitted 9.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 1,044

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
REQ000000609793 10-01-14 7:02 Submitted Waiting Approval 16
REQ000000609793 10-01-14 7:02 Waiting Approval Completed 2862945
REQ000000609793 12-02-14 10:18 Completed Planning 21174035
REQ000000609793 15-10-14 11:58 Planning In Progress 1415
REQ000000609793 15-10-14 12:22 In Progress Closed 5461173
REQ000000609958 10-01-14 7:04 Submitted Waiting Approval 19
REQ000000609958 10-01-14 7:05 Waiting Approval Planning 3216
REQ000000609958 10-01-14 7:58 Planning In Progress 2130
REQ000000609958 10-01-14 8:34 In Progress Completed 2855126
REQ000000609958 12-02-14 9:39 Completed Closed 26638933
REQ000000634352 10-07-14 11:38 Submitted Waiting Approval 10
REQ000000634352 10-07-14 11:39 Waiting Approval Planning 36591
REQ000000634352 10-07-14 21:48 Planning In Progress 2621747
REQ000000634352 10-08-14 6:04 In Progress Closed 11186241
REQ000000634352 12-02-14 10:12 Completed Submitted 12792405
REQ000000671704 12-02-14 10:02 Completed Submitted 21152701
REQ000000671704 15-10-14 13:05 Planning In Progress 802
REQ000000671704 15-10-14 13:18 In Progress Closed 5457795
REQ000000671704 15-10-14 5:47 Submitted Waiting Approval 10
REQ000000671704 15-10-14 5:47 Waiting Approval Planning 26256
REQ000000672251 12-03-14 9:52 Completed Submitted 18740722
REQ000000672251 15-10-14 7:37 Submitted Waiting Approval 11
REQ000000672251 15-10-14 7:38 Waiting Approval Planning 740409
REQ000000672251 23-10-14 21:18 Planning In Progress 41718
REQ000000672251 24-10-14 8:53 In Progress Closed 4782790
REQ000000672259 15-10-14 7:39 Submitted Waiting Approval 11
REQ000000672259 15-10-14 7:39 Waiting Approval Planning 740295
REQ000000672259 23-10-14 21:17 Planning In Progress 49009
REQ000000672340 15-10-14 7:47 Submitted Waiting Approval 9
REQ000000672340 15-10-14 7:47 Waiting Approval Planning 739832
REQ000000672340 23-10-14 21:17 Planning In Progress 44193
REQ000000672608 15-10-14 7:41 Submitted Waiting Approval 13
REQ000000672608 15-10-14 7:41 Waiting Approval Planning 740193
REQ000000672608 23-10-14 21:17 Planning In Progress 43394
REQ000000672621 15-10-14 7:49 Submitted Waiting Approval 15
REQ000000672621 15-10-14 7:49 Waiting Approval Planning 739702
REQ000000672621 23-10-14 21:17 Planning In Progress 45512
REQ000000672622 15-10-14 7:51 Submitted Waiting Approval 12
REQ000000672622 15-10-14 7:51 Waiting Approval Planning 739613
REQ000000672622 23-10-14 21:18 Planning In Progress 49340
REQ000000672626 15-10-14 7:52 Submitted Waiting Approval 12
REQ000000672626 15-10-14 7:52 Waiting Approval Planning 739489
REQ000000672626 23-10-14 21:17 Planning In Progress 42361
REQ000000678384 16-10-14 13:06 Planning In Progress 61660
REQ000000678384 16-10-14 7:31 Submitted Waiting Approval 13
REQ000000678384 16-10-14 7:31 Waiting Approval Planning 20113
REQ000000678620 16-10-14 13:06 Planning In Progress 61655
REQ000000678620 16-10-14 7:28 Submitted Waiting Approval 13
REQ000000678620 16-10-14 7:28 Waiting Approval Planning 20271
REQ000000679147 12-02-14 10:08 Completed Submitted 21249493
REQ000000679147 16-10-14 11:19 Planning In Progress 3297
REQ000000679147 16-10-14 12:14 In Progress Closed 5375256
REQ000000679147 16-10-14 8:46 Submitted Waiting Approval 10
REQ000000679147 16-10-14 8:46 Waiting Approval Planning 9158
REQ000000680704 16-10-14 12:21 Submitted Waiting Approval 13
REQ000000680704 16-10-14 12:21 Waiting Approval Planning 323071
REQ000000680704 20-10-14 6:05 Planning In Progress 108882
REQ000000680704 21-10-14 12:20 In Progress Completed 514373
REQ000000680704 27-10-14 11:13 Completed Closed 3877280
REQ000000682174 16-10-14 16:52 Submitted Waiting Approval 10
REQ000000682174 16-10-14 16:52 Waiting Approval Planning 320927
REQ000000682174 20-10-14 10:01 Planning In Progress 18830
REQ000000682508 16-10-14 16:59 Submitted Waiting Approval 10
REQ000000682508 16-10-14 16:59 Waiting Approval Cancelled 418341
REQ000000685097 12-02-14 10:11 Completed Submitted 21338765
REQ000000685097 17-10-14 13:56 Planning In Progress 236365
REQ000000685097 17-10-14 9:37 Submitted Waiting Approval 11
REQ000000685097 17-10-14 9:38 Waiting Approval Planning 15535
REQ000000685097 20-10-14 7:36 In Progress Closed 5046335
REQ000000685899 12-02-14 10:10 Completed Submitted 21348755
REQ000000685899 17-10-14 12:23 Submitted Waiting Approval 6
REQ000000685899 17-10-14 12:23 Waiting Approval Planning 5642
REQ000000685899 17-10-14 13:57 Planning In Progress 241126
REQ000000685899 20-10-14 8:56 In Progress Closed 5041535
REQ000000686119 12-02-14 10:10 Completed Submitted 21346686
REQ000000686119 17-10-14 11:48 Submitted Waiting Approval 12
REQ000000686119 17-10-14 11:48 Waiting Approval Planning 7707
REQ000000686119 17-10-14 13:57 Planning In Progress 238109
REQ000000686119 20-10-14 8:05 In Progress Closed 5044570
REQ000000686142 12-02-14 10:11 Completed Submitted 21347284
REQ000000686142 17-10-14 11:59 Submitted Waiting Approval 16
REQ000000686142 17-10-14 11:59 Waiting Approval Planning 7035
REQ000000686142 17-10-14 13:57 Planning In Progress 238899
REQ000000686142 20-10-14 8:18 In Progress Closed 5043794
REQ000000686528 12-02-14 10:11 Completed Submitted 21350397
REQ000000686528 17-10-14 12:51 Submitted Waiting Approval 10
REQ000000686528 17-10-14 12:51 Waiting Approval Planning 3969
REQ000000686528 17-10-14 13:57 Planning In Progress 242632
REQ000000686528 20-10-14 9:21 In Progress Closed 5040036
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
REQ000000696560 20-10-14 15:44 Submitted Waiting Approval 11

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 10 10 204.1 2,041.4
Closed 21 21 134.5 2,824.0
Completed 79 79 184.6 14,584.0
Draft 8 8 0.6 4.6
In Progress 133 133 79.3 10,549.1
Pending 3 3 44.3 132.9
Planning 252 252 19.0 4,794.1
Rejected 5 5 0.1 0.3
Submitted 277 277 0.0 0.0
Waiting Approval 256 256 14.3 3,657.4

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Cancelled Planning 1 182.0 182.0
Submitted 9 206.6 1,859.5
Closed Completed 19 140.5 2,668.8
In Progress 2 77.6 155.2
Completed Closed 12 61.7 739.9
In Progress 3 0.1 0.2
Planning 4 161.5 646.0
Submitted 60 220.0 13,197.8
Draft Submitted 8 0.6 4.6
In Progress Cancelled 13 27.0 350.6
Closed 67 67.2 4,502.8
Completed 28 28.1 786.9
In Progress 1 0.0 0.0
Pending 2 0.0 0.0
Submitted 22 223.1 4,908.8
Pending Draft 1 132.1 132.1
In Progress 2 0.4 0.7
Planning Cancelled 14 28.5 399.3
Closed 3 14.9 44.8
Completed 1 31.8 31.8
In Progress 233 17.7 4,119.3
Submitted 1 198.8 198.8
Rejected Draft 5 0.1 0.3
Submitted Waiting Approval 277 0.0 0.0
Waiting Approval Cancelled 11 42.5 467.6
Closed 6 30.5 183.1
Completed 4 41.1 164.2
In Progress 1 49.3 49.3
Planning 227 12.2 2,761.8
Rejected 7 4.5 31.3