You need to sign in to do that
Don't have an account?
Design a solution to get the average time (in hours) taken to close the 5 most recently closed cases on to a custom field at the Account object level
Hello. I am a newbie to Salesforce.
I am trying to find a solution or how to design a solution to get the average time (in hours) taken to close the 5 most recently closed cases on to a custom field at the Account object level. I will be using this information to see if there is a timely resolution of cases logged on each account.
My idea of approach to this problem -
I have created a formula field on Cases object to calculate time taken in hours to close the case. I would use a SOQL query to get the 5 most recent cases (order by ClosedDate DESC LIMIT 5) for each account. Can we achieve a solution to get the average time at the Account level using standard salesforce features (process builders, flows etc.,) without going for custom code ? If it has to be custom code, is Trigger a solution here ?
Can anyone please give any inputs/ suggestions/ ideas ?
Thank you.
May I suggest you please give a try by exploring Declarative Rollup Summary Tool which might help you with the above requirement.
- https://developer.salesforce.com/page/Declarative_Rollup_Summary_Tool_for_Force.com_Lookup_Relationships
Please let us know if this helps.Thanks,
Nagendra
Can anyone let me know / help to build the solution using apex classes or triggers.
Thank you