Map charts allow you to display geolocated data points using longitude and latitude data or standard regions like world countries and USA ZIP codes.

They can be used to:

• Visualize and compare sales performance across different regions or countries to identify high-performing areas and potential markets for growth.
• Provide clear insights into regional allocations to help sales teams optimize their strategy.
• Support supply chain performance by quickly identifying bottlenecks or inefficiencies in specific locations.

This guide outlines how to build and customize your Map chart.

Choose the appropriate Map chart

The Map chart has two main options:

1. Markers. Use markers to display information, such as accounts or suppliers, as points on the map.
2. Areas. Use areas to display information, such as revenue or headcount across regions or countries, on the map. You can define areas by country or ZIP code.

Configure a Map chart for markers

Use geolocated data points to configure a Map chart with markers. Markers are defined by latitude and longitude coordinates. They are used to represent locations, such as shops, manufacturing plants, or prospects.

Prepare the data set

You must create a Table to build a Map chart. To do this, prepare a data set that contains a minimum of:

• One Dimension. This is the primary Dimension that contains the Items you want to represent on the map (e.g., Account or Supplier). To display markers, the latitude and longitude data can be modeled as Metrics or Properties of the primary Dimension.
• One Metric. This Metric contains the primary Dimension (e.g., Account).

You can further customize your map using Metrics that contain the primary Dimension (e.g., Account) to represent:

• Text or descriptive data to customize the map, like tooltips or marker labels.
• Number Metrics to customize the size or the colors of the markers. Additional Dimensions can be included (e.g., Month) to adjust the data shown via Page Selectors (e.g., Revenue per Month).

Arrange data in a Table

Before you configure the chart with markers, you must create a Table and ensure that:

• The primary Dimension is in rows (e.g., Account or Supplier).
• Optional Dimensions are in Pages.
• Metrics are in columns.

Create the Map chart for markers:

1. Open the Table you created for your Map chart.
2. Select Chart.
3. In the Format panel, select Map chart (globe icon).
4. Select the primary Dimension from the dropdown.
5. Toggle on Marker in the Format panel.
6. Select the source data for both the Latitude and Longitude from the dropdown.
7. Select Customize display (optional) to customize your Map chart.
8. Select Save View.

Configure a Map chart for areas

Use areas to display information, such as revenue or headcount across regions or countries, on the map. You can define areas by country or ZIP code. These codes represent specific areas, such as entire countries or specific regions.

Prepare the data set

You must create a Table to build a Map chart. To do this, prepare a data set that contains a minimum of:

• One Metric. This Metric contains the primary Dimension.
• One Dimension. This is the primary Dimension that contains the Items you want to represent on the map (e.g., Country code or USA ZIP code). Country codes or ZIP codes can be modeled as a Metric or property of the main Dimension.

Arrange data in a Table

Before you configure the chart with areas, you must ensure that:

• The primary Dimension is in rows (e.g., Country, ZIP code).
• Optional Dimensions are in Pages.
• Metrics are in columns.

Create the Map chart for areas

1. Open the Table you created for your Map chart.
2. Select Chart.
3. In the Format panel, select Map chart (globe icon).
4. Select the primary Dimension from the dropdown.
5. Toggle on Area in the Format panel.
6. In the Type section, select World countries or USA Zip codes. Your Type selection must correspond to the data in your primary Dimension (e.g., country code or USA ZIP code).
7. Select Add area data source and choose the Dimension property or Metric containing either country codes or USA ZIP codes.
8. Select Customize display (optional) to customize your Map chart.
9. Select Save View.

Customize your Map chart

You can customize your Map chart in a number of ways to suit your data visualization needs. The following fields can be populated by Metrics in your Table or Dimension Properties of the primary Dimension.

In the Format Chart panel, click Customize display to access the following options:

Dynamic color

Select +Add Dynamic color and choose from the following options:

• Dimension Items: Use the Dimension Items color from the grid. Go to the Dimension block, click on Manage Items, and update the Item color property to customize these colors. You can only select List Properties and Metrics of Dimension type.
• Cell Background: Use the cell background colors from the grid Apply static or conditional formatting to the grid to customize these colors. By default, these are grey if no formatting has been applied.
• Cell Text: Use the cell text colors from the grid. Apply static or conditional formatting to the grid to customize these colors.

Initial position & Zoom level

You can set the Initial position and Zoom level of the Map to define where users first land and the magnification of the Map.

To set the Initial Position and Zoom Level:

1. Click Add.
2. Enter the Latitude and Longitude coordinates to define the Initial Position.
3. Adjust the Zoom level slider to set the default zoom for users. A higher number indicates a more magnified Map. USA ZIP Codes are visible from zoom level 6.
4. Click Save View.

Download CSV files