Exploring the TOREGION Function in Looker Studio: A Comprehensive Guide to Region Identification and Visualization

 Exploring the TOREGION Function in Looker Studio: A Comprehensive Guide to Region Identification and Visualization

Introduction to TOREGION Function in Google Data Studio

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'.

How Does TOREGION Function Work?

The syntax of the 'TOREGION' function is relatively straightforward, comprising two primary parts:

TOREGION(X, Input Format)


  • X denotes a text field. It represents the region ISO code you wish to convert.
  • Input Format is the format for the text field X. In the case of 'TOREGION', the input format is represented as 'REGION_ISO_CODE'.

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.

Illustrative Examples of the TOREGION Function

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.


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.



"IN-MH" is the ISO code for Maharashtra, India. The output will be 'Maharashtra'.

Limitations of the TOREGION Function

The 'TOREGION' function, while efficient, has certain limitations:

  1. It doesn't recognize ISO codes for cities or smaller divisions. It only works with larger regions like states or countries.
  2. The function might not identify outdated or new ISO codes that aren't yet established or are no longer in use.

Tips To Use TOREGION Function Effectively

  • Always ensure the ISO codes are correct and precisely formatted to avoid any errors.
  • When working with global or multinational data, using the 'TOREGION' function can help simplify your data for better understanding and readability.

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.

More function to use with Looker Studio

Mastering the LOWER Function in Looker Studio: Enhancing Data Consistency and Accuracy in Data Analytics
Looker Studio Studio's Magnificent Cosine Functionality
Understanding the TAN Function in Looker Studio: Features, Syntax, Practical Applications, Limitations, and Tips for Optimal Usage
Utilizing the MINUTE Function in Looker Studio for Precise Temporal Data Analysis and Report Generation
Unveiling the ACOS Function in Looker Studio