Hello everyone,
I'm using filters on a dashboard to switch from one subcategory of data to another. I want the cards connected to the first subcategory to disappear when the second subcategory is selected, and vice-versa. This does work using the "Hide card when there is no results" toggle, but not when the result is 0 (e.g on cards with a "Count rows" or "Distinct values of" summary). I've tried to work around this by using a custom expression CountIf(notnull([ID]))
in order to make the card return "null" instead of 0, but the card is still displayed on the dashboard. Is there a way to turn "0" or "null" into "No result"?
Thanks!