This section contains the different customization options for Filled and Symbol maps.
Assign a Geographical Role
City, State/Province, and/or Country
Visual Analytics automatically assigns geographic roles (city, state/province, and country) to string dimensions 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.
Longitude and/or Latitude
Visual Analytics automatically assigns geographic roles (Latitude and Longitude) to number fields (whether dimension or measure) with common geographical names such as; Longitude and Latitude. You can also assign geographical roles to any number field by right-clicking on the measure and clicking a Geographical Role option. Visual Analytics changes the measure to continuous dimension. The string changes to icon.
Latitude and Longitude support is only applicable to Symbol Map.
Change Country Codes
Visual Analytics supports identifying country locations by using a two-character code based on the Federal Information Processing Standard (FIPS) or a two-letter code (alpha-2) or a three-letter code (alpha-3) country codes on the International Standards Organization (ISO).
By default, when Visual Analytics finds a country value that is 2 characters in length, it attempts to match the value using ISO alpha-2 country codes. If your dataset contains FIPS codes, you should change the 2-char code selection of Country geographic role to FIPS.
Country Name | ISO alpha-2 | ISO alpha-3 | 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
Edit Locations
Sometimes, Visual Analytics cannot recognize locations in your geographical data and displays them as unrecognized or ambiguous. The following table contains the description for unrecognized and ambiguous locations.
Location | Description |
---|---|
Unrecognized | Visual Analytics does not recognize state or city names when:
|
Ambiguous | Visual Analytics finds ambiguity in state or city names when your geographical data contains:
For example, Sydney is present in Australia and Canada. When Visual Analytics plots cities, it considers Sydney ambiguous if a country or a state is not specified. See, Resolve Ambiguous Locations. |
Visual Analytics disables the Edit Locations option when building a symbol map chart with Latitude and Longitude geographical dimensions.
Resolve Ambiguous Locations
To resolve ambiguous locations
- Download and connect to the sample data source in Aqua Data Studio.
- Build a Filled Map chart.
- On the Visual Analytics menu bar, click Analysis > Map > Edit Locations.
Visual Analytics listed Florida, Maryland, Montana as ambiguous/unknown locations because the country role is not specified. When country is not specified, Visual Analytics searches geographical data against a worldwide dataset and displays these states as ambiguous because similar state names are present in other countries.
4. In the Country list, click Fixed, and then from the adjoining list, select United States.
5. 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
Visual Analytics 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.
To show/hide borders
- For Filled Map, in the Chart Properties Deck, click Options.
- For Symbol Map, in the Chart Properties Deck, click Geo.
Other Actions
Other actions that you can perform on a plotted map are as follows:
- You can sort data by using various sort options available in the chart view or the Advanced dialog. For more information, see Sorting.
- You can use highlight actions to focus on selected part of the map. Visual Analytics makes the highlighted selection and its data labels prominent while dimming others in the view. For more information, see Highlight Actions.
- You can filter records directly from the chart view without manually adding any fields to the Filters Deck. For more information, see Filters.
- You can export worksheets containing visualization to Image, HTML, and PDF formats. For more information, see Export Visualizations.