Geo charts
Geo charts show data on a map by location. There are three geo charts that let you visualize geographical data in ThoughtSpot: geo area, geo bubble, and geo heatmap charts. And these geo charts can display six types of geographical data, depending on territory:
-
Country
-
State
-
County
-
Zip code
-
Point (latitude/longitude)
-
Other sub-nation regions (for international countries)
ThoughtSpot supports maps for many countries. See the complete list in Geo Map Reference. If you would like to use a custom map to visualize your data, see Upload custom geo maps.
ThoughtSpot now supports maps for all countries. See the complete list in Openstreetmap supported countries. If you would like to use a custom map to visualize your data, see Upload custom geo maps.
Previously, ThoughtSpot supported the following geo chart capabilities:
-
Visualize data at the country level for multiple countries in one chart.
-
Visualize data at a higher level of detail (state, city, zip code) within one country at a time.
Now, ThoughtSpot supports the following capabilities:
-
Visualizations comparing subdivisions of multiple countries in a single visualization. For example, if a selected column contains data from cities in the United States and Mexico, all data would be displayed on a single visualization.
-
Visualizations displaying multiple levels of subdivisions within a country, rather than just city and zip code.
-
Visualizations representing zip code as an area within a region, rather than a point on a map.
To improve the accuracy of your Search, we recommend appending the country name, or adding a reference to the country that the data is referring to. To append the country name, you can use a formula such as concat (region, ', ' , country).
Displayed Geo data
Here is a table that shows which GeoType data can be displayed using which geo chart type.
| GeoType | Data Type | Geo chart type | Notes |
|---|---|---|---|
Country |
VARCHAR |
Geo area (default), geo bubble, geo heatmap |
Can also be regions. |
County |
VARCHAR |
Geo area (default), geo bubble, geo heatmap |
Only for counties in the United States. |
Latitude (point) |
VARCHAR or DOUBLE |
Geo bubble (default), geo heatmap |
Must use both latitude and longitude columns. |
Longitude (point) |
VARCHAR or DOUBLE |
Geo bubble (default), geo heatmap |
Must use both latitude and longitude columns. |
State |
VARCHAR |
Geo area (default), geo bubble, geo heatmap |
Only for states in the United States. |
Zipcode |
VARCHAR |
Geo bubble (default), geo heatmap |
Refer to the Geo Map reference to see which countries have supported zip codes. |
Other sub-nation regions |
VARCHAR |
Geo area (default), geo bubble, geo heatmap |
The display depends on the type of administrative region. |
For data to display in geo charts, your administrator must configure it as geographical data. If you don’t get an expected map visualization, contact your administrator so they can configure the system correctly.
See also:
Geo chart customizations
Geo charts allow you to customize the map display by changing the Map type.
To customize the Map type, follow these steps:
-
Navigate to any geo chart that you have edit privileges for.
-
Select the edit chart icon
on the left side of your screen. -
Select Settings in the Edit chart panel.
-
Click on the Map type dropdown, and select one of the options: Light, Dark, Outdoors, Streets, Satellite, or Satellite Streets. The default is Light.
For example, view the Light (default), Outdoors and Dark map types:
