Trying to add a new interactive filter to the top of a dashboard. Not working!

bridgette · ‎04-24-2018

Hello,

I am trying to add a interactive filter to the top of a dashboard that contains reports that pull from the asmt_metric_result table. I wanted the filter to be a choice list pulling from metric.type . This is not working! I get the error message, "Selected field is not a valid choice". Please help! I am doing something wrong.

Adam Stout · ‎04-26-2018

You have the main section in your screenshot but not the table mapping (the related list). This is what maps the reference table to the table you want to filter.

Can you include a screenshot of the mappings for this filter?

View solution in original post

Michael Fry1 · ‎04-24-2018

The field you are trying to use isn't a type that can be used in Interactive filters: https://docs.servicenow.com/bundle/jakarta-performance-analytics-and-reporting/page/use/dashboards/r...

Adam Stout · ‎04-25-2018

Metric.Type is a reference. The filter should be on asmt_metric_type and then have a mapping back to the metric table.

bridgette · ‎04-26-2018

Hello Adam,

I THINK IT'S WORKING! I can't thank you enough for your help.

Best,

Bridgette Weirich

bridgette · ‎04-25-2018

Hello,

Thank you both for your response. I tried asmt_metric_type table and it is not working. I am trying to make the filter to show the names of the survey, so the results can be shown in the reports below. Do you know what table and field I would use to do that?

Thank you for your help,

Bridgette Weirich