Hi, I have a table with null values in some columns. I want to show only the null values. When I filter in the null values in analyzer nothing shows up. Beast mode also doesn't work. Any ideas?
@jrtomici This is a common issue that has to do with how nulls are handled logically. You can get around this by creating a separate beast mode for your filter like this:
ifnull(`field`,'Filter out')
Have you tried using a COALESCE and filtering on the default value?
COALESCE(`field`, 'Empty')
