MashZone NextGen 10.2 | Use dashboards | Configure dashboard components | Assign data sources to dashboard components | Assign data columns to line, column or bar charts
 
Assign data columns to line, column or bar charts
 
Set properties of component elements
Configure KPI thresholds
Configure KPI rating
To display data in a dashboard component (for example, line chart), you must assign the relevant data source columns to the component elements required (for example, x-axis).
Prerequisite
You have assigned a data source to the dashboard component.
In a line, column and bar chart you can display one dimension (x-axis) and several KPIs (y-axes), or two dimensions (x-axis and partition) and one KPI (y-axis).
In each of these chart types one or more y-axes can be displayed, and to each y-axis one or more KPIs can be assigned. For example, you can assign KPIs with different data ranges (for example, KPI 1: 0-100, KPI 2: 10000-50000) to different axes to show them with the same size of data points.
Procedure
1. Click a component inserted in the dashboard. The relevant properties dialog is displayed.
2. Click the Assign data icon to edit the data source assignment.
The Assign data (2/2) dialog is displayed.
3. Assign a data column as dimension to the X-Axis via drag and drop.
4. Assign one or more data columns as KPIs to the Y-Axes via drag and drop.
By default, there are two Y-Axis boxes you can assign the KPI(s) to. 1.Y-Axis (left) for the left-hand side and 2.Y-Axis (right) for the right-hand side of the chart. When you assign KPIs to both axes a third y-axis box is displayed. You can have multiple y-axes on each side of the chart. And you can assign more than one KPI to each y-axis via drag and drop.
If you have assigned one column to the X-Axis and one column to the Partition then you can not assign more than one column to the Y-Axes.
5. Optionally, assign a Data column as second dimension to the Partition via drag and drop.
If you have assigned more than one column to the Y-Axis the Partition is not longer available.
6. Optionally, assign one or more columns to the More columns (invisible) element via drag and drop. The columns are not displayed in the component. They are used for filtering components only. SeeDefine filters for dashboard components for details.
The data source columns are assigned to the component elements.

Copyright © 2013-2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release