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.
Gracefully fitting into the syntax
TOCONTINENT(X [,Input Format])Input FormatIn the case of the
Input FormatThe usage of the function is described as
TOCONTINENT(Subcontinent Code)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)markdown
Example: TOCONTINENT("IN")INAsiaEven 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.
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 FormatThe 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.
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)
