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?

[Adam Stout]

What are you looking to get?   Any incident with more than one team assigned to it?   How are you doing this today?   I would recommend leveraging the incident_metrics view possibly with a related list condition (on a report based on incident).   However, for a more detailed answer, I would need some more details on what you are looking for.

[xavier_robert]

Hi Adam, I try to use related list condition mais I don't find metrics table or database views in the table combobox.

[Adam Stout]

You're right, I forgot that it has to be a real reference, so metrics won't work here.  You may be able to use a scripted filter.  Can you just use reassignment_count > 1 as a filter? 

[xavier_robert]

I could not find a solution with the reports and metrics available in my instance.

But as mentioned in the article below by creating a specific scripting metric, we have a way to create a report on the groups affected during an incident without duplicate numbers.

We are a little frustrated because our users do not understand why it is so complex to do a "select where exist in".

 https://community.servicenow.com/community?id=community_question&sys_id=8805cb2ddbd8dbc01dcaf3231f9619f0