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

[bridgette]

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]

 What do you mean it is not working?  Can you add a screenshot of what you configured?

[bridgette]

Thanks for your help!

[Adam Stout]

It isn't a choice list, it is a reference.  Change the type of the filter.  You can still display the filter as a single select, but it is based on a reference.

[bridgette]

Thank you Adam! It looks like we're getting somewhere, but it's still not working. I get the error message," related list empty". Screenshots below.

[Adam Stout · Accepted solution]

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?