I am working on the OOTB
Milestones and now looking to calculate the Sum of the Elapse Time.
- How we can calculate the sum of all these Elapse Times using formula fields? Do I need to write some other logic ? As we all know we can not edit/update the CaseMilestones fields.
- In some cases, I only need to get the overall(End-to-End SLA) Elapse Time. So in this, I have to used Category & sub category value to differentiate from the another SLA's. How can I only get the 1st SLA elapse time ? Do I need to show Total Elapse time when all milestones are completed, right ?
How we can get the Elaspse Time of all Milestone attached to that case using SOQL ? Any guidance around this ?