IF Condition

RajNadar

Beast mode calculation needed..

If 'Model' value contains blank then ignore those column of data and take of rest of rows

model

example

1 20

2 --- blank

3 40

here we need to ignore 2nd rows

GrantSmith

CASE WHEN `model` IS NULL THEN 'Ignore' ELSE 'Include' END

You can then take that beast mode and filter it on your card for Include

MichelleH

@RajNadar It sounds like you need a CASE statement. You can read more about how these work in this Knowledge Base article: https://domohelp.domo.com/hc/en-us/articles/360043429933-Beast-Mode-Functions-Reference-Guide#2.3.

Ashleigh

@RajNadar

case

when Model is null then 'Ignore'

else 'Keep'

end

Then you can filter on Keep

Alternatively, you could also do

ifnull(Model, 'Blank')

then filter out Blank

GrantSmith

CASE WHEN `model` IS NULL THEN 'Ignore' ELSE 'Include' END

You can then take that beast mode and filter it on your card for Include

RajNadar

Thanks