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

Dataphobia · 2023-05-12T22:18:18+00:00

There was an error rendering this rich post.

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?

Find more posts tagged with

Cards

Accepted answers

michiko

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

Example unfiltered data

When is NaN = 0

All comments

michiko

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

Example unfiltered data

When is NaN = 0

Dataphobia

Thank you for your help and workaround, Michiko!

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of