62 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.9% Cancelled 18.4% Completed 0.0% Draft 26.4% In Progress 30.1% Planning 0.0% Rejected 0.0% Submitted 22.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 218

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
REQ000000612161 10-01-14 12:51 Submitted Waiting Approval 10
REQ000000612161 10-01-14 12:51 Waiting Approval Planning 5912
REQ000000612161 10-01-14 14:30 Planning Completed 5249743
REQ000000612161 10-06-14 6:09 In Progress Closed 16543031
REQ000000612161 12-03-14 8:46 Completed In Progress 7766599
REQ000000617920 10-02-14 13:50 Submitted Waiting Approval 10
REQ000000617920 10-02-14 13:51 Waiting Approval Planning 2570
REQ000000617920 10-02-14 14:33 Planning In Progress 2418086
REQ000000617920 10-03-14 14:15 In Progress Completed 24535772
REQ000000617920 19-12-14 13:44 Completed Closed 8862129
REQ000000695867 11-03-14 10:15 In Progress Submitted 19282668
REQ000000695867 20-10-14 14:32 Submitted Waiting Approval 18
REQ000000695867 20-10-14 14:33 Waiting Approval Planning 3240
REQ000000695867 20-10-14 15:27 Planning Pending 5662
REQ000000707481 12-02-14 10:25 Completed Submitted 21781904
REQ000000707481 22-10-14 12:57 Submitted Waiting Approval 15
REQ000000707481 22-10-14 12:57 Waiting Approval Planning 2145
REQ000000707481 22-10-14 13:33 Planning In Progress 1726
REQ000000707481 22-10-14 14:02 In Progress Closed 4850391
REQ000000717697 11-06-14 17:03 In Progress Submitted 11638141
REQ000000717697 24-10-14 9:52 Submitted Waiting Approval 10
REQ000000717697 24-10-14 9:52 Waiting Approval Planning 335599
REQ000000728547 11-06-14 9:59 In Progress Submitted 11952401
REQ000000728547 27-10-14 18:06 Submitted Waiting Approval 11
REQ000000728547 27-10-14 18:06 Waiting Approval Planning 148783
REQ000000739363 12-03-14 8:36 Completed Submitted 19964697
REQ000000739363 29-10-14 10:21 Submitted Waiting Approval 18
REQ000000739363 29-10-14 10:22 Waiting Approval Planning 12588
REQ000000739363 29-10-14 13:52 Planning In Progress 1293
REQ000000739363 29-10-14 14:13 In Progress Closed 4331585
REQ000000739575 12-03-14 8:42 Completed Submitted 19967952
REQ000000739575 29-10-14 11:21 Submitted Waiting Approval 14
REQ000000739575 29-10-14 11:21 Waiting Approval Planning 9034
REQ000000739575 29-10-14 13:52 Planning In Progress 4398
REQ000000739575 29-10-14 15:05 In Progress Closed 4328473
REQ000000739629 12-03-14 8:37 Completed Submitted 19966734
REQ000000739629 29-10-14 10:56 Submitted Waiting Approval 11
REQ000000739629 29-10-14 10:56 Waiting Approval Planning 10544
REQ000000739629 29-10-14 13:52 Planning In Progress 3056
REQ000000739629 29-10-14 14:43 In Progress Closed 4329815
REQ000000759488 11-03-14 12:15 Submitted Waiting Approval 15
REQ000000759488 11-03-14 12:15 Waiting Approval Planning 5283172
REQ000000759488 11-05-14 15:48 Planning In Progress 2670625
REQ000000771171 11-05-14 13:15 Planning In Progress 13218918
REQ000000771171 11-05-14 8:44 Submitted Waiting Approval 13
REQ000000771171 11-05-14 8:45 Waiting Approval Planning 16232
REQ000000771171 11-10-14 13:10 In Progress Cancelled 2660622
REQ000000771380 11-05-14 13:15 Planning In Progress 13220553
REQ000000771380 11-05-14 8:52 Submitted Waiting Approval 15
REQ000000771380 11-05-14 8:52 Waiting Approval Planning 15803
REQ000000771380 11-10-14 13:38 In Progress Cancelled 2659048
REQ000000771610 11-05-14 13:15 Planning In Progress 13217000
REQ000000771610 11-05-14 8:39 Submitted Waiting Approval 12
REQ000000771610 11-05-14 8:39 Waiting Approval Planning 16547
REQ000000771610 11-10-14 12:38 In Progress Cancelled 2662404
REQ000000837895 12-03-14 10:55 Completed Submitted 21768835
REQ000000837895 19-11-14 10:20 In Progress Closed 2531133
REQ000000837895 19-11-14 9:49 Submitted Waiting Approval 21
REQ000000837895 19-11-14 9:49 Waiting Approval Planning 401
REQ000000837895 19-11-14 9:56 Planning In Progress 1475
REQ000000838021 12-03-14 10:53 Completed Submitted 21768493
REQ000000838021 19-11-14 10:04 In Progress Closed 2532110
REQ000000838021 19-11-14 9:41 Submitted Waiting Approval 15
REQ000000838021 19-11-14 9:41 Waiting Approval Planning 859
REQ000000838021 19-11-14 9:55 Planning In Progress 515
REQ000000874885 12-01-14 13:41 In Progress Cancelled 5081498
REQ000000874885 12-03-14 9:13 Cancelled Submitted 22402522
REQ000000874885 26-11-14 16:08 Submitted Waiting Approval 20
REQ000000874885 26-11-14 16:08 Waiting Approval Planning 54281
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
REQ000000904285 12-03-14 20:50 Planning In Progress 21139569
REQ000000904285 12-03-14 8:02 Submitted Waiting Approval 58
REQ000000904285 12-03-14 8:03 Waiting Approval Planning 46050
REQ000000905093 12-03-14 9:51 Submitted Waiting Approval 43
REQ000000905093 12-03-14 9:52 Waiting Approval Planning 2673275
REQ000000905093 12-04-14 8:27 Planning In Progress 18880
REQ000000927976 12-08-14 15:56 Submitted Waiting Approval 9
REQ000000927976 12-08-14 15:56 Waiting Approval Planning 2677679
REQ000000927976 12-09-14 15:44 Planning In Progress 7839936
REQ000000933497 12-09-14 13:59 Submitted Waiting Approval 29
REQ000000933497 12-09-14 14:00 Waiting Approval Planning 8119011
REQ000000933497 15-12-14 13:17 Planning In Progress 90391
REQ000000941240 12-10-14 15:09 Submitted Waiting Approval 15
REQ000000941240 12-10-14 15:09 Waiting Approval Planning 6200400
REQ000000941240 23-12-14 9:29 Planning In Progress 13847263
REQ000000941516 12-10-14 15:12 Submitted Waiting Approval 18
REQ000000941516 12-10-14 15:12 Waiting Approval Planning 6200211
REQ000000941516 23-12-14 9:29 Planning In Progress 13847383
REQ000000983374 01-05-15 16:18 Planning In Progress 2656528
REQ000000983374 19-12-14 10:05 Submitted Waiting Approval 14
REQ000000983374 19-12-14 10:06 Waiting Approval Planning 11513544
REQ000000989915 22-12-14 9:57 Submitted Waiting Approval 6
REQ000000989915 22-12-14 9:57 Waiting Approval Planning 177149

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 1 1 259.3 259.3
Completed 8 8 205.2 1,641.8
Draft 2 2 0.0 0.0
In Progress 19 19 123.9 2,354.8
Planning 58 58 46.2 2,677.1
Rejected 2 2 0.0 0.0
Submitted 64 64 0.0 0.0
Waiting Approval 64 64 30.8 1,971.4

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Cancelled Submitted 1 259.3 259.3
Completed Closed 1 102.6 102.6
In Progress 1 89.9 89.9
Submitted 6 241.5 1,449.3
Draft Submitted 2 0.0 0.0
In Progress Cancelled 4 37.8 151.2
Closed 7 65.2 456.6
Completed 2 145.0 290.0
Submitted 6 242.8 1,457.1
Planning Completed 3 80.3 240.9
In Progress 54 45.1 2,436.1
Pending 1 0.1 0.1
Rejected Draft 2 0.0 0.0
Submitted Waiting Approval 64 0.0 0.0
Waiting Approval Planning 62 31.8 1,971.4
Rejected 2 0.0 0.0