Hey there I'm trying to perform a case statement in magic etl using the formula widget.
I'm trying to use automl tool to predict the likelihood of receiving a like, comment, and/or shares based on a section topic.
I'm not sure if I'm on the right path though.
(CASE
WHEN `likes` IS NOT NULL AND `comments` OR `shares` IS NULL THEN "likes"
WHEN `comments` IS NOT NULL AND `likes` OR `shares` IS NULL THEN "comments"
WHEN `shares` IS NOT NULL AND `comments` OR `likes` IS NULL THEN "shares"
WHEN `likes` IS NULL AND `comments` OR `shares` IS NOT NULL THEN "likes, shares"
WHEN `shares` IS NULL AND `likes` OR `comments` IS NOT NULL THEN "likes, comments"
WHEN `comments` IS NULL OR `likes` OR `shares` IS NOT NULL THEN "comments, shares"
WHEN `comments` AND `likes` AND `shares` IS NOT NULL THEN "likes,comments,shares"
WHEN `comments` AND `likes` AND `shares` IS NULL THEN "none"
ELSE 0
END
)