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

2.3% Cancelled 1.9% Closed 16.9% Completed 0.0% Draft 44.3% In Progress 0.5% Pending 23.8% Planning 0.0% Rejected 0.0% Submitted 10.3% 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 516

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
REQ000000618164 10-02-14 14:54 Submitted Waiting Approval 11
REQ000000618164 10-02-14 14:55 Waiting Approval Completed 154426
REQ000000618164 10-05-14 18:39 Planning In Progress 7914316
REQ000000618164 10-08-14 9:04 In Progress Closed 11175438
REQ000000618164 12-02-14 9:48 Completed Planning 7548638
REQ000000618166 10-02-14 14:56 Submitted Waiting Approval 10
REQ000000618166 10-02-14 14:56 Waiting Approval Completed 155569
REQ000000618166 10-05-14 18:39 Planning In Progress 7914565
REQ000000618166 10-08-14 9:08 In Progress Closed 11175183
REQ000000618166 12-02-14 10:09 Completed Planning 7547433
REQ000000618529 10-02-14 14:53 Submitted Waiting Approval 12
REQ000000618529 10-02-14 14:53 Waiting Approval Completed 154741
REQ000000618529 10-05-14 18:39 Planning In Progress 2647496
REQ000000618529 10-06-14 10:04 In Progress Closed 16442267
REQ000000618529 12-02-14 9:52 Completed Planning 7548406
REQ000000622696 10-03-14 15:34 Submitted Waiting Approval 7
REQ000000622696 10-03-14 15:35 Waiting Approval Planning 30148
REQ000000622696 10-03-14 23:57 Planning In Progress 13191512
REQ000000622696 10-08-14 16:16 In Progress Closed 11149558
REQ000000622696 12-02-14 10:06 Completed Submitted 2266121
REQ000000622729 10-03-14 15:16 Submitted Waiting Approval 7
REQ000000622729 10-03-14 15:16 Waiting Approval Planning 31261
REQ000000622729 10-03-14 23:57 Planning In Progress 13193803
REQ000000622729 10-08-14 16:54 In Progress Closed 11147256
REQ000000622729 12-02-14 10:07 Completed Submitted 2264974
REQ000000622732 10-03-14 15:29 Submitted Waiting Approval 8
REQ000000622732 10-03-14 15:29 Waiting Approval Planning 30503
REQ000000622732 10-03-14 23:57 Planning In Progress 13192837
REQ000000622732 10-08-14 16:38 In Progress Closed 11148227
REQ000000622732 12-02-14 10:06 Completed Submitted 2265757
REQ000000623101 10-03-14 15:42 Submitted Waiting Approval 8
REQ000000623101 10-03-14 15:42 Waiting Approval Planning 29701
REQ000000623101 10-03-14 23:57 Planning In Progress 13195625
REQ000000623101 10-08-14 17:24 In Progress Closed 11145429
REQ000000623101 12-02-14 10:06 Completed Submitted 2266556
REQ000000623104 10-03-14 15:45 Submitted Waiting Approval 10
REQ000000623104 10-03-14 15:45 Waiting Approval Planning 2621683
REQ000000623104 10-04-14 0:00 Planning In Progress 10597568
REQ000000623104 10-08-14 15:46 In Progress Closed 11151312
REQ000000623104 12-02-14 10:07 Completed Submitted 2266717
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
REQ000000675101 12-02-14 10:08 Completed Submitted 21181176
REQ000000675101 15-10-14 13:48 Submitted Waiting Approval 14
REQ000000675101 15-10-14 13:48 Waiting Approval Planning 63025
REQ000000675101 16-10-14 7:18 Planning In Progress 6066
REQ000000675101 16-10-14 9:00 In Progress Closed 5386913
REQ000000675142 12-02-14 10:08 Completed Submitted 21182234
REQ000000675142 15-10-14 14:05 Submitted Waiting Approval 16
REQ000000675142 15-10-14 14:05 Waiting Approval Planning 62781
REQ000000675142 16-10-14 7:31 Planning In Progress 6606
REQ000000675142 16-10-14 9:22 In Progress Closed 5385598
REQ000000675254 12-02-14 10:07 Completed Submitted 21182871
REQ000000675254 15-10-14 14:15 Submitted Waiting Approval 18
REQ000000675254 15-10-14 14:15 Waiting Approval Planning 61232
REQ000000675254 16-10-14 7:16 Planning In Progress 8170
REQ000000675254 16-10-14 9:32 In Progress Closed 5384976
REQ000000675324 12-02-14 10:35 Completed Submitted 21181571
REQ000000675324 15-10-14 14:21 Submitted Waiting Approval 15
REQ000000675324 15-10-14 14:21 Waiting Approval Planning 61061
REQ000000675324 16-10-14 7:19 Planning In Progress 3655
REQ000000675324 16-10-14 8:20 In Progress Closed 5389315
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
REQ000000702114 12-02-14 10:16 Completed Submitted 21697973
REQ000000702114 21-10-14 13:28 Submitted Waiting Approval 11
REQ000000702114 21-10-14 13:29 Waiting Approval Planning 70374
REQ000000702114 22-10-14 9:02 Planning In Progress 1503
REQ000000702114 22-10-14 9:27 In Progress Closed 4866890
REQ000000702256 21-10-14 14:02 Submitted Waiting Approval 17
REQ000000702256 21-10-14 14:02 Waiting Approval Planning 159598
REQ000000702256 23-10-14 10:22 Planning In Progress 20991
REQ000000716798 12-03-14 8:35 Completed Submitted 19523042
REQ000000716798 24-10-14 11:40 Planning In Progress 2694
REQ000000716798 24-10-14 12:25 In Progress Closed 4770095

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 229.8 459.7
Closed 3 3 130.5 391.4
Completed 25 25 135.4 3,383.9
Draft 7 7 0.3 1.9
In Progress 58 58 153.4 8,896.0
Pending 4 4 25.5 102.0
Planning 133 133 35.9 4,773.2
Rejected 6 6 0.0 0.1
Submitted 146 146 0.0 0.0
Waiting Approval 132 132 15.7 2,073.9

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Cancelled Submitted 2 229.8 459.7
Closed Completed 3 130.5 391.4
Completed Planning 3 87.4 262.1
Rejected 1 30.3 30.3
Submitted 21 147.2 3,091.5
Draft Submitted 7 0.3 1.9
In Progress Cancelled 5 22.1 110.7
Closed 26 116.2 3,022.5
Completed 2 95.0 189.9
Pending 2 8.5 17.0
Submitted 23 241.6 5,555.9
Pending In Progress 4 25.5 102.0
Planning Closed 1 48.2 48.2
Completed 1 90.2 90.2
In Progress 127 34.9 4,434.6
Pending 3 0.4 1.3
Submitted 1 198.8 198.8
Rejected Draft 6 0.0 0.1
Submitted Waiting Approval 146 0.0 0.0
Waiting Approval Closed 1 48.8 48.8
Completed 3 1.8 5.4
In Progress 1 49.3 49.3
Planning 122 16.1 1,964.1
Rejected 5 1.2 6.2