A map chart can be used to tag metrics against geographical locations on a map view. You can create map charts using location specific columns in your data. This location information can be continent, country, county, state/province, city, zip code, latitude and longitude, or even IATA airport codes, which are used to identify airports and metropolitan areas around the world.
Analytics Plus allows you to visualize geographical data using map charts. To create a map chart, your data set should contain location specific columns. During data import, Analytics Plus auto-identifies the columns that contain geographical data in your data set.
Analytics Plus will auto-identify geographical columns i.e. columns that contain information about continents, countries, counties, states/provinces and cities. However, to create map charts using columns containing zip code, or latitude and longitude, the data type of the column needs to be changed manually. To do this,
- Right-click on the specific column header, and select the Change Data Type option.
- Select the appropriate Geolocation data type from the drop-down, and click OK.
Note: You can also create a map chart without changing the data type of your column, using the Treat as Geo option in the chart designer. When you use this option, the data type of the column will be considered as Geo Data within the scope of that specific report.
Map - Scatter: Data points are represented as scatter plots on a map view.
Map - Bubble: This chart is a variation of the Map - Scatter chart in which data points are replaced with bubbles.
Map - Pie: This chart is a variation of the Map - Scatter chart, with the data points represented as pie charts.
Map - Bubble Pie: This chart is a variation of the Map - Pie chart, with the data points represented as Bubble Pies. The size of the pie chart is determined by the column dropped in the Size field.
Map - Filled: Fills the region of the location dropped in the X-axis. Countries, cities, and other locations are color-coded on the map based on the column in the Color field.
Geo Heat Map: Data points are displayed on a map, color coded based on the density of data points.
Follow the steps below to create a map chart in Analytics Plus:
Step 1: Click the +Create button from the side panel, and select the Chart View option.
Step 2: Drag and drop the Geo location columns in required fields, and click the Click here to Generate Graph button. You can change the chart type with the More Charts option.
Analytics Plus allows you to create a map chart that displays only the specified countries. To do this, click the Settings icon at the top right corner of your map chart, and navigate to the Maps tab. Select the Display Specific Country map option, choose the required countries from the drop down, and click Apply.
You could interact with the map chart using the following options available in the panel.
Search - This option allows you to search for any location on the map.
Home - This option returns the map chart to its original dimensions. You can also customize the map chart's default home screen.
Grab Area - You can use this option to select a required area on the map, and zoom in.
In addition to these map chart interactions, options such as drill down, view underlying data, and legend filter will also be applicable.
You can customize your map chart using the options in the Settings menu. Click the Settings option in the toolbar, and navigate to the Map tab. The various customization options in the Map Chart Settings page are:
Theme: This option allows you to change the theme of the map. You can also change your map chart to a satellite chart using the Satellite option.
Invert Color: This option allows you to invert the colors in the map chart, and is not applicable for Satellite themed maps.
Data Label: Displays the Y-axis values on the map.
Fill Opacity: You can specify the opacity of the chart series color. This option is not applicable for Map - Scatter charts.
Markers Type: You can select the type of the marker that you wish to display. This option is applicable only for Map - Scatter charts.
Display Specific Country Map: This option allows you to display specific countries in the map chart. To learn more, click here.
Heat Radius: You can specify the boundary to combine the data points for heat calculation. This option is applicable only for Geo Heat map charts.
Heat Intensity: This option allows you to customize the intensity of heat, and is applicable only for Geo Heat map charts.
Heat opacity: You can customize the opacity of the heat map. This is applicable only for Geo Heat map charts.
You can also customize your map chart to differentiate data based on the volume of occurrence by setting a continuous color range legend. To do this,
Click the Settings icon in the top right corner of your map chart, and navigate to the Legend tab.
Select the Continuous Band radio button, make changes to the palette and color if needed, and click Apply.
There may be cases where some locations are not categorized, due to issues in resolving geographical data such as ambiguous location names, misspelled locations, their colloquial name, etc. Such locations are listed as Unresolved locations in the panel. This option is visible in the Edit mode.
Resolving unresolved locations
You can resolve the unresolved locations in your map chart by providing additional information in one of the following ways.
Resolving through Geo column mapping
Mapping it to a country column: This allows Analytics Plus to identify the country in which the unresolved location is located and correct it automatically. Open the map chart in the Edit mode, and click the Unresolved locations icon. In the Edit Unresolved Locations screen that appears, navigate to the Geo Role in Column Mapping section. If you have a country column in your data set, select the Country option from the Country drop down to map the unresolved locations.
If there are no country columns present, but the states or cities all belong to a single country, use the Provide the Location option to enter the name of that country.
Mapping it to a state column: This allows Analytics Plus to identify the state in which the unresolved location is present, and resolve it automatically. If your data set contains a state column in addition to a country column, you can further map the unresolved locations to the corresponding state column as well. If there are no state columns, but the cities all belong to a single state, use the Provide the Location option to enter the name of that state.
You can also resolve these issues from your data table. Right-click the required column, and select the Set Geo Hierarchy option. This opens the Edit Unresolved Locations page and you can follow the steps mentioned above to resolve the locations.
Plot latitude and longitude
You can also resolve these location issues by specifying the latitude and longitude values in the Edit Unresolved Locations page.
Correct misspelled locations
Spelling errors in locations names can also result in unresolved locations. For example, "Hong Kong" could be misspelled as "Hongkong", or "Brooklyn" as "Broklyn". You can always correct spelling errors in the imported table, or change them in the original data before import.
Pick location for Geo data
You can also use the Geo location picker to resolve unidentified locations on map charts. Click the Pick Location link, search for the location in the map using the given search field, and click Apply. The latitude and the longitude values for the selected location will be auto-filled in the respective fields. Click Save to reflect the changes.