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.
