Filtering/reporting on metric results by assignment group

[will_smith]

Hello everyone, I am trying to see metric results by assignment group, but I can't seem to find a dot walk from the metric results table to the assignment group on the incident table. Can someone give me some guidance on how to solve this? Thank you in advance!

If it involves creating a view, I haven't done that successfully yet - additional help may be required.

[Michael Fry1]

You can report on the results by using the incident_metric and conditions of Definition is Assignment Group, & Value is x, where x is the group. What are you trying to dot walk too?

[will_smith]

Hi Michael.Fry!

I am trying to do something like this, only limiting by the assignment group. I will work from the incident metric table and see what I can come up with. Thank you.

[will_smith]

These are assessment survey metrics.

[Uncle Rob]

As in, the asmt_metric_result table?   Really hard to pull anything meaningful from there, but here's where I'd start.

Make a database view that joins asmt_metric_result table to Incident where incident.sys_id = asmt_metric_result.source_id.   Then you're going to need to report off that view.