Map options

The map visualizations display results on a geographic map. The query result set must include the appropriate geographic data:

• Choropleth: Geographic localities, such as countries or states, are colored according to the aggregate values of each key column. The query must return geographic locations by name. For an example, see choropleth example.
• Marker: A marker is placed at a set of coordinates on the map. The query result must return latitude and longitude pairs. For an example, see marker example.

Choropleth options

This section covers the options for choropleth visualizations.

General

To configure general options, click General and configure each of the following required settings:

• Map: Which geographic map to use. One of Countries, USA, or Japan/Prefectures. The results in the key column must appear in the map you choose.

• Geographic column: The column containing the locations for the map.

• Geographic type: The format of values in the key column. One of Abbreviated name, Short name, Full name, ISO code (2 letters), ISO code (3 letters), ISO code (3 digits):

  Format	Value
  Abbreviated name	U.S.A, Brazil
  Short name	United States, Brazil
  Full name	United States, Brazil
  ISO code (2 letters)	US, BR
  ISO code (3 letters)	USA, BRA
  ISO code (numeric)	840, 076

  If a geographic column value doesn't match one of the target field formats, no data is shown for that locality.

  For more information on supported map values and their corresponding abbreviated values, see Supported map values.

• Value Column: Aggregates the result per key column.

Colors

• Clustering mode: How data is segmented into steps along the color gradient.
  • Equidistant (default): Results are segmented into the number of segments you specify in the Steps field, and each segment's range is the same size.
  • Quantile: Results are segmented into a number of segments less than or equal to the value you specify in the Steps field, where each segment contains the same number of results, regardless of the segment's numeric range.
  • K-mean: Results are segmented into the number of segments you specify in the Steps field, and the results in each segment are clustered near a common mean.
• Steps: The number of colors to use inclusive of Min Color and Max Color in the map and the legend. If Clustering Mode is Quantile, there may be fewer steps than you specify here.
• Min Color: The color for the lowest value range.
• Max Color: The color for the highest value range.
• No Value Color: The color for locations with no result in the query. Often, this color is outside of the gradient range between Min Color and Max Color.
• Background Color: The color for the map background.
• Border Color: The color for borders between locations.

Format

• Value format: Optionally override the automatically detected format for the value column.
• Value placeholder: An optional value to display for locations with no results. Defaults to N/A.
• Show legend: Uncheck to disable the legend.
• Legend position: Where in the visualization to display the legend.
• Legend text alignment: How to align text in the legend.
• Show tooltip: Whether to display a tooltip when you hover your cursor over a location.
• Tooltip template: An optional value to override the template used for tooltips.
• Show popup: Whether to display a popup when you click a location.
• Popup template: An optional value to override the template used for popups.

Bounds

To show only a portion of the map in the visualization, you can configure coordinates for the four corners of the area to show. You can set the coordinates manually, zoom in or out, or use the rectangular selector.

Marker options

This section covers the options for marker visualizations.

General

• Latitude column: Latitude portion of the coordinate pair.
• Longitude column: Longitude portion of the coordinate pair.
• Group by The column to use for grouping, if different from the original query.

Format

• Show tooltip: If selected, a tooltip displays when you hover the mouse over a marker in the visualization.
• Tooltip template: Override the default tooltip template using a format you specify.
• Show popup: If selected, a popup displays when you click a marker in the visualization.
• Popup template: Override the default popup template using a format you specify.

Style

• Map tiles: Override the default map tiles with one of the included sets.
• Cluster markers: If selected, markers that are near to each other are clustered into a single marker that indicates the number of markers in the cluster.
• Override default style: If selected, you can override the marker shape, icon, color, background color, and border color.

To hide a series in a visualization, click the series in the legend. To show the series again, click it again in the legend.

To show only a single series, double-click the series in the legend. To show other series, click each one.

Supported map values

The following table lists supported map values and their corresponding abbreviated values.