In metric report it will show 3 same records at the time of form submitted, I want to populate only

[Anwesh]

In metric report it will show 3 same records at the time of form submitted, I want to populate only first one. Thanks in advance.

@

@Mike_R 

@Ankur Bawiskar 

@Mark Roethof 

@Gunjan Kiratkar  

[Saurabh Gupta]

Can you please attach here the screenshot?

[Sebas Di Loreto]

@Anwesh 

If this a report that you are running, it seems to me you want to COUNT DISTINCT to get only one record.

Have in mind that the metric_instance table will have many records for a certain ticket.

In an incident for example, the metric table will be tracking the assignmet_group, assigned_to, state, etc.

Each of one of them is a record on the metric_instance table for that incident. That is why I am not surprised you are getting many records for the same ticket. If you "count distinct" the number field (incident), then you get only one.

[Anwesh]

Duplicates are coming to only one stage, other stages are not occurring duplicates  

[Sebas Di Loreto]

@Anwesh 

Thank you for adding the screen.

Add the definition field to that screen since that will tell you what metric definition is having trouble.

Once you know the name of the definition, you go to /metric_definition_list.do 

to check what is wrong with it. Feel free to add the screen of the metric definition as well.

This is an example of a metric on the incident table: