How do you rename null values in a date column?
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
Answers
-
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')
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
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.2 -
Another way of doing a beast mode to rename null values is:
IFNULL(
date_column
,'No Date')**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 754 Beast Mode
- 61 App Studio
- 41 Variables
- 693 Automate
- 178 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive