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. 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 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.

Zip code

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:

  1. Navigate to any geo chart that you have edit privileges for.

  2. Select the chart configuration icon chart configuration icon on the left side of your screen.

  3. Select Settings in the Edit chart panel.

  4. Open the Map type dropdown menu, 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:

Geo chart light type
Geo chart outdoors type
Geo chart dark type

Limitations

Geo charts do NOT support conditional formatting.