Card filtering in analyzer

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?

Best Answer

  • MichelleH
    MichelleH Coach
    Answer ✓

    @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')
    

Answers

  • Have you tried using a COALESCE and filtering on the default value?

    COALESCE(`field`, 'Empty')
    
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • MichelleH
    MichelleH Coach
    Answer ✓

    @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')