How do i stop a report showing duplicate ticket numbers?

[hannahhawkins02]

I'm running a report to show when a ticket has been assigned to different teams, however, as a ticket bounces back and forth, it can show the same ticket number 4 or 5 times in the report. what filter condition can I use to stop this?

[Slawek_Radziewi]

Have you tried to use Count Discount option in report?

You can also try to report just table Incident with condition Reassignment Count > 3...

This way you will see problematic incident bouncing and current group without duplicates.