Hi! I want to label Google Search Console keywords in Google Looker Studio. I tried doing to do so using a CASE as well as an IF function:
CASE
WHEN Average Position <= 10 THEN "High Ranking"
WHEN Average Position <= 20 THEN "Mid Ranking"
WHEN Average Position > 20 THEN "Low Ranking"
END
and
IF(Average Position <= 10, "High Ranking",
IF(Average Position <= 20, "Mid Ranking",
"Low Ranking"))
Both result in a metric containing the values "High Ranking", "Mid Ranking" and "Low Ranking". However, I want this to be a dimension. Any suggestions?