And My goal is to calculate time difference between differents statuses. OldValue and NewValue represent old and new statuses. It is important to sort ascending CretedDate column before any calculation. And the last important note is ParentId it is id of the company. Right now I have just filtered one company, but the trick is that data is messy as it is in the pic above.
So the question is how to calculate time difference between 2 stages for the same company?
- This is all fields that I have. - Yes only one time period, so it works this way: 5/31/2019 5:47 C-complete status was choosed, and several actions was done maybe automaticly as a trigger, then 5/31/2019 8:21 manager choosed d-compliance status, then 5/31/2019 10:52 from d-compliance manager choosed c-reporting/testing status and so on. - Source is Salesforce DB