beast mode

Hi community, I'm new to domo and need some help. I have a simple data set (see below). I want to only view rows that have an order date. if it's blank, i don't to see it. I was hoping to use the filter but I can't figure out how to exclude blank dates, i only get options to filter by various date ranges.
Or, what would be the syntax to create another column labeled 'status' that shows 'incomplete' if the order date is blank and 'complete' if there is a date?
How could I use beast mode to do accomplish this? Thanks in advance!
order number | item | order date | order total | status |
---|---|---|---|---|
75 | Widget | $105.47 | incomplete | |
69 | Widget | $105.17 | incomplete | |
72 | Widget | $46.69 | incomplete | |
21 | Gear | 5/21/2020 | $251.40 | complete |
72 | Gear | 5/21/2020 | $267.95 | complete |
54 | Gear | 5/21/2020 | $250.00 | complete |
80 | Gear | 5/21/2020 | $339.79 | complete |
99 | Gear | 5/21/2020 | $249.70 | complete |
Best Answers
-
@newbie123 You use a case statement to check whether the order date field is null like this:
case when `order date` is null then 'incomplete' else 'complete' end
2 -
I agree with @MichelleH , you would then use the new field as a filter on the card and select IN complete.
If I solved your problem, please select "yes" above
0
Answers
-
@newbie123 You use a case statement to check whether the order date field is null like this:
case when `order date` is null then 'incomplete' else 'complete' end
2 -
I agree with @MichelleH , you would then use the new field as a filter on the card and select IN complete.
If I solved your problem, please select "yes" above
0 -
Thank you so much!!!
0 -
@ColemenWilson thats exactly what I was going after as well. since I wasn't able to use the date column to filter out blanks, I could use the new column I created and filter out using that way. @MichelleH thank you both!!
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 308 Workbench
- 7 Cloud Amplifier
- 10 Federated
- 3.8K Transform
- 660 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 818 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 781 Automate
- 191 Apps
- 483 APIs & Domo Developer
- 84 Workflows
- 23 Code Engine
- 43 AI and Machine Learning
- 22 AI Chat
- 3 AI Projects and Models
- 18 Jupyter Workspaces
- 408 Distribute
- 116 Domo Everywhere
- 281 Scheduled Reports
- 11 Software Integrations
- 146 Manage
- 142 Governance & Security
- 8 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive