I'm trying to track the progress/flow of a product inside a warehouse until it leaves it. I have these stages the product goes through:
Order picking Packing Verification Sent Completed
I have a start and end date for which of these stages, and I'd like to answer the following questions: - What is the duration (in days) from when a document starts the "Order Picking" stage until it gets to the Packing stage? - What is the duration (in days) from when a documents exits the Packing stage and starts the Verification stage? and so on...
Any ideas of how this process should be modelled in the script? Like, should I create a Product_Stage_Start_Date and Product_Stage_End_Date for each stage, left joining all to the fact table?
If somebody knows any better approach, please let me know. 🙂