Interactive Filter Assignment Group not working with report Metric_instance

[Vivian Lowrance]

I've created several reports using the sn_si_incident, task_sla, and metric_instance tables. I added two interactive filters on the dashboard —one for Assignment Group - multiple and another for Created On. Both filters work correctly across all reports except for the one based on the metric_instance table, where only the Created On filter is functioning. The Assignment Group filter is not applying as expected. I attempted to create a reference field on metric_instance to link it with the Assignment Group interactive filter, but it keeps throwing an error (Error Message: Reference field "definition" is not of type "sys_user_group")
The reports and dashboards are built using Core UI, not Performance Analytics or Platform Analytics.

Thanks for your help in advance.

[J Siva]

Hi @Vivian Lowrance 

Metrics (metric_instance) table does not have a field called "Assignment group". So it's expected that the assignment group filter does work on the metric_instance report.

I would suggest you to use the table specific metrics table like incident _metric, sc_tadk_metric etc where you'll get an option to link the assignment group field with your filter.

Regards,

Siva

[Vivian Lowrance]

Thanks Siva for your reply. I have created report using metric_instance table and the filter condition is:

Definition is Incident State duration And

Duration is not empty And

Table is sn_si_incident And

Value is Draft