Reputation: 1
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?
Upvotes: 0
Views: 376
Reputation: 649
I noticed an error in your logic and have corrected it below, This code works for me to create a dimension from a calculated field. Let me know if I have misunderstood your question.
CASE
WHEN Average Position <= 10 THEN "High Ranking"
WHEN Average Position > 10 AND Average Position < 21 THEN "Mid Ranking"
WHEN Average Position >= 21 THEN "Low Ranking"
END
Upvotes: 0