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 |
| | | | |