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

3.4% Cancelled 6.7% Closed 0.9% Completed 0.0% Draft 29.3% In Progress 0.1% Pending 26.1% Planning 1.7% Rejected 2.7% Submitted 29.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 100 out of 331

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
REQ000000693587 20-10-14 12:32 Planning In Progress 870777
REQ000000693587 20-10-14 9:48 Submitted Waiting Approval 22
REQ000000693587 20-10-14 9:49 Waiting Approval Planning 9802
REQ000000693587 30-10-14 14:25 In Progress Completed 46852
REQ000000693587 31-10-14 3:26 Completed Closed 1314179
REQ000000694061 11-10-14 8:03 Closed Submitted 788569
REQ000000694061 20-10-14 11:06 Submitted Waiting Approval 25
REQ000000694061 20-10-14 11:06 Waiting Approval Planning 4972
REQ000000694061 20-10-14 12:29 Planning In Progress 266747
REQ000000694061 23-10-14 14:35 In Progress Completed 99513
REQ000000759276 11-03-14 12:35 Submitted Waiting Approval 26
REQ000000759276 11-03-14 12:35 Waiting Approval In Progress 21776443
REQ000000759276 18-11-14 13:36 In Progress Planning 1973053
REQ000000759382 11-03-14 12:23 Submitted Waiting Approval 21
REQ000000759382 11-03-14 12:24 Waiting Approval Planning 5288920
REQ000000759382 11-05-14 17:32 Planning In Progress 13208737
REQ000000759646 11-03-14 12:29 Submitted Waiting Approval 28
REQ000000759646 11-03-14 12:30 Waiting Approval In Progress 21777395
REQ000000759646 18-11-14 13:46 In Progress Planning 1972446
REQ000000759707 11-03-14 12:13 Submitted Waiting Approval 34
REQ000000759707 11-03-14 12:13 Waiting Approval Planning 5290106
REQ000000759707 11-05-14 17:42 Planning In Progress 13208029
REQ000000759729 11-03-14 12:32 Submitted Waiting Approval 23
REQ000000759729 11-03-14 12:32 Waiting Approval In Progress 21776892
REQ000000759729 18-11-14 13:41 In Progress Planning 1972776
REQ000000761233 11-03-14 15:20 Submitted Waiting Approval 35
REQ000000761233 11-03-14 15:20 Waiting Approval Planning 21317799
REQ000000761233 13-11-14 8:57 Planning In Progress 1137984
REQ000000761233 23-01-15 4:30 Closed Completed 13758428
REQ000000761233 26-11-14 13:03 In Progress Closed 4980393
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
REQ000000780228 18-11-14 11:56 Pending In Progress 92471
REQ000000786320 11-07-14 14:22 Submitted Waiting Approval 29
REQ000000786320 11-07-14 14:23 Waiting Approval Planning 961
REQ000000786320 11-07-14 14:39 Planning In Progress 601
REQ000000786520 11-07-14 14:32 Submitted Waiting Approval 10
REQ000000786520 11-07-14 14:32 Waiting Approval Planning 7944120
REQ000000786520 11-10-14 13:14 Planning In Progress 2833344
REQ000000816747 12-05-14 9:21 Closed Submitted 16066525
REQ000000816747 14-11-14 12:57 Planning Completed 462446
REQ000000816747 14-11-14 8:16 Submitted Waiting Approval 30
REQ000000816747 14-11-14 8:17 Waiting Approval Planning 16834
REQ000000816893 12-05-14 9:21 Closed Submitted 16067475
REQ000000816893 14-11-14 12:58 Planning Completed 462922
REQ000000816893 14-11-14 8:32 Submitted Waiting Approval 19
REQ000000816893 14-11-14 8:32 Waiting Approval Planning 15929
REQ000000816951 12-05-14 9:21 Closed Submitted 16068089
REQ000000816951 14-11-14 13:05 Planning Completed 462674
REQ000000816951 14-11-14 8:42 Submitted Waiting Approval 21
REQ000000816951 14-11-14 8:43 Waiting Approval Planning 15712
REQ000000817008 12-05-14 9:21 Closed Submitted 16067170
REQ000000817008 14-11-14 13:07 Planning Completed 461989
REQ000000817008 14-11-14 8:27 Submitted Waiting Approval 27
REQ000000817008 14-11-14 8:28 Waiting Approval Planning 16741
REQ000000872872 12-01-14 8:25 In Progress Submitted 27482284
REQ000000872872 26-11-14 10:23 Submitted Waiting Approval 22
REQ000000872872 26-11-14 10:23 Waiting Approval Planning 3360
REQ000000872928 26-11-14 10:16 Submitted Waiting Approval 35
REQ000000872928 26-11-14 10:16 Waiting Approval Cancelled 142
REQ000000874236 12-02-14 8:03 Planning In Progress 2426934
REQ000000874236 12-03-14 10:12 In Progress Submitted 22389084
REQ000000874236 26-11-14 13:23 Submitted Waiting Approval 24
REQ000000874307 12-02-14 8:02 Planning In Progress 2427676
REQ000000874307 12-03-14 10:23 In Progress Submitted 22387873
REQ000000874307 26-11-14 13:14 Submitted Waiting Approval 18
REQ000000874413 12-02-14 8:02 Planning In Progress 2426504
REQ000000874413 12-03-14 10:04 In Progress Submitted 22390988
REQ000000874413 26-11-14 13:47 Submitted Waiting Approval 20
REQ000000874501 12-01-14 22:03 Planning In Progress 5055278
REQ000000874501 12-03-14 10:18 In Progress Submitted 22388558
REQ000000874501 26-11-14 13:20 Submitted Waiting Approval 14
REQ000000874607 12-01-14 22:03 Planning In Progress 5052833
REQ000000874607 12-03-14 9:37 In Progress Submitted 22392797
REQ000000874607 26-11-14 13:51 Submitted Waiting Approval 18
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
REQ000000881421 12-01-14 9:54 In Progress Submitted 27587352
REQ000000881421 27-11-14 17:03 Submitted Waiting Approval 25
REQ000000881421 27-11-14 17:03 Waiting Approval Planning 54838
REQ000000881421 28-11-14 8:17 Planning Completed 7782620
REQ000000885201 28-11-14 13:28 Submitted Waiting Approval 17
REQ000000891699 12-01-14 14:28 Submitted Waiting Approval 9
REQ000000893125 12-01-14 16:41 Submitted Waiting Approval 24
REQ000000893125 12-01-14 16:42 Waiting Approval Planning 10368520
REQ000000893125 12-05-14 16:50 Planning In Progress 15894816
REQ000000913378 12-04-14 12:50 Submitted Waiting Approval 13
REQ000000913378 12-04-14 12:50 Waiting Approval Planning 2579372
REQ000000913378 12-05-14 9:20 Planning In Progress 15921546
REQ000000913802 12-04-14 12:48 Submitted Waiting Approval 14
REQ000000913802 12-04-14 12:48 Waiting Approval Planning 2574842
REQ000000913802 12-05-14 8:02 Planning In Progress 15916190
REQ000000913997 12-04-14 14:35 Submitted Waiting Approval 14
REQ000000913997 12-04-14 14:35 Waiting Approval Planning 25137905
REQ000000913997 28-01-15 13:20 Planning In Progress 8112512
REQ000000914548 12-04-14 15:15 Submitted Waiting Approval 15
REQ000000914548 12-04-14 15:15 Waiting Approval Cancelled 10543259

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 251.1 502.1
Closed 9 9 109.6 986.6
Completed 4 4 32.3 129.2
Draft 5 5 0.0 0.0
In Progress 25 25 172.3 4,306.3
Pending 3 3 2.7 8.1
Planning 75 75 51.1 3,829.7
Rejected 5 5 51.2 255.8
Submitted 117 117 3.4 398.1
Waiting Approval 86 86 49.7 4,276.1

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Cancelled Submitted 2 251.1 502.1
Closed Completed 2 85.4 170.8
Planning 1 28.2 28.2
Submitted 6 131.3 787.5
Completed Closed 2 30.8 61.6
Planning 2 33.8 67.6
Draft Submitted 2 0.0 0.0
Waiting Approval 3 0.0 0.0
In Progress Closed 2 58.0 116.0
Completed 4 40.2 160.7
Planning 3 22.8 68.5
Submitted 16 247.6 3,961.0
Pending In Progress 3 2.7 8.1
Planning Completed 6 33.6 201.6
In Progress 66 54.9 3,622.7
Pending 3 1.8 5.4
Rejected Draft 4 7.4 29.6
Submitted 1 226.2 226.2
Submitted Completed 1 19.0 19.0
Planning 1 92.0 92.0
Submitted 1 287.2 287.2
Waiting Approval 114 0.0 0.0
Waiting Approval Cancelled 3 61.0 182.9
Completed 2 28.7 57.4
In Progress 3 252.0 756.1
Planning 67 44.5 2,982.4
Rejected 10 28.0 280.1
Submitted 1 17.3 17.3