I have a question which queries a view I created in our DB (postgresql). View has data about user attribution (source, country etc) and some payment stats about the user. Each row - one user. The problematic use case is the following: we need to be able to select users from all countries and in the same question we need to be able to choose users from several countries. In separate instances of question usage, of course.
Right now we do it like this: we have a drop-down field filter connected to country_code field. We have around 90 countries in the table, all of them are selected by default.
- In order to select all countries during question usage, user can only refresh the webpage to roll back to default filter settings. According to this thread there's no way to select all options in dropdown. Selecting 90 countries manually is a pain. Maybe there's a workaround here?
- If there's no workaround, another problem pops up. The data is expanding and we get users from new countries. They appear in the view as new users. They are visible in metabase. But there's a problem with filter
2a) I have to run a field scan manually to push new countries to the filter. According to this thread such scan happens automatically once a day. I wasn't able to automatically get new countries to the filter. Can you confirm this auto-update is a thing or hint to where I can check it in admin?
2b) When the new country arrives to the filter, our default selection of all countries does not include this new country. So if a new country is added, I need to notice it, go into the question, put a tick near the new country. Is there a way to always select all filter choices as default?
Overall, I would appreciate a general advice on fixing this use-case we have.