Assign data columns to a distribution chart

To display data in a distribution chart, you must assign the relevant data source columns to the required widget elements.

The distribution chart is available only for context based dashboards.

Prerequisite

You have created a Process Mining context for the dashboard.

Procedure

  1. Click a Distribution chart widget on the dashboard. The relevant properties dialog is displayed.

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

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

  3. Select a measure to be distributed on the X-axis from the Measure to distribute drop-down menu.

  4. Specify the step width for the distributed measure in the Step width input box.

    In view mode, you can change the step width in the settings dialog of the distribution chart.

  5. If you want to add or change the data columns provided by the Process Mining context, click Edit context.

  6. Click Next.

    The Assign data (3/3) dialog is displayed. Here you can assign the data source columns to the widget elements. The data column assigned to the X-axis is preset by your selection in the Assign data (2/3) dialog and cannot be changed.

  7. Assign a data column to the Y-axis using drag and drop.

  8. Optionally, assign one or more columns to the More columns (invisible) box using drag and drop. The columns are not displayed in the widget. They are used only for filtering widgets. See Define filters for widgets for details.

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 X-axis box to specify the X-axis settings.

  2. Click the Y-axis box to specify the Y-axis settings.

    1. Click the General tab to specify the position, title, and format of the axis.

    2. Click the Data range tab to limit the KPI value range.

  3. Click a source column assigned to the Y-axis and specify the settings.

  4. Click a source column assigned to the More columns (invisible) box and specify the settings.

  5. 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

Axis position

Specifies on which side of the chart the axis is located. Default is left.

Scale type

Specifies the scale type of the axis values. The scale type is available for axes with numeric values.

  • Linear: The axis values are displayed linearly. This is the default scale type.

  • Log (logarithmic): The maximum value of the source column is set to 100 and the minimum is set to 1. All axis values are between 100 and 1. Negative values and 0 values of the source column are not taken into account.

Axis title

Title of the X- or Y-axis. Enable the title field and enter an Axis title. By default, the Automatic option is selected and the axis title consists of the concatenated names of the assigned columns.

Axis format

Output format of the X- or Y-axis. The selected format overwrites the formats of the assigned columns. By default, Auto is selected and the individual formats are used for tooltips. Optionally, you can add a prefix or postfix to the format, for example, $ 1,234 or 1,234 mm.

Display name (data point)

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

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.

Sorting

Sorts the labels of the X-axis data points in ascending or descending order, or sorts the labels of the X-axis data points according to the order of a data column that is assigned to the chart. The option is not available in a line chart if a date column is assigned to the X-axis. The "Sort by" option is not available if a partition is assigned.

Sort by

Sorts the labels of the X-axis data points by any column assigned to the chart. The option is not available if a column is assigned to the Partition.

Round numerically

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

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.