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.
* Empty cell implies no impact
There are no significant causes of delay that we can infer for this segment from the data.
|Service Request ID||SR Audit Create Datetime||SR Audit Status||Next status||Time spent|
|REQ000000696345||20-10-14 15:02||Submitted||Waiting Approval||19|
|REQ000000696345||20-10-14 15:02||Waiting Approval||Planning||74284|
|REQ000000696345||21-10-14 11:40||Planning||In Progress||263644|
|REQ000000716890||24-10-14 8:06||Submitted||Waiting Approval||8|
|REQ000000716890||24-10-14 8:06||Waiting Approval||Planning||383327|
|REQ000000716890||28-10-14 18:34||Planning||In Progress||76042|
This page shows all required calculations for the workflow POC.
Service Request ID,
SR Audit Create Datetime, and
SR Audit Status.
Service Request ID, and within that, by
SR Audit Create Datetime.
Next statuscolumn that has the next row's
SR Audit Statuswithin a given
Service Request ID. (The last row in each
Service Request IDwill have a NaN
Time spentas the next row's
SR Audit Create Datetimeminus the current row's
SR Audit Create Datetime. For the last row, this value will be NaN.
SR Audit Status.
SR Audit Statusand also has an
|SR Audit Status|
|SR Audit Status||Next status|