Card filtering in analyzer

jrtomici
jrtomici Member
in Charting

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

  • GrantSmith
    GrantSmith Coach

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

Categories