Show group by records with more than 1 record

[vipinmann20]

Hello! I am trying to pull a report for "repeat offenders" in the last 48 hours for the Service Desk. I was hoping to just run a report on the incident table and group by customer but only want to see grouped values that have more than one record. For example in the screen shot below, the highlighted rows are the data I would like to see. I would like to filter out any other grouped row that only has one value but I am not sure how to do so. Any help is appreciated!

[Shubham_Jain]

@vipinmann20 

Using Reports:

1. Navigate to Reports > Create New Report.
2. Select the Type as List or Bar Chart (if needed).
3. Choose Table as Incident.
4. Under Conditions, set:
   • Created → Last 48 hours.
5. Under the Group By section, select Caller (Customer Name or ID).
6. In the Aggregation section:
   • Select Count on the Sys ID field.
7. Now, in the Filter section, add:
   • Count (Sys ID) > 1
8. Run the report.

This will show only customers with more than one incident in the last 48 hours.

[vipinmann20]

Aggregation section is not there for List type report

[Shubham_Jain]

@vipinmann20 

If the above doesn’t work as expected, you can try:

1. Go to Reports > Create New Report.
2. Select Type: List.
3. Choose Table: Incident.
4. Under Conditions, filter:
   • Created → Last 48 hours.
5. Under the Columns, add:
   • Caller
   • Number
6. Sort by Caller.
7. Export the report to Excel and use a pivot table to filter Caller occurrences > 1.

[vipinmann20]

I don’t want to export. I want to create the report so that I can use it. It will be helpful if it is possible to achieve this in reporting.