Hi All!
I'm trying to run an Opportunity History report to look at Average Stage Duration for a Closed Won Opportunity. When I build it out, I get all the information I am looking for EXCEPT that I don't want the Average of Average Stage Duration, I want the Sum of the Averages or the Average Time from Prescribe (stage 1) to Closed Won. Thoughts?
TIA!
4 risposte
Vuk Stajic (MVRK Inc.) Forum Ambassador
Referencing this: https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000A7s0CSAR it seems what you want is likely not possible. I was unable to do with with any formula in a test report I set up like yours.
We discussed creating a custom field for your age of case such as this:
CloseDate - DATEVALUE(CreatedDate)