Say that my data set looks like this:
and that I create the following question:
- Continent is Asia
- View SumOf(Population)
- GroupBy Country
I thus get following result:
Now imagine I include this question in a dashboard, with Country as a filter.
The country filter let me select among 3 options: Afghanistan, Bangladesh, and Croatia… however, selecting Croatia will lead to empty result, as it get striped out by the “Continent is Asia” filter.
This makes the whole UX a bit confusing, especially if I’ve titled the dashboard “Asia facts & figures”!
Is there a way to remove “impossible” options in the filter (in our case, remove Croatia from the Country filter)?