Is Domo treating 0 as NULL? Card filtering 0 value as NULL

Dataphobia
Dataphobia Member
in Cards, Dashboards, Stories

Hi everyone, is this a legitimate expected functionality or a bug? In my card, I have a filter on NPS Score IS NOT NULL. However, it seems to be filtering out my records/rows with NPS Score = 0.

Is Domo treating 0 as NULL?

Tagged:

Best Answer

  • michiko
    michiko Contributor
    Answer ✓

    I got the same behavior when trying to exclude Null / NaN value from Integer.

    My workaround is to use the beastmode below to exclude the Null

    image.png

    Example unfiltered data

    image.png

    When is NaN = 0

    image.png

Answers

  • michiko
    michiko Contributor
    Answer ✓

    I got the same behavior when trying to exclude Null / NaN value from Integer.

    My workaround is to use the beastmode below to exclude the Null

    image.png

    Example unfiltered data

    image.png

    When is NaN = 0

    image.png
  • Dataphobia
    Dataphobia Member

    Thank you for your help and workaround, Michiko!

Categories