let’s assume that in a dashboard we have the two following filters: ‘country’ and ‘city.’
After I have chosen one or more countries in the ‘country’ filter, I would like the suggested values in the dropdown of the ‘city’ filter to be updated based on the values of the ‘country’ filter.
For example, if in the country filter the user selects ‘United Kingdom’, then when they click on the city filter they will only see cities that are located in the UK, and not all cities of the dataset. I hope that makes sense.
Is it feasible in Looker?
Thank you very much in advance.