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.
