I am able to do this in SQL but cant figure how to do this using the UI create column feature
Here is scenario
SELECT item_count, created_on,
WHEN item_count < 1 THEN 'Failure'
END AS ResultDescription
GROUP BY created on;
Please can any help on how to write conditonal expressions with the create column feature