Assign data sources to widgets

Before you can display content in a widget, you must first assign a data source to this widget.

You can define dynamical and reusable input parameters for several data sources, for example, XML, JSON, or ARIS Table. See Create input parameters. Data sources are not required for Input field and Image widgets.

Procedure

  1. Create a dashboard or open a dashboard in the dashboard editor.
  2. Click a widget on the dashboard. The relevant properties dialog is displayed.
  3. Click Assign data Assign data to edit the data source assignment.

    The Assign data (1/2) dialog is displayed. Here you can edit the Data flow and create dynamic Input parameters for the widget selected. The Data flow box shows an overview of the data source configuration.

  4. Optionally, you can create input parameters for the selected widget.

    Input parameters are dynamic and reusable parameters used in several data source operators and data transformation operators. See Create input parameters.

  5. Select a data source operator in the Add a data source bar and specify your settings. See Data source operators for a list of available data source operators.
  6. In addition to the data source operator you can add further operators to transform the source data. In the Add data operations bar, select a data transformation operator, for example, Change data type, and specify the settings.

    See Data transformation operators for a list of available data transformation operators.

  7. To calculate a data preview of an operator, click the Calculate Calculate preview icon. This allows you to track all data changes step by step. For details, see chapter Calculate the feed data.
  8. Click Next.

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

  9. If you want to return to the Assign data (1/2) dialog to change the data source settings, click Previous.

The data source and transformation operators are assigned to the selected widget.

To display data in a widget (for example, line chart) you must assign the relevant data source columns to the required widget elements. In the Assign data (2/2) dialog you can assign data source columns to the individual widget elements. For example, you can assign separate columns to the chart axes as a dimension (X-axis) or KPI (Y-axis).

Topics

Assign data columns to line, column or bar charts

Assign data columns to a distribution chart

Assign data columns to heat matrix

Assign data columns to pie charts

Assign data columns to bubble charts

Assign data columns to grids

Assign data columns to lists

Assign data columns to circular gauge charts

Assign data columns to horizontal and vertical gauge charts

Assign data columns to traffic lights

Assign data columns to a drop-down box

Assign data columns to labels

Assign data columns to a rich text area

Assign data columns to sliders

Assign data columns to date filters

Assign data columns to vector map

Assign data columns to map with markers

Assign data sources to the Function Flow diagram_connect

Assign data columns to Conformance check widget

Assign data sources to the Variant widget

Create input parameters