Assign data columns to vector map

To display data in a widget, you must assign the relevant data source columns to the required widget elements. For example, you can select a data column to display its values as dimension values on the X-axis.

A vector map allows you to interact with a vector-based online map and to visualize geographic areas of interest.

Even without any data assignments, based on the template chosen, you can select regions on the map. This allows you to trigger selection events and to filter other widgets.

Prerequisite

You have assigned a data source to the widget.

Procedure

  1. Click a Vector map widget on the dashboard. The relevant properties dialog is displayed.

  2. Click Assign data Assign data to edit the data source assignment.

    The Assign data (2/2) dialog is displayed.

  3. Assign a data column containing region identifiers to the ID element using drag and drop.

  4. Assign a data column to the Region value element using drag and drop. The element provides numeric values for the individual regions.

  5. Assign a data column to the Region name element using drag and drop. The element provides names for the individual regions that are used for the labels & tooltips.

The data source columns are assigned to the widget elements.

You can further configure the widget as follows:

Set properties of widget elements

For each widget element, such as axis, dimensions or measures, you can edit the settings, for example, axis title, display name or format.

Various settings are available depending on the data type of the assigned data source column. See the Options list below for details.

Procedure

  1. Click the source column assigned to the ID and specify the display name and the initial selected value.

  2. Click the source column assigned to the Region value.

    1. Click the Text tab and make your settings..

    2. Click the Thresholds tab to specify the KPI thresholds. See Configure KPI thresholds for details

  3. Click the source column assigned to the Region name and make your settings.

  4. Click OK to save your settings and to close the dialog.

The chart is displayed in the dashboard with real data of the assigned data source.

Options list

Option

Description

Display name (data point)

New column name displayed in the widget, for example, used for KPI, data points or tool tips. By default, the data source column name is used.

Initial selected value

Initial selected ID. If an ID is specified, the corresponding region will be selected by default.

Text tab

Enables you to specify the column settings.

Thresholds tab

Enables you to specify the threshold values range and to set the background and graphic color.

Aggregation

Specifies how the KPI value is calculated. Available for numeric columns. Default is Average value.

The number of aggregation types provided by context-based widgets may differ from that of non-context-based widgets.

Format

Output format of the column values, for example, used for data points or tool tips. Available for columns of date and numeric type.

For details on setting the date format, refer to the chapter Change data type - single value.

Note that the pattern for the day of the week used in the Assign Data 2/2 dialog is different from the pattern used in data feed processing. For the date format of the day of the week, you must use the pattern dddd instead of eeee as in the data feed processing. For example, the format dddd.MM.YYYY returns Monday.12.2019.

Round numerically

Displays rounded KPI values in the chart. Available for numeric columns. Enabled by default.

Configure KPI thresholds

You can define thresholds for numeric KPIs to display their status. A colored background shows the threshold range in which a KPI value is located.

Procedure

  1. Click a Color box to select a background color for each threshold.

  2. Select an operator for each threshold to define the KPI value range, for example, < (less than).

  3. Enter a value for each threshold.

    You can either enter specific threshold values or you can choose columns from your data source representing dynamic threshold values. Only numeric values are valid as dynamic threshold values. Assign the required numeric data column from the data source to a threshold field using drag and drop.

  4. Click the Add Plus button to add a threshold or click the Remove Minus button to remove a threshold.

The thresholds are configured for the selected widget.