Setting properties for Map chart

You need to set chart properties for the charts that you add to a widget.

Before you begin

Your source data must contain the following mandatory columns for the chart to be plotted properly. The column names can differ but the data within the columns must match.

Latitude

This column must contain all the standard latitudes of the continents and countries to be mapped. The Global Positioning System (GPS) coordinates for the latitudes must be in decimal degree format. South latitudes must be indicated with a minus sign.

For example, 8.7822^oS must be indicated as -8.7822

Longitude

This column must contain all the standard longitudes of the continents and countries to be mapped. The GPS coordinates for the longitudes must be in decimal degree format. West longitudes must be indicated with a minus sign.

For example, 55.7822^oW must be indicated as -55.7822

Map

This column must contain one or more of the following entries. The following list provides the country or continent names that are sorted alphabetically. The names are case-insensitive but must be in the provided formats.

world
asia
africa
australia
europe
north_america
south_america
china
brazil
france
germany
india
malaysia
mexico
united_arab_emirates
united_kingdom
united_states_of_america

The listed maps are the only maps that are supported by Designer tool. Any locations other than the ones listed earlier are not displayed on Designer tool. Therefore, if the source data contains unsupported locations, then those maps are not displayed on Designer tool.

For all the unsupported locations, you must enter null as a value in the Map column and for supported locations, the entries in your source data must match with the ones that are provided in the list.

For example, if one of the entries in the Map column is united states of america, then it does not match with the database entry and the map is not displayed.

ID and Parent

The entries in the ID and Parent columns must match. Nested maps are created based on the correlation that exists between these columns. To view nested maps, you must click any data point on the published or previewed Map chart. The nested map is displayed as a drill-down map. You can drill down to up to three map-levels only. To go back to the parent map, you must refresh the dashboard or widget.

If you do not want nested maps to be created, then you must enter null as a value for that particular location.

Display name

This column must contain the names of the locations to be plotted.

Procedure

Setting Series properties

Complete the following steps to set series properties:
1. On the widget page, click the Set Properties icon.
  
  The Set Properties window opens.
2. Click the CHART tab.
3. In the left navigation pane of the CHART tab, click SERIES.
4. In the MAP pane, in the following fields, enter the required column names from the custom data definition preview. Enter only those column names that are required to plot a map.
  - Latitude
  - Longitude
  - Display name
  - ID
  - Parent
  - Map
  Note: Nested maps are generated based on the ID, Parent, and Map fields.
5. In the KPIs pane, complete the following steps:
  1. In the Data Definition column field, enter the required column names from the custom data definition preview. Enter only those column names that you want to display on the chart.
    Note:
    
    You can specify maximum five column-names that signify key performance indicators (KPIs).
    
    If you want to assign a default shape or icon to a specific KPI value, then you must enter its KPI column name first.
  2. In the KPI tooltip field, enter a tooltip for each column.
  3. In the Unit field, enter a unit for each column value.
  4. From the Unit position list, select a unit placement.

Setting chart properties

In the left navigation pane of the CHART tab, click CHART, and complete the following steps:
1. From the Map to be Plotted list, select the map that you want to plot.
2. In the Define shape or icon indicators pane, complete any one of the following steps:
- To specify a default shape for all the KPIs that are displayed on the parent as well as nested maps, click Default shape indicator for all the maps, and complete the following steps:
  1. From the Shape list, select a shape.
  2. To render the chart by using the theme colors, click As per Theme.
    The map is rendered according to the theme that is applied on Engine.
  3. To render the chart by using custom colors, click Custom, and click the colored box next to it.
    The Color window is displayed.
  4. Select a color and click OK.
- To specify a default shape or icon for specific KPI string values, click Default shapes or icons for specific KPI strings, and complete the following steps:
  1. In the KPI field, enter any data definition column name that you entered in the KPIs pane, in the SERIES tab.
  - To specify default shapes for specific KPI values, under Indicators, click Shapes, and complete the following steps:
    1. In the Value field, enter a specific value for which you want to specify a shape.
    2. From the Shape list, select a shape.
    3. Click the colored box under Color to open the Color window, and click OK.
    4. Click Add Another and repeat the steps to specify more KPI values, their shapes, and colors.
    5. To delete a KPI value and the shape that you assigned to it, click the Delete icon that is displayed next to it.
  - To specify default icons for specific KPI values, under Indicators, click Icons, and complete the following steps:
    1. In the Value field, enter a specific value for which you want to specify an icon.
    2. Click Select icon, browse to the location where the icon images are saved, select an image file, and click Open.
      The icon is displayed next to the value field. The width and height of the icon is also displayed.
      
      Note: Use a transparent image of size less than or equal to 14x14 pixels.
    3. Click Add Another and repeat the steps to specify more KPI values and their icons.
    4. To delete a KPI value and the icon that you assigned to it, click the Delete icon that is displayed next to it.
- To specify a default shape or icon for specific KPI string values, click Default shapes or icons for threshold values or ranges of a specific KPI, and complete the following steps:
  1. In the KPI field, enter any data definition column name that you entered in the KPIs pane, in the SERIES tab.
  - To specify a default shape for a specific KPI value range, complete the following steps:
    1. Under Indicators, click Shapes.
    2. Under Define Threshold based on, click Range.
    3. In the Range fields, enter or select range values for which you want to specify a shape.
    4. From the Shape list, select a shape.
    5. Click the colored box under Color to open the Color window.
    6. Select a color and click OK.
    7. Click Add Another and repeat the steps to specify more KPI values, their shapes, and colors.
    8. To delete a KPI value and the icon that you assigned to it, click the Delete icon that is displayed next to it.
  - To specify a default icon for a specific KPI value range, complete the following steps:
    1. Under Indicators, click Icons.
    2. Under Define Threshold based on, click Range.
    3. In the Range fields, enter or select range values for which you want to specify an icon.
    4. Click Select icon, browse to the location where the icon images are saved, select an image file, and click Open.
      The icon is displayed next to the value field. The width and height of the icon is also displayed.
      
      Note: Use a transparent image of size less than or equal to 14x14 pixels.
    5. Click Add Another and repeat the steps to specify more KPI value ranges and their icons.
    6. To delete a KPI value range and the icon that you assigned to it, click the Delete icon that is displayed next to it.
  - To specify default shapes for specific KPI values, complete the following steps:
    1. Under Indicators, click Shapes.
    2. Under Define Threshold based on, click Value.
    3. In the Value field, enter or select a specific value for which you want to specify a shape.
    4. From the Shape list, select a shape.
    5. Click the colored box under Color to open the Color window.
    6. Select a color and click OK.
    7. Click Add Another and repeat the steps to specify more KPI values, their shapes, and colors.
    8. To delete a KPI value and the icon that you assigned to it, click the Delete icon that is displayed next to it.
  - To specify default icons for specific KPI values, complete the following steps:
    1. Under Indicators, click Icons.
    2. Under Define Threshold based on, click Value.
    3. In the Value field, enter a specific value for which you want to specify an icon.
    4. Click Select icon button, browse to the location where the icon images are saved, select an image file, and click Open.
      The icon is displayed next to the value field. The width and height of the icon is also displayed.
      
      Note: Use a transparent image of size less than or equal to 14x14 pixels.
    5. Click Add Another and repeat the steps to specify more KPI values and their icons.
    6. To delete a KPI value and the icon that you assigned to it, click the Delete icon that is displayed next to it.

Setting color properties

In the left navigation pane of the CHART tab, click COLORS, and complete the following steps:
- If you want the chart to be displayed according to the default color theme, click As per Theme.
- If you want to define custom colors for each map level, click Custom Colors per Level, and complete the following steps to set background, border, and label colors:
  1. Click each of the list boxes, such as BG, Border, and Label.
    The Color window is displayed.
  2. Select a color and click OK.
  3. To define colors for another level, click Add for another level, and repeat the steps.
  4. To delete custom colors that are defined for a map level, click the Delete icon that is displayed next to that level.
Note: You can define maximum three map-levels.