How do you rename null values in a date column?

emilybaeli · 2022-07-13T19:25:17+00:00

There was an error rendering this rich post.

I have blank values in a date column which is messing with my filter, is there a way to rename these? I don't get the option since it's not a text format

Find more posts tagged with

Accepted answers

All comments

GrantSmith

You can use a beast mode in analyzer or a formula tile in Magic ETL 2 and the COALESCE function to change NULL values to another value:

COALESCE(`dt`, '2022-02-02')

ST_Superman

Hi @emilybaeli -

It sounded like you were wanting to filter your cards to be able to remove those rows with a null value in your date field. I would consider creating a new field (either in the dataflow or via a beastmode).

nullDateFilter:

CASE WHEN `dt` IS NULL THEN 'Missing Date' ELSE 'Contains Date' END

This would allow you to then place the nullDateFilter field into the filter section of your card properties and remove any data that is missing the date.

RobSomers

Another way of doing a beast mode to rename null values is:

IFNULL(date_column,'No Date')