Really need a report that shows a list of Deals in the Pipeline and how long each individual deal has spent in it's current stage. I can't believe other users aren't clamoring for this... very inportant!!
This is almost there, but still lacks a single property to show the total time a deal has been in a current stage, if it has been in and out of the stage multiple times.
ie would love a property that essentially provides:
- Time in Current Stage (ie the calculated property that is updated in real time)
- Cumulative time in [Stage name] (ie the total of all the previous times it has been in this stage)
Would be ideal if the Cumulative time property automatically updated in real time instead of only calcuating when it exited the stage.
I'd happily create a Calculated property for this, but currently calculated properties won't allow other calculated properties to be used.