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 *