Background
Say that my data set looks like this:
Continent | Country | Population (M) |
---|---|---|
Asia | Afghanistan | 35.5 |
Asia | Bangladesh | 164.7 |
Europe | Croatia | 4.2 |
and that I create the following question:
- Continent is Asia
- View SumOf(Population)
- GroupBy Country
I thus get following result:
Country | Population (M) |
---|---|
Afghanistan | 35.5 |
Bangladesh | 164.7 |
Now imagine I include this question in a dashboard, with Country as a filter.
Problem
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”!
Question
Is there a way to remove “impossible” options in the filter (in our case, remove Croatia from the Country filter)?