Calculate the Stage Duration in Pipeline
Is there a way to calculate the duration not depending on the dates? as the stage can be changed a couple of times,
Instead, calculate depending on the duration the deal has stayed in that stage,
Example: the deal is currently in the Pending stage and has been for 5 Days, somehow it was changed to the Paused stage and stayed for 2 Days then changed back to the Pending stage for another 5 Days, the duration should be 10 Days instead of calculating the duration from the second time which will be 5 Days.