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
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 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.
@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
Thanks