Hey Gliders ,
Itās me once againā¦
I have a question about how some of you would handle this situationā¦
Letās assume you have a piece of documentation that is passed through different people within an organisation. Now this documentation can take up to 3 paths depending on the type of Job that needs to be performed (Service request). These 3 paths are different in the sense that path 1 may be longer than both path 2 and path 3 in that it may need to pass through the invoice clerk while for path 3 the invoice clerk is not necessary because the client would be paying cashā¦
At every point of exchange, there is a button press that takes place and a passcode entered into the system to authorise or confirm the exchange and along with this exchange the time stamp is recorded.
Now I need to create a time graph of the path because I would like to display which phase of the path took longer. This is some type of performance metric and would help the client understand which point is responsible for the delay if there is any delayā¦
How do I go about calculating this time difference between the stages when in some cases the āif then elseā column which I use to give the status update of the document is empty. For example, when the document is passed from the clerk to the invoice clerk, a Boolean is checked and then an if then else column would then give an update to say the document is with the Invoice Clerk and also the timestamp is recorded. For some paths, some of these Booleans will not be checked and therefore I struggle to think of how to handle that situation in order to give the amount of time the document spent at each stage
I hope what I wrote makes sense because I feel like itās quite a lot even as I write it so I am not sure I was able to properly articulate myself. Your inputs would be greatly appreciated