Looker Studio Function: Looker Studio TOSUBCONTINENT Complete Guide with Examples : Use case
Category: GEO Function
The TOSUBCONTINENT() function in Looker Studio converts a geographic or country field into a subcontinent name, such as Southern Asia, Northern Europe, Western Africa, etc. It is especially useful for building advanced geo dashboards, strategic regional segmentation, and multi-level analytics between continent and country views.
Purpose TOSUBCONTINENT of the Function
1. Sub-Regional Performance Insights
TOSUBCONTINENT() helps analyze performance metrics across specific subcontinent regions, offering deeper visibility beyond just country or continent categories.
2. Market Segmentation & Targeting
Marketers can group users by subcontinent to build more accurate segmentation models and improve localized strategies.
3. Dashboard Readability & Visualization
Allows creation of clean geographic heatmaps and reports by using broader yet more granular geo classifications.
Type of Calculation & Practical Use Cases
✅ Subcontinent-Wise Revenue or Sales Reporting
Evaluate revenue distribution by subcontinent to identify emerging and high-value markets.
✅ Customer Behavior Insights
Group users by location clusters such as South-East Asia or Northern Europe.
✅ Strategic Expansion Planning
Compare KPIs across multi-regional zones for decision-making.
✅ Enhanced Geo Charts
Improve visual dashboards by replacing cluttered country-level breakdowns.
TOSUBCONTINENT(geo_field)
| Parameter | Type | Description | |
|---|---|---|---|
| geo_field | Geo / Country / Location |
| |
How Does the TOSUBCONTINENT Function Work?
TOSUBCONTINENT() reads a geographic reference from the provided field and returns the appropriate subcontinent grouping name, such as:
| Country | Output (TOSUBCONTINENT) |
|---|---|
| India | Southern Asia |
| France | Western Europe |
| Egypt | Northern Africa |
| Brazil | South America |
.
When Should You Use TOSUBCONTINENT()?
Use this function when:
You need mid-level geographic grouping between continent & country
Building global dashboards with regional performance KPIs
Running segmentation based on sub-regional customer distribution
Visualizing multi-regional heatmaps and trends
It converts geo or country data into standardized subcontinent groupings for advanced regional analytics.
No, it requires a geo-type field or recognized location values.
No, it only transforms data visually within Looker Studio.
It groups customers and KPIs by geographic clusters for strategy and reporting.
Yes, it enhances readability and usability in map heatmaps and global dashboards.
Established in 2020, Lets Viz Technologies provides a full range of high-quality data analysis and data visualization services. We are also an authorized Zoho Partner.
Sitelinks
