beast mode

Options
newbie123
newbie123 Member
edited July 7 in Calculations & Variables (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

  • MichelleH
    MichelleH Coach
    Answer ✓

    @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
  • ColemenWilson
    ColemenWilson Coach
    Answer ✓

    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

Answers

  • MichelleH
    MichelleH Coach
    Answer ✓

    @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
  • ColemenWilson
    ColemenWilson Coach
    Answer ✓

    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

  • newbie123
    newbie123 Member

    Thank you so much!!!

  • newbie123
    newbie123 Member

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

Categories