beast mode

newbie123

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
order number	75	item	Widget	order date		order total	$105.47	status	incomplete
order number	69	item	Widget	order date		order total	$105.17	status	incomplete
order number	72	item	Widget	order date		order total	$46.69	status	incomplete
order number	21	item	Gear	order date	5/21/2020	order total	$251.40	status	complete
order number	72	item	Gear	order date	5/21/2020	order total	$267.95	status	complete
order number	54	item	Gear	order date	5/21/2020	order total	$250.00	status	complete
order number	80	item	Gear	order date	5/21/2020	order total	$339.79	status	complete
order number	99	item	Gear	order date	5/21/2020	order total	$249.70	status	complete
order number		item		order date		order total		status

MichelleH

@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

I agree with @MichelleH , you would then use the new field as a filter on the card and select IN complete.

MichelleH

@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

I agree with @MichelleH , you would then use the new field as a filter on the card and select IN complete.

newbie123

Thank you so much!!!

newbie123

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