How can I make a language drop-down filter?

Looker Q&A Looker Studio
1

hi guys,

my google ads campaign’s name be like: XXX_EN_Search_US_XXXX. EN refers to English language.

I am creating a campaign report in data studio, using campaign as dimension and cpc, impr. share as metrics. Now I wanna make a drop-down list to filter the English campaign, how can i write the formula? I have tried to use :

CASE
WHEN CONTAINS_TEXT(Campaign, ‘EN_’) THEN ‘EN’
WHEN CONTAINS_TEXT(Campaign, ‘JP’) THEN ‘JP’
ELSE ‘Others’
END

but failed, the report shows user configuration error, i am wondering why?

2

Your formula looks right to me! I tested it and everything works fine.

Can you elaborate more on the user configuration error? It might be unrelated to the new calculated field.