Hi,
How do you filter a data field where it is null? I don’t see any option under the filter type and condition.
Many thanks!
Hi,
How do you filter a data field where it is null? I don’t see any option under the filter type and condition.
Many thanks!
If you only want the rows where it’s null, you can create your filter like this:
Change the filter type to “Custom filter”. In your screenshot you have “Custom filter list” selected.
please see my second screenshot where i changed the filter type
Do you see the “Null options” dropdown list for any of your filters? Try adding filters on different fields and see if you can see it. It’s weird that you can’t see it.
I can see it on any type of field - text field, number field, calculated field, etc.
i tried using text, date and number…and all looked the same, no null option.
I am using json import file, but that shouldn’t matter, right?
Oh, guess what?
I can see the null option if I use filter in analysis, but not in “edit data”.
Do you see null option in “edit data”? @David_Wong
Yes, I was actually referring to filters at the analysis level. I didn’t realize you were trying to filter in your dataset. There are fewer options available when filtering at the dataset level. If you really need to do it at the dataset level and if your data source is a database, you’ll have to write custom SQL to filter by null.
Got it, thanks! Good to know about the custom SQL option as well.
And any idea how to filter for blank? Do I need to convert them to null? Or need to use custom SQL as well?
Can you try leaving the value empty like this? I’ve never tried this myself.
That worked perfectly!! I was typing in “” under value
Many thanks again David.