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

1.2% Cancelled 2.3% Closed 25.1% Completed 0.0% Draft 45.7% In Progress 0.0% Pending 16.1% Planning 2.2% Rejected 0.0% Submitted 7.2% 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 340

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
REQ000000622323 10-03-14 14:09 Submitted Waiting Approval 11
REQ000000622323 10-03-14 14:10 Waiting Approval Planning 1640
REQ000000622323 10-03-14 14:37 Planning In Progress 7940628
REQ000000622323 10-06-14 12:21 In Progress Closed 16434053
REQ000000622323 12-02-14 10:20 Completed Submitted 2260178
REQ000000622606 10-03-14 14:11 Submitted Waiting Approval 13
REQ000000622606 10-03-14 14:11 Waiting Approval Planning 1567
REQ000000622606 10-03-14 14:37 Planning In Progress 7941190
REQ000000622606 10-06-14 12:31 In Progress Closed 16433454
REQ000000622606 12-02-14 10:18 Completed Submitted 2260380
REQ000000629357 10-06-14 14:01 Submitted Waiting Approval 15
REQ000000629357 10-06-14 14:01 Waiting Approval Planning 5703
REQ000000629357 10-06-14 15:37 Planning In Progress 2568854
REQ000000629357 10-07-14 9:11 In Progress Closed 13853447
REQ000000629357 12-02-14 10:21 Completed Submitted 10208421
REQ000000629369 10-06-14 14:04 Submitted Waiting Approval 11
REQ000000629369 10-06-14 14:04 Waiting Approval Planning 21224
REQ000000629369 10-06-14 19:58 Planning In Progress 2553329
REQ000000629369 10-07-14 9:13 In Progress Closed 13853287
REQ000000629369 12-02-14 10:22 Completed Submitted 10208533
REQ000000634516 10-07-14 11:19 Submitted Waiting Approval 12
REQ000000634516 10-07-14 11:20 Waiting Approval Planning 1450
REQ000000634516 10-07-14 11:44 Planning In Progress 2663176
REQ000000634516 10-08-14 7:30 In Progress Completed 180298
REQ000000634516 12-08-14 9:35 Completed Closed 11520266
REQ000000659544 13-10-14 9:05 Submitted Waiting Approval 18
REQ000000659544 13-10-14 9:05 Waiting Approval Planning 1223
REQ000000659544 13-10-14 9:26 Planning In Progress 1171
REQ000000659544 13-10-14 9:45 In Progress Closed 8707397
REQ000000659544 22-01-15 4:28 Closed Completed 11270842
REQ000000660584 13-10-14 12:00 Submitted Waiting Approval 14
REQ000000660584 13-10-14 12:00 Waiting Approval Planning 263135
REQ000000660584 16-10-14 13:06 Planning In Progress 676153
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
REQ000000723585 11-03-14 10:06 Planning Submitted 19864262
REQ000000723585 27-10-14 7:57 Submitted Waiting Approval 11
REQ000000723585 27-10-14 7:57 Waiting Approval In Progress 1316071
REQ000000723662 11-03-14 10:05 Planning Submitted 19864194
REQ000000723662 27-10-14 7:55 Submitted Waiting Approval 7
REQ000000723662 27-10-14 7:55 Waiting Approval In Progress 1315611
REQ000000723835 11-03-14 10:05 Planning Submitted 19864077
REQ000000723835 27-10-14 7:53 Submitted Waiting Approval 8
REQ000000723835 27-10-14 7:53 Waiting Approval In Progress 1315031
REQ000000723910 11-03-14 10:04 Planning Submitted 19864007
REQ000000723910 27-10-14 7:51 Submitted Waiting Approval 8
REQ000000723910 27-10-14 7:51 Waiting Approval In Progress 2687204
REQ000000726848 24-11-14 11:43 In Progress Pending 1463844
REQ000000726848 27-10-14 13:53 Submitted Waiting Approval 10
REQ000000726848 27-10-14 13:53 Waiting Approval Planning 151442
REQ000000726848 29-10-14 7:57 Planning In Progress 2259913
REQ000000740348 11-07-14 8:05 In Progress Submitted 9522307
REQ000000740348 29-10-14 13:10 Submitted Waiting Approval 23
REQ000000740348 29-10-14 13:11 Waiting Approval Planning 71954
REQ000000740625 11-07-14 8:08 In Progress Submitted 9521764
REQ000000740625 29-10-14 13:04 Submitted Waiting Approval 32
REQ000000740625 29-10-14 13:05 Waiting Approval Planning 72267
REQ000000740747 11-06-14 12:41 Pending In Progress 6
REQ000000740747 11-06-14 12:41 In Progress Submitted 12100115
REQ000000740747 29-10-14 13:50 Submitted Waiting Approval 11
REQ000000740747 29-10-14 13:50 Waiting Approval Planning 85316
REQ000000745329 30-10-14 13:32 Planning In Progress 1035271
REQ000000745329 30-10-14 9:39 Submitted Waiting Approval 13
REQ000000745329 30-10-14 9:39 Waiting Approval Planning 14017
REQ000000761532 11-03-14 16:41 Submitted Waiting Approval 14
REQ000000761532 11-03-14 16:41 Waiting Approval Completed 59354
REQ000000761532 11-04-14 14:28 In Progress Closed 21697093
REQ000000761532 11-04-14 7:40 Planning In Progress 24460
REQ000000761532 12-03-14 9:10 Completed Planning 2586610
REQ000000778627 11-06-14 10:09 Planning In Progress 8913
REQ000000778627 11-06-14 12:38 In Progress Closed 16433288
REQ000000778627 11-06-14 9:22 Submitted Waiting Approval 17
REQ000000778627 11-06-14 9:23 Waiting Approval Planning 2803
REQ000000778627 12-03-14 9:45 Completed Submitted 7861032
REQ000000780228 11-06-14 13:51 Submitted Waiting Approval 15
REQ000000780228 11-06-14 13:51 Waiting Approval Planning 13395585
REQ000000780228 13-11-14 14:51 Planning Pending 421507

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 2 2 70.1 140.2
Closed 2 2 130.5 260.9
Completed 18 18 156.7 2,820.4
Draft 6 6 0.0 0.2
In Progress 35 35 146.7 5,135.4
Pending 2 2 0.5 1.1
Planning 88 88 20.6 1,810.4
Rejected 5 5 48.8 244.0
Submitted 97 97 0.1 5.5
Waiting Approval 85 85 9.5 808.6

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Cancelled Submitted 2 70.1 140.2
Closed Completed 2 130.5 260.9
Completed Closed 4 156.5 626.1
Planning 1 29.9 29.9
Submitted 13 166.5 2,164.3
Draft Submitted 4 0.0 0.2
Waiting Approval 2 0.0 0.0
In Progress Closed 16 126.4 2,022.1
Completed 4 18.8 75.2
Draft 1 280.1 280.1
Pending 1 16.9 16.9
Submitted 13 210.9 2,741.1
Pending In Progress 2 0.5 1.1
Planning In Progress 83 10.7 885.9
Pending 1 4.9 4.9
Submitted 4 229.9 919.6
Rejected Draft 5 48.8 244.0
Submitted Planning 2 2.7 5.4
Waiting Approval 95 0.0 0.0
Waiting Approval Completed 1 0.7 0.7
In Progress 4 19.2 76.8
Planning 76 8.4 640.2
Rejected 4 22.7 90.9