Unable to Report on Metric Related List for Incidents

[Darrion Burges1]

Hi all, 

I'm trying to get the metric for assignment group x, "How Many Incidents has group X been assigned to at some point in the past month?".

- This uses the out of the box "Assignment Group" metric, and if I look at the given incident, I can even pull in the "Metric" Related List! where I can filter all the metrics related to the given incident.

Thus, one would think that I could easily do the following report: 

Table: Incident

Type: Score

Filter: 

for Related List: Metric: One or more of the following:

- definition is assignment group

- value is x

- and Metric Instance was created sometime last month. 

Only problem with the above report, is that I seem to be unable to access the metric table as a related list, even as an admin. Is there a reason I am not able to report on the metric table as a related list? More importantly, is there a way I can add the metric table as a related list for reporting? 

The reason I'm not using the incident_metric table is that I am unable to do an aggregation of count distinct based on the incident number, making this metric impossible with anything but PA, which really shouldn't be necessary. 

The main goal is to provide the metric using only reporting. Any way I can change things as an admin to make this possible?

[Adam Stout]

Related List Conditions only work for reference fields, since we use views on metrics, it isn't compatible.  It would nice it if was.  For now, you'll have to use a scripted filtered.

Take a look at this article (skip to the end):  https://community.servicenow.com/community?id=community_blog&sys_id=bd0eaa2ddbd0dbc01dcaf3231f96199e

[Darrion Burges1]

So would your answer be that I need to create a script? I can imagine how to do it via scripting, but I really want to allow other users to do related list queries on the metric table without needing to update scripting. 

I was more thinking that there was some table or property that lists the tables that are available for related list queries, but I just can't seem to figure out where it's located/if it's even available to me as a customer.