Hi guys, I'm trying to make a filter that changes based on the filters available for a certain day.
I currently have a slider date variable input and I want to make my dropdown on my filter change with the available options on that day.
For example:
Only oranges and apples are available on 12/21/2021
Only grapes and watermelons are available on 12/22/2021
These foods fall under the measure 'Fruits', when I put Fruits as the filter and select date 12/21/2021, I see all 4 options. I would like to only see oranges and apples on the dropdown.
Thanks for your suggestion but this isn't what I want. This gets rid of the selections after applying the filter and does not update what the filter shows based on date.
