I have a table which I've sorted by the count of a particular column. However, the column that is sorted at the top is one that has nothing but blank data in it. How would I create a beast mode to remove this field. (Please see photo below.)
I've tried to create a beast mode that does this:
(CASE
WHEN `NonDirectionalCityPair` IS NOT NULL THEN `NonDirectionalCityPair`
END)
However it appears to do nothing. I thought that the DOMO Dojo column here: https://dojo.domo.com/t5/Card-Building/Delete-Blank-Rows-in-Table-Chart/td-p/25486 would help me but no luck. Any help would be great. Here's that image:
