Bug Update: Filtering on Null Values

iresanjogar

Past May @SamEich posted a bug regarding Null values. Basically the filters you add to a Domo card are not able to filter on a null value. I ran into this problem several times and the bug still does not seem fixed. How could we know the status of this request and when it will be implemented? Should I contact Domo Support? Bugs like this should be addressed quickly.

Thanks! 

[Deleted User]

@iresanjogar

 

I am following up with the product team on this. It's not really a bug as opposed to a feature enhancement.

 

https://dojo.domo.com/t5/Ideas-Exchange/Bug-Filtering-on-Null-Values/idc-p/19067#M3639

 

If you had something else in mind please advise.

 

Thanks!

JasonWebber

I haven't tested this, but I thought I saw this done with this value in the filter:

 

::empty::

 

Let me know if it works.

SEC

I too am having a problem seeing what items fall into the null catagory in my data.  They are items that need to be fixed, but no transactions show so I can see what needs to be fixed.

iresanjogar

Currently what I do to identify the Null values in a dataset is to use the "IFNULL" BeastMode function within the creating of a card:

Numeric: IFNULL('column', 0)

Text: IFNULL('column', '0')

But these are extra steps that should be avoided since they slow down the process of analyzing the data and creating cards (besides you end up creating too many variables and the dataset becomes busy and confusing).

SEC

Anything new on this topic?  I just had this come up for me again, and since there is no detail when you drill down on a null value, I'm not able to fix what caused it.

[Deleted User]

@btm @Dark_Knight

 

Can you guys chime in on this one?

 

Thanks
Dani

dtao

Came across the same issue. Would definitely be great if Domo would address this from a development standpoint. I had to workaround the issue by creating an ETL that replaced NULL values with a text value of 'NULL' which allowed me to filter on those NULL values.

 

 

James_Thoma

This appears to still be a bug. Any updates?

DanHoughton

I agree. Even if I wanted to only show NULLS in my report, I cannot. There's no way to recreate the "is null" and "is not null" from SQL.

James_Thoma

I would love for this bug to be fixed. 

Ritwik

Just ran into this same issue, it's been a long-standing issue, hopefully we'll see a fix or new feature soon. 

stumpfcm

This thread is almost 4 years old.  Has DOMO provided a solution to this yet?  I am having the same issues.

jaeW_at_Onyx

use a beastmode in your filter where you replace NULLS with a text value.

 

ifnull(column, "No Value" )

stumpfcm

Thank you Jae. 

 

That what I did.  It is just an unnecessary step that I would have rather skipped.  Domo should fix this.  If a NULL value is valid, then you should be able to filter on it without a Beast Mode.