How do you Filter on Date that is Null

Reply
Highlighted
Yellow Belt

How do you Filter on Date that is Null

I have created the following beast mode to attempt to filter on dates that equal null

 

CASE
WHEN 'opportunity date' IS NULL
THEN 'Is null'
ELSE 'Is not null'
END

 

I can see the blank dates in the data but when I add the BM as a filter the only option I have is to select 'Is Not Null'.  How do I get the filter to have the option to select ' Is Null"?


Accepted Solutions
Black Belt

Re: How do you Filter on Date that is Null

try this

CASE
WHEN ifnull(`opportunity date`,0) = 0
THEN 'Is null'
ELSE 'Is not null'
END

also are you using the same date as your X axis ? that might cause trouble since is null .... not in the case of table cards

Domo Arigato!

**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'

All Replies
Black Belt

Re: How do you Filter on Date that is Null

try this

CASE
WHEN ifnull(`opportunity date`,0) = 0
THEN 'Is null'
ELSE 'Is not null'
END

also are you using the same date as your X axis ? that might cause trouble since is null .... not in the case of table cards

Domo Arigato!

**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'
Announcements
Check out these great solution videos! The new iSolveditWithDomoboard is live, share yours and earn higher rankings in Dojo click here!