function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Anonymous1Anonymous1 

what is best approach to calculate duration of case status(picklist field) of particular picklist value and stamp in custom date/time field

Hi All, 

which is best way(flow/trigger) to calculate duration of Case Status particular picklist duration values and that sum value store it in custom field on case object.

We need same as Standard case lifecycle approach, as it calculates particular status time duration.
Example: I hae created one case record
User-added imageI want to caluclate only sum of "New" Duration values (0.004 + 0.55) and store it on case custom field(Date/Time) field. how to caluclate this duration values from case History

how this funtionality is feasible in flow / trigger. Kindly suggest me with some solution.

Thanks 
 
VinayVinay (Salesforce Developers) 
You can check below example to track the case age of each status.  You would need to make minor changes as per your requirement.

https://salesforcesidekick.com/2016/04/11/how-to-track-the-age-of-each-status/

Please mark as Best Answer if above information was helpful.

Thanks,