× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Like  

How to Make a Filled Map Chart

Filled Map is a powerful geographic visualization of data and displays how data differs across geographies or a region. It is useful in analyzing the data distribution across the geographic locations, viewing quantitative data on a map for critical regions, and reading plotted data in different colors and shades easily.

Download and connect to the sample data source. We are making this chart using 1 geo dimension and 1 measure.

Contents

Build a Filled Map Chart

To build a Filled Map Chart 
  1. Connect to the sample data source in Aqua Data Studio.
  2. From the Dimensions pane, select Country.
  3. From the Measures pane, select % English Speakers.
  4. Click the  tab and then click . Visualization builds a Filled Map Chart. 

    Visualization moves Country to the Break Deck and the % English Speakers to the Color Deck. After customizing the measure color gradient, you can view the countries with most English language speakers. For information on how you can customize the measure color gradient, see Chart Properties Color. If you want to display the country names, then click  on the Visual Analytics submenu.

Assign a Geographical Role to a Dimension

Visual Analytics automatically assigns geographic roles to only string dimension with common geographical names such as City, State/Province and Country. You can also manually assign a geographical role to a string dimension that contains geographical data.
 
To assign a geographical role to a dimension
  • In the Dimensions pane, right-click the dimension > Geographical Role > click the desired role. The  string changes to  icon.

Change Country Codes

Visualization identifies different country locations using a two-character code based on the Federal Information Processing Standard (FIPS) and a two-letter code (alpha-2) or a three-letter code (alpha-3) on the International Standards Organization (ISO). By default, Visualization uses ISO code for identifying and plotting country on the map. If your dataset contains FIPS code, then you can change this code in the UI. The following table list some examples for FIPS and ISO codes.
Country Name  ISO 2-alpha ISO 3-alpha FIPS
AUSTRIA AT AUT AU
AUSTRALIA AU  AUS AS
CANADA CA  CAN CA 
INDIA IN IND IN
GERMANY  DE DEU GM
To change the country code if your dataset contains a different code
  1. Right-click Country > Geographical Role > Country.
  2. Click the code.

Edit Locations

Sometimes Visual Analytics cannot recognize locations in your geographical data and displays them as unrecognized or ambiguous. The following table provides the description for unrecognized and ambiguous in Visual Analytics. You can resolve these issues using the Edit Locations window. 
Location Description
Unrecognized
Visual Analytic does not recognize state or city names when:
  • State or city names are different than the officially recognized names. When this happens, you can correct your source dataset.
  • Incorrect combination of country, state, or city in the dataset. For example, if you have the United Kingdom as the country and San Francisco as the city.
Ambiguous
Visual Analytic finds ambiguity in state or city names when your geographical data contains:
  • Multiple occurrences of state or city name across the world. 
  • Multiple occurrences of state or city names for the country that you want to plot.
Visual Analytic considers these states or cities as Ambiguous. For example, Sydney is present in Australia and Canada. When Visual Analytics plot cities, it will consider Sydney ambiguous if you a country or a state is not specified.
 

Resolve Ambiguous Locations

To resolve ambiguous locations

  1. On the Visual Analytics menu bar, click Analysis > Map > Edit Locations.

    Visual Analytics has listed Florida, Maryland, Montana as ambiguous/unknown locations because you have not provided a country role, and, therefore, Visual Analytics plots geographical data on the world map and not for a specific country. It displays these states as ambiguous because similar state names are present in other countries.

  2. In the Country list, click Fixed, and then from the adjoining list, select United States.
  3. Click OK. As you have restricted Visual Analytics to search only in the United States, it identifies and plots these states correctly on the map of United States.

Show/Hide Borders

Visualization gives you the control to show state borders for the country whose data is plotted. The borders add clarity between different states of the plotted country. By default, the state borders appear for the plotted data. If you want to show/hide borders, then in the Chart Properties Deck, click Options.

 

Last updated by ambikasingh(*) on May 30, 2016 6:56 AM
This list is empty.

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017