Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

how to let report only show one record which contains same incident ref?

in Reporting & Analytics for B2C Service 2 comments

Summary:

I have a report with a filter incident.status = solved, so the report will shows solved incident and agent name who solve it, but sometimes incidents reopened and solved more than one times. So the report will shows like this:

solve time                agent name           incident_ref

18:00               A                   240723-000001

13:00               B                   240723-000001

15:00               C                   240723-000001

18:00               A                   240723-000002

11:00               D                   240723-000002

15:00               C                   240723-000002

How to remove duplicate records and only shows like this?

solve time                agent name           incident_ref

13:00               B                   240723-000001

11:00               D                   240723-000002


Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):



Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!