Beast mode calculation needed..
If 'Model' value contains blank then ignore those column of data and take of rest of rows
2 --- blank
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.
when Model is null then 'Ignore'
Then you can filter on Keep
Alternatively, you could also do
then filter out Blank