Wondering if anyone else has had this use case and if they managed to solve for it.
My app has a collection of deals, and each deal will always be assigned a stage. I want to track time spend (in days) in the current stage and time spent in each subsequent stage as the transaction progresses through the deal lifecycle.
Some reports I would like to run include:
how many deals are in stage A August
how many deals are in stage B in July vs August vs September
how much time is spent in each stage? What are the averages
how much time is spent moving from stage A to B and C to D, and what are the averages over time
I just started on something similar this morning so I haven’t sorted it all out yet. But my thought has been to log the date/time when each stage is started (so one for each stage) and then have calculating fields to find the difference from one stage to the next.