Add a color rule when result is a case statement?

I need to add a color rule to a date field where I added a case statement to show no data entered. The color rule only allows me to choose a date. Any suggestions on how to add the color rule when it shows 'incomplete' in the data display?
This is the case statement I used:
CASE when Oct '23 Required
= 'Yes'
AND Oct '23
IS NULL then 'INCOMPLETE'
else Oct '23
END
Here's a snip of the result:
Best Answers
-
Hello. You need to set a color rule for when Oct 23 = 'Complete' as shown similarly below:
If I solved your problem, please select "yes" above
0 -
You are mixing Dates and Strings and Domo is determining the type based on the majority of entries. If you are not operating on these dates in any other way, you can wrap your formula in a
CAST (<FORMULA> AS STRING)
to make sure Domo understand that this is text and will allow you to select options individually, of course this means they are no longer dates and you cannot set it based on ranges or the like.1
Answers
-
Hello. You need to set a color rule for when Oct 23 = 'Complete' as shown similarly below:
If I solved your problem, please select "yes" above
0 -
You are mixing Dates and Strings and Domo is determining the type based on the majority of entries. If you are not operating on these dates in any other way, you can wrap your formula in a
CAST (<FORMULA> AS STRING)
to make sure Domo understand that this is text and will allow you to select options individually, of course this means they are no longer dates and you cannot set it based on ranges or the like.1
Welcome!
Welcome!
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 308 Workbench
- 6 Cloud Amplifier
- 10 Federated
- 3.8K Transform
- 660 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 780 Automate
- 191 Apps
- 482 APIs & Domo Developer
- 84 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 413 Distribute
- 121 Domo Everywhere
- 281 Scheduled Reports
- 11 Software Integrations
- 146 Manage
- 142 Governance & Security
- 8 Domo Community Gallery
- 49 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive