Looker Studio rename output of city metric

195 Views Asked by At

Some city data is being returned with "(not set)" which I've figured out how to filter out via regex BUT I would instead like to change it to something else eg "(Unset Location)" or similar. Is this a possibility?

1

There are 1 best solutions below

0
Jacksonkr On BEST ANSWER

Pretty straight forward, as I'd originally hoped. I created a custom dimension and used the following for the formula input.

REGEXP_REPLACE(City, '^\\(not set\\)$','Undetermined')

Steps:

  1. Select "Add dimension"

enter image description here

  1. Select "CREATE FIELD"

enter image description here

  1. Insert Formula

enter image description here