I have the following situation (simplified here as an example): My sheet has 2 visualisations from 2 different datasets. Both datasets include the column “organisation”.
Dataset A contains rows with the organisation “Alpha” and “Beta”.
Dataset B contains only rows with organisation “Alpha”.
I set up a filter on the visual for Dataset A and made it affect “all applicable datasets”.
Now I expected the drop-down of the filter to contain “Alpha” and “Beta”, but it only contains “Alpha” (the organisation common to boths datasets)
Is there a way to enable me to filter for all organisations in the superset rather to only be able to filter for the common organisations?
Wait so if you take off “All applicable visuals” does it show both “Alpha” and “Beta”?
If it’s coming from dataset A it should show all in dataset A.
If you’re asking for the filter to be a superset, that is currently not possible. I can mark that as a feature request as that sound like a nice feature.
HI @reneweis
If you create the filter fro dataset a, which contains both, dropdown should contain both. (just did a quick test)
As max said - it wont automatically do a superset. If a superset is needed, an option would be to use a parameter and populate from a 3rd dataset, the superset. Or just use a filter and hardcode the superset as values in the control.
thanks!
Ramon