We are trying to track the duration (time spent in days/hours) in each Status change (Custom Field) on the Opportunities Object. Right now we have enabled field history on this custom field (picklist) of status, but this reports into the Opportunity Field History related box (which shows changes made to anything altered in the Opportunity)
We need to only track the Change of Status on this picklist and how much time it spent total in that particular status.
So, if the User A creates the Opp in status "New". User B changes it one day later to Status "In Progress" and then User C changes it one day later to Status "New" again. Finally User D sets the status to "Completed" one day later. What should show on the table. As I coded it, this is what should show: Status = Time in Status (days) --------------- New = 2, In Progress = 1, Completed = 1
In this ie: History should show: Last Modified By Column 'User A' Status Column 'New' Total Duration 2 days Last Modified by Column 'User B' Status Column 'In Progress' Duration 1 day etc
Currently using this code attached below but need to know How can we change 'Opportunity Status Change Name' from displaying those random sequence of numbers and letters to the actual name of the stage?