Data Studio
2.1K members online now
2.1K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

How to combine languages

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I want a pie chart showing the visitors' languages.

 

Unfiltered it returns en-us, en-gb and en as separate segments and I would like to combine them all into just one - ie, just en. Same goes for other languages such as fr-fr/fr and it-it/it.

 

Can anyone tell me how I can achieve this please?

 

Thanks

 

Peter

1 Expert replyverified_user

How to combine languages

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

 Bump... anyone?

How to combine languages

Google Employee
# 3
Google Employee

You should be able to group languages together by creating a calculated field that uses a text function like REGEXP_EXTRACT, SUBSTR, or CASE.

 

Have you given that a try?

How to combine languages

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

I've got the same issue. I've tried building a filter, but that only allows me to filter everything but English. I can't get it to return all of the languages.

To be clear:  instead of en_us, en_gb, fr_ca, fr_fr, I want it to return all English grouped, all French grouped, etc.