Hi I am running into a weird issue with filtering on a card

Utz

I am trying to filter on only the null values for the fields Date Voided and Date Reconciled. The dataset I am using has data on the lines where these date fields are null. For some reason when I filter on either of the dates on the null value, it does not return any data. No other filters are set on this card.

DavidChurchman

This is a common question: here's one (of many) answers to it:

https://community-forums.domo.com/main/discussion/comment/86113#Comment_86113?utm_source=community-search&utm_medium=organic-search&utm_term=filter+on+nulls

If you found it frustrating/unintuitive, you could vote on several of the idea exchange ideas to improve null filtering:

https://community-forums.domo.com/main/discussion/68606/filtering-on-missing-null-values-is-awful-improve-it

https://community-forums.domo.com/main/discussion/comment/100328#Comment_100328

https://community-forums.domo.com/main/discussion/68606/filtering-on-missing-null-values-is-awful-improve-it