Case Saved Search that allows you to drill down on grouped Escalated To field

Use Case: Ability to show Count of Cases and whom they are Escalated To and to be able to drill down on the Escalated To field to see detailed results

Create a Saved Search by following these steps:

1. Navigate to Lists > Search > Saved Searches > New.


2. Select Case.


3. Provide a Search Title.

4. On the Criteria tab > Standard subtab, set the following:
—System Notes : Field is Escalatee

5. On the Results tab > Columns subtab, Add the fields you want, in particular add:
Number – with Summary = Count
System Notes: New Value – with Summary = Group
Escalated To – with Summary = Group, Custom Label = Escalatee

6. Click Save & Run.

Now when viewing the results a user can confirm the grouped Escalated To field matches the grouped Escalatee field and they can drill down into the grouped Escalatee field to see detailed results

Leave a comment

Your email address will not be published. Required fields are marked *