My beast mode calculation is the following:
CASE
WHEN CEILING(`Flow Velocity (ft/s)`)<= 10 THEN '0-10'
WHEN CEILING(`Flow Velocity (ft/s)`)<= 50 THEN '10-50'
WHEN CEILING(`Flow Velocity (ft/s)`)<= 100 THEN '50-100'
WHEN CEILING(`Flow Velocity (ft/s)`)<= 150 THEN '100-150'
ELSE '150+'
END
I have realised that any BLANK values in that column are being bundled into 150+ bucket. I can't seem to filter out any BLANK values through the filter function on the card. Is there a way I can remove these BLANK values so they are not counted at this specific card level?
Thanks