Create report where count > 1

[spike]

I'm trying to create a report on metric_instance where there are more than one instance of the Assignment Group metric been recorded. I only want to report on those incidents where there is more than one of those metrics.

However there doesn't seem to be a way for me to be able to put a clause in there for count > 1.

Any ideas on how I might go about achieving this?

I've looked at the related list section but it lists not tables when I try to use it.

Taking it the other way and looking at incidents and then trying to use the related list to filter, I find the metric_instance table isn't listed so not able to drive it from that side either. 

Any help or direction would be greatly appreciated!

[Community Alums]

Hi @spike ,

From what I could understand, you want to report the Incident reassigned count, Is that correct? If this is what you are looking, then there is this OOTB field called 'Reassignmnet Count' which by itself give you the reassigned count for the Incident. So, you need to add this field in the filter condition of the report and give the condition as count > 1.

Please mark helpful/like if the solution is in line with your expectation.

Regards,

Gagan k

[spike]

I was aware of that field and yes it would help me in this scenario. But I think I maybe picked a bad metric to discuss! Assuming that field didn't exist or I'm using a different metric, is there a way to do what I want?

Cheers.

[Community Alums]

Hi @spike, 

I have provided a solution something similar in another post. All you need to do is change field (in your case it would be assignment group) in the metric instance and the metric definition. Please check out the below link.

Solved: Timestamp of the State Change in Change Request an... - ServiceNow Community

Regards,

Gagan k

[spike]

Many thanks. I'm not sure that helps though.

Here's a better scenario: I want to track those incidents that have been assigned to more than one person, regardless of the assignment group. There is a metric (assigned to duration) that tracks how long an incident is assigned to an individual.

I want to create a report that shows me all incidents where there is more than one instance of the assigned to duration metric for that incident (and therefore tells me that multiple individuals have been assigned to the incident).

How can I do that?