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

bridgette · ‎04-26-2018

Hello Adam,

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

Best,

Bridgette Weirich

bridgette · ‎07-20-2018

I'm having issues trying to create one for metric category. Please see attachment. The options available are what I need, I just need to chose the correct reference table and field for the filter to work. Please assist! Thank you!