Unlocking Geographical Analysis with Looker Studio's TOCONTINENT Function: Features, Examples, and Expert Tips

 Unlocking Geographical Analysis with Looker Studio's TOCONTINENT Function: Features, Examples, and Expert Tips

Google Data Studio presents a bagful of powerful functions among which one of the most cryptographic ones is the TOCONTINENT. As the name suggests, this function has been designed with the objective to unravel the continent name for a certain geolocation. In other words, it essentially returns the continent name of a specified geolocation.

How Does the TOCONTINENT Function Work?

Gracefully fitting into the syntax

TOCONTINENT(X [,Input Format])
, this function operates using some specific parameters. The parameter 'X' can either be a text or a geo field or even an expression. The other parameter
Input Format
is utilized to define the format for the text field X, though it is optional if X is appropriately set up as a geo field.

In the case of the

Input Format
, TOCONTINENT accepts SUBCONTINENT_CODE, COUNTRY_ISO_CODE, and REGION_ISO_CODE as inputs if X is a text field.

The usage of the function is described as

TOCONTINENT(Subcontinent Code)
, where Subcontinent code refers to a code that represents a specific subcontinent.

Diving into the Examples

It's a great time to dive into some examples. Knowing how to use the function can come handy while dealing with sales metrics.

Let's consider that you are organizing a sales campaign and would like to measure the effectiveness segregated by continents. Upon using the function properly, the data studio can provide the sales data sorted by continents.

markdown
Example: TOCONTINENT(Sales.Region_ISO_CODE)
In this case, the 'Region_ISO_Code' is assumed to represent the sales from different regions in a coded form, following the global ISO standard for regions. The result of this function would be a column listing the name of the continents.

markdown
Example: TOCONTINENT("IN")
In the above instance,
IN
is the country ISO code for India. The function will return
Asia
, the continent where India is located.

Sets of Limits and Constraints

Even though TOCONTINENT is an incredibly powerful function, it does have certain constraints. It doesn’t necessarily infer the continent name from all codes. It is possible that there could be an unknown or non-standard code in the list, which might not return a result. Therefore, it is generally suggested to ensure that the geolocation data used conforms with the input format requirements.

Expert Tips to Master the TOCONTINENT Function

Building expertise with the TOCONTINENT function is quite simple. Always ensure that the ISO standard is maintained while using country codes or region codes. Also, the more correctly you use a geo field, the lesser need would be there to use the

Input Format
.

The TOCONTINENT function indeed unlocks a new dimension while organizing and analyzing data, particularly geographical data. It makes the task of segregating data based on places significantly easier and more accurate.

More function to use with Looker Studio

TODAY
:
Utilizing the TODAY Function for Real-Time Data Evaluation in Looker Studio: Understanding Its Working, Examples, Limitations, and Tips
CEIL
:
Working with number and the CEIL function in Looker Studio
MIN
:
Mastering the MIN Function in Looker Studio: A Comprehensive Guide on Data Analysis and Visualization Tools
COUNT_DISTINCT
:
Looker Studio function : COUNT_DISTINCT
STDDEV
:
Understanding the Power of the STDDEV Function in Looker Studio for Improved Data Analysis and Strategic Decision Making

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!
Looker studio

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!