how to let report only show one record which contains same incident ref?
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):