I would like to create a report of 'Median Opportunity Stage Duration' in CRM Analytics.
The field 'Stage Duration' is available in the standard report type 'Opportunity History' in Salesforce reports:
However, this field is not available on the CRM Analytics connector:To make sure it's not a permission issue, I checked Object Manager but it doesn't show this field either:
I found this post:
OpportunityStage Duration | Salesforce Trailblazer Community
which says the information is present in "Pipeline Trending" but I can't find this object either.
Does anyone know how to get this column, or calculate this column, in CRM Analytics?
Thanks!
6 respostas