Interactive Filter off Metric_Instance Table

[Greg Wilk]

I am looking to create an interactive filter for assignment group as well as incident ticket number
off the metrics_instance table. Can anyone tell me what the reference table needs to be as well as the
interactive filter reference table in order to create them?

I provided screenshots below on where I am stuck. Thanks.

[Mike_R]

You should be able to just create it on the incident table, and then select "Apply to both database views and tables". Then it should work for incident_metric since that's a database view.

[Greg Wilk]

Thanks.  I went ahead and did that.  But no luck.  My reference table is incident[incident] but what should my interactive reference table be?  When I set it to incident[incident] and reference field parent incident.  It is not interacting with metric_instance table when i choose the ticket number.

[Mike_R]

I didn't realize you are trying to filter on Number.

Looks like you might need to try applying this lengthy workaround

https://www.servicenow.com/community/platform-analytics-forum/how-to-create-interactive-filter-based...