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

8.6% Closed 18.5% Completed 0.0% Draft 30.1% In Progress 6.9% Pending 31.2% Planning 0.0% Rejected 0.0% Submitted 4.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 204

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
REQ000000610717 10-01-14 11:13 Planning Pending 188
REQ000000610717 10-01-14 11:16 Pending Cancelled 23859847
REQ000000610717 10-01-14 8:57 Submitted Waiting Approval 16
REQ000000610717 10-01-14 8:57 Waiting Approval Planning 8141
REQ000000611023 10-01-14 9:42 Submitted Waiting Approval 21
REQ000000611023 10-01-14 9:43 Waiting Approval Planning 2652416
REQ000000611023 10-02-14 2:29 Planning Pending 16010
REQ000000611023 10-02-14 6:56 Pending In Progress 21196714
REQ000000611023 13-10-14 14:55 In Progress Completed 1204222
REQ000000611023 26-02-15 1:42 Closed Completed 18873661
REQ000000611023 27-10-14 13:25 Completed In Progress 170129
REQ000000611023 29-10-14 12:41 In Progress Closed 10328469
REQ000000625762 10-06-14 12:07 Planning Pending 10811155
REQ000000625762 10-06-14 6:25 Submitted Waiting Approval 9
REQ000000625762 10-06-14 6:26 Waiting Approval Planning 20506
REQ000000625762 13-10-14 15:13 Pending In Progress 1276426
REQ000000684116 17-10-14 5:57 Submitted Waiting Approval 7
REQ000000684116 17-10-14 5:57 Waiting Approval Planning 1411
REQ000000684116 17-10-14 6:21 Planning In Progress 539796
REQ000000739274 29-10-14 10:31 Submitted Waiting Approval 16
REQ000000739274 29-10-14 10:31 Waiting Approval Planning 17444
REQ000000739274 29-10-14 15:22 Planning In Progress 1114892
REQ000000752399 11-04-14 17:23 Planning Submitted 17523699
REQ000000752399 31-10-14 13:05 Submitted Waiting Approval 11
REQ000000752399 31-10-14 13:05 Waiting Approval In Progress 939698
REQ000000752485 11-04-14 17:23 Planning In Progress 5265455
REQ000000752485 11-06-14 16:01 In Progress Submitted 12258460
REQ000000752485 31-10-14 13:08 Submitted Waiting Approval 13
REQ000000752487 11-04-14 17:23 Planning Submitted 17524017
REQ000000752487 31-10-14 13:10 Submitted Waiting Approval 10
REQ000000752487 31-10-14 13:10 Waiting Approval In Progress 939143
REQ000000752655 11-04-14 17:23 Planning Submitted 17523561
REQ000000752655 31-10-14 13:02 Submitted Waiting Approval 13
REQ000000752655 31-10-14 13:02 Waiting Approval In Progress 938807
REQ000000753721 11-10-14 10:31 Planning Submitted 1746737
REQ000000753721 31-10-14 15:43 Submitted Waiting Approval 9
REQ000000753721 31-10-14 15:43 Waiting Approval In Progress 1093412
REQ000000753725 11-10-14 10:31 Planning Submitted 1746845
REQ000000753725 31-10-14 15:45 Submitted Waiting Approval 10
REQ000000753725 31-10-14 15:46 Waiting Approval In Progress 1093486
REQ000000753924 11-10-14 10:31 Planning Submitted 1746496
REQ000000753924 31-10-14 15:40 Submitted Waiting Approval 11
REQ000000753924 31-10-14 15:40 Waiting Approval In Progress 1096130
REQ000000753936 11-10-14 10:32 Planning Submitted 1746952
REQ000000753936 31-10-14 15:47 Submitted Waiting Approval 8
REQ000000753936 31-10-14 15:48 Waiting Approval In Progress 1095816
REQ000000760878 11-03-14 15:44 Submitted Waiting Approval 27
REQ000000760878 12-01-14 11:13 In Progress Submitted 5027473
REQ000000760878 12-01-14 9:52 Planning In Progress 4823
REQ000000764814 11-04-14 10:57 In Progress Closed 24687107
REQ000000764814 11-04-14 8:42 Submitted Waiting Approval 10
REQ000000764814 11-04-14 8:42 Waiting Approval Planning 2464
REQ000000764814 11-04-14 9:23 Planning In Progress 5610
REQ000000764814 22-01-15 4:28 Closed Completed 11270584
REQ000000764823 11-04-14 11:03 In Progress Closed 24686698
REQ000000764823 11-04-14 8:45 Submitted Waiting Approval 12
REQ000000764823 11-04-14 8:45 Waiting Approval Planning 2249
REQ000000764823 11-04-14 9:22 Planning In Progress 6060
REQ000000764823 22-01-15 4:28 Closed Completed 11270238
REQ000000799804 11-11-14 13:20 Submitted Waiting Approval 14
REQ000000799804 11-11-14 13:20 Waiting Approval Planning 856700
REQ000000799804 12-03-14 10:54 Completed Submitted 21090344
REQ000000799804 21-11-14 11:19 Planning In Progress 5133
REQ000000799804 21-11-14 12:44 In Progress Closed 2349716
REQ000000834137 18-11-14 15:47 Submitted Waiting Approval 13
REQ000000834137 18-11-14 15:47 Waiting Approval Planning 123123
REQ000000834137 20-11-14 1:59 Planning In Progress 647875
REQ000000835392 12-03-14 10:54 Completed Submitted 21725550
REQ000000835392 18-11-14 21:46 Submitted Waiting Approval 11
REQ000000835392 18-11-14 21:46 Waiting Approval Rejected 34825
REQ000000835392 19-11-14 14:24 Draft Submitted 27
REQ000000835392 19-11-14 14:24 Submitted Waiting Approval 1
REQ000000835392 19-11-14 14:24 Waiting Approval Planning 171512
REQ000000835392 19-11-14 7:27 Rejected Draft 25023
REQ000000835392 21-11-14 14:03 Planning In Progress 18098
REQ000000835392 21-11-14 19:05 In Progress Closed 2326882
REQ000000835532 12-03-14 10:53 Completed Submitted 21725820
REQ000000835532 18-11-14 21:50 Submitted Waiting Approval 13
REQ000000835532 18-11-14 21:51 Waiting Approval Planning 231110
REQ000000835532 21-11-14 14:02 Planning In Progress 17337
REQ000000835532 21-11-14 18:51 In Progress Closed 2327668
REQ000000835536 12-03-14 10:53 Completed Submitted 21726063
REQ000000835536 18-11-14 21:54 Submitted Waiting Approval 11
REQ000000835536 18-11-14 21:54 Waiting Approval Planning 230894
REQ000000835536 21-11-14 14:03 Planning In Progress 16522
REQ000000835536 21-11-14 18:38 In Progress Closed 2328471
REQ000000835623 12-03-14 10:55 Completed Submitted 21726191
REQ000000835623 18-11-14 21:58 Submitted Waiting Approval 13
REQ000000835623 18-11-14 21:58 Waiting Approval Planning 230685
REQ000000835623 21-11-14 14:03 Planning In Progress 15225
REQ000000835623 21-11-14 18:16 In Progress Closed 2329767
REQ000000858816 23-01-15 4:30 Closed Completed 13758997
REQ000000858816 24-11-14 9:51 Submitted Waiting Approval 29
REQ000000858816 24-11-14 9:51 Waiting Approval Planning 186023
REQ000000858816 26-11-14 13:32 Planning In Progress 76119
REQ000000858816 27-11-14 10:40 In Progress Closed 4902561
REQ000000880796 12-01-14 9:49 In Progress Submitted 27587164
REQ000000880796 27-11-14 16:55 Submitted Waiting Approval 23
REQ000000880796 27-11-14 16:55 Waiting Approval Planning 55407
REQ000000880796 28-11-14 8:19 Planning Completed 7782654

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 5 5 133.6 667.9
Completed 9 9 160.0 1,440.0
Draft 2 2 0.0 0.0
In Progress 19 19 123.5 2,347.1
Pending 3 3 178.8 536.3
Planning 52 52 46.8 2,433.9
Rejected 2 2 0.1 0.3
Submitted 57 57 0.0 0.0
Waiting Approval 55 55 6.7 368.9

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Closed Completed 4 159.6 638.6
In Progress 1 29.3 29.3
Completed In Progress 1 2.0 2.0
Planning 3 62.7 188.1
Submitted 5 250.0 1,249.9
Draft Submitted 2 0.0 0.0
In Progress Closed 11 102.7 1,130.1
Completed 1 13.9 13.9
Submitted 7 171.9 1,203.1
Pending Cancelled 1 276.2 276.2
In Progress 2 130.1 260.1
Planning Cancelled 2 162.5 325.0
Closed 1 92.6 92.6
Completed 2 90.1 180.2
In Progress 37 27.6 1,021.5
Pending 3 41.8 125.3
Submitted 7 98.5 689.3
Rejected Draft 2 0.1 0.3
Submitted Waiting Approval 57 0.0 0.0
Waiting Approval Completed 3 17.0 51.0
In Progress 7 11.9 83.3
Planning 43 5.4 234.2
Rejected 2 0.2 0.4