I am tryin to create a navigation action that passes the value of a parameter, as the attached screenshot shows I have a donut chart with two values 0 and null when I click on the 0 part the navigation and filtering works but when I try to filter by the null values it doesn’t work.
Any help?
Is this Vat Rate a field in your dataset or a calculated field?
It’s a field in my data, an integer.
Can you make a calculated field that checks if it’s a null and then turns it into an integer? For instance
ifelse(isNull({Vat Rate},2,{Vat Rate})
And then check if that number works? I’m wondering if quicksight doesn’t handle nulls with filters / actions.
Hey Max,
Thank you for your suggestion but doesn’t this mean that the visual will show 0 and 2 which defeats its purpose is there any other workaround?
it says here the I can use Nulls in a parameter so if am passing through a parameter a null values shouldn’t it filter by all null values? if am creating a normal filter I can filter by just the nulls so the concept of filtering by nulls is there.
Best regards.
Yes it will. I wanted you to test it out to see if null was the issue or if there is something else.