Keyword Labeling

Looker Q&A Looker Studio
1

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?

2

First off, please post future Looker Studio questions like this to the Studio queue (not modeling).

If your Average Position is a measure itself, that is your problem. You cannot use a measure (an aggregation of multiple data rows) to create a dimension (something with a value on each data row). Update your data source, perhaps with a subquery, to make Average Position into a dimension.

If that answers this question, great! If not, please repost in the correct queue.