-
How to calculate time spent on the record in a Salesforce case queue?
I have created three fields on case object: case1-datetime, case2-datetime, case3-datetime.
Whenever a case is created we need to calculate the time spent on the record (queue1) - it will store the value in case1 field.
Whenever I change the one queue to another queue, I need to calculate the time spent on that queue. Then again the second queue is assigned to the first queue. (it will store the value in case2 field).
Then the first queue is assigned to the third queue, then calculate the time spent on the third queue. Then calculate the overall time spent on the all the queues. (overall time spent is fill with case3 field)
Log In to reply.
Popular Salesforce Blogs
Platform Events in Salesforce | The Ultimate Guide
Platform events are an essential part of the Salesforce platform. These events are custom-defined objects that enable real-time data sharing among different Salesforce components and…
What is the External ID in Salesforce and Data Wizard? | All You Need to Know
In Salesforce, an external ID is a unique identifier for records generated outside of Salesforce. This is a custom field that can be added to…
Relationship Queries in SOQL | Salesforce Tutorial Guide
Relationship field contains at least 2 Objects i.e a Child Object and a Parent Object. These queries are used to fetch Data either from the…
Popular Salesforce Videos
Kanban View and Personalisation | Salesforce Training
In this short video, we will show you the Kanban view in Salesforce Lightning and how it can be personalized. Check out this amazing and…
Salesforce Sales Cloud Training | Sales Cloud In Salesforce | Salesforce Tutorial
This Salesforce Sales Cloud Tutorial will help you understand what is leads home page, how to create contacts, how to create products and all creating…
What are The Benefits of Salesforce Financial Services Cloud?
Business today is all about relationships. That’s nothing new. But how you go about managing and maintaining those relationships is completely different in today’s business…