Google Data Studio, a powerful tool for converting data into informative, easy-to-read, and customizable dashboards and reports, offers a myriad of intricately designed functions to aid data analysis and visualization. The 'TOREGION' function serves as one of these impressive commands available in Google Data Studio's arsenal.
'TOREGION' is a built-in function in Google Data Studio used for geographical purposes. Its main functionality lies in converting a given region identity (ISO code) into its full name. In simple terms, the 'TOREGION' function enables you to insert the ISO code of a region, like 'US-CA' for California, USA, and the function conveniently returns the full name of the region, in this case, 'California'.
The syntax of the 'TOREGION' function is relatively straightforward, comprising two primary parts:
TOREGION(X, Input Format)
Where
Please note that Google Data Studio requires the ISO codes to be in a specific format that follows the standard ISO 3166-2 subdivision codes.
To understand the function better, let's consider a scenario where you're working with sales data, and you want to convert region ISO codes to region names for better readability and understanding.
python
TOREGION("US-NY", "REGION_ISO_CODE")In the example above, "US-NY" is the ISO code for New York, USA. Hence, the 'TOREGION' function would fetch 'New York' as the output.
Similarly,
python
TOREGION("IN-MH", "REGION_ISO_CODE")"IN-MH" is the ISO code for Maharashtra, India. The output will be 'Maharashtra'.
The 'TOREGION' function, while efficient, has certain limitations:
In conclusion, the 'TOREGION' function in Google Data Studio is an excellent tool for presenting comprehensive geographical data without the confusion of complex ISO codes, making data analysis efficient and more understandable to audience.
Become a Looker Studio expert
for free
Learn all the secrets of data analysis and create beautiful and effective dashboards thanks to our 30-second video courses! Join Catchr's community on YouTube.
Get more video lessons
All your data on Looker Studio
Build Looker Studio dashboard easily with your marketing data from all platforms and track your essential KPIs! No-code integration.
Start free trial now!
Optimize your data analysis
Get free Looker Studio dashboard template among a large collection of +50 stunning template! Elevate your data visualization.
Get free templates!.png)
