function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
ExecbizExecbiz 

Reporting/formulas on field history

Hello

 

I have set field history tracking on the Opportunity Stage.  I would now like to run reports on that, one big one would be an overview of the company and how long the average opportunity spends at each stage.  What is the best way to do this?  Should I create formula fields to calculate the "Time Spent at Stage X" for each field, then average those formula values?  Or is there a more direct way to do this in a report?

 

Thank you

cvjcvj
There is an out of the box report called 'Opportunity Stage Duration Report'