Apex Code Development You need to sign in to do that
Don't have an account?
Time in status as a total
Hello,
We have a custom object with custom status' that we would like to track how long over the course of the records life, it is in each status.
I have built a process builder to populate the start time and end time of when it is in each status.
How do I get the total status time for each stage? I need the amounts of time to add together as it goes from Open -->In Progress --> Awaiting Input --> In Progress --> Closed. I would want to see the TOTAL amount of days that it was in progress during the 2 instances that it hit that status.
We have a custom object with custom status' that we would like to track how long over the course of the records life, it is in each status.
I have built a process builder to populate the start time and end time of when it is in each status.
How do I get the total status time for each stage? I need the amounts of time to add together as it goes from Open -->In Progress --> Awaiting Input --> In Progress --> Closed. I would want to see the TOTAL amount of days that it was in progress during the 2 instances that it hit that status.
Hi Kayla,
I will suggest you to enable the field tracking for the object for the status field. Then you can do the reporting on it. That will show you the time when the value was changed along with new value and old value.
Try the above and check that meet your requirement. If yes, then mark it as best answer.
Regards,
Priya Ranjan