Salesforce - Stage Duration
I have used the salesforce connector for a while now and I am trying to find a easier way to measure Stage Duration in days for each opportunity and its current stage in our pipeline.
I know that by bringing opportunity history and events, I could get the minimun date for each stage changes, but it gets tricky when an opportunity moves from stage 2 to 3 and later on moves back to 2.
for Blogs I have found in internet , there has to be a field named "LastStageChangeDate_c", but navigating throught the Browse Object and Fields list , I have not been able to find it.
Another way could be... to create a custom field directly in Salesforce that holds the formula (TODAY() - 'LastStageChangeDate_c') and then grab it from the Objects list.
Has anybody done this and maybe has an easier way to do it ?