I am trying to achieve this task using excel Power Query.
I am trying to do a transformation on a data set that has Work Orders. So there are multiple Routing IDs. With each Routing ID there are one or More versions. For each version there are Multiple Work Orders. For each work order there are set of operations that are unique to the version ID. Now I need to:
Task 1: Find out wait times between these operations over all WO history
Task 2: Determine a simple average for the time between all Operations unique to the Version ID.
For task 1 I need to calculate the time difference between end of One operation to the start of the next operation for all the steps within that work order. Then Continuing doing this for rest of the work orders within the data set. I really do not know how To manipulate the data to achieve this take.
Kindly advise if I should provide data set as well. Thank you!