I basically need the dropdown list to reference another dashboard filter. I have a dataset with multiple 'programs' that each have 'menu items'. I only want to show options in the menu item dropdown list that are exist within the given 'program'
Not sure I get your question here but I believe you are after linked filters:
So when you select a program only the item name for that program are given as an option right?
Yes that's right, linked filters are exactly what I'm looking for. I'm still having trouble with the setup though.
I have a program ID filter and card that's a list of menu items that references it. How do I create a dropdown list of menu items that only shows the menu items linked to that program ID? In my screenshot, I need the dropdown filter show only valid menu items for that program AND to determine which menu item is shown on the graph on the right side
Ah I think it may be because I'm not using a field filter. Seeing this:
"Native question variables only accept a single value. They do not support dropdown lists or search box filters, and can't limit values for linked filters."
1 Like
Yes! You also need to make sure that if any joins are involved then you need to make sure the proper FK setup is done in the Admin -> Table Metadata