Using dashboards : Configure dashboard components : Assign data sources to dashboard components : Assign data columns to line, column or bar chart : Set properties of component elements
Set properties of component elements
For each component element, such as axis, dimensions or measures, you can edit the settings, e. g. axis title, display name or format.
Depending on the data type of the assigned data source column there are different settings available. See the Option list below for details.
Procedure
1. Click the assigned source column of the X-Axis and specify the axis and column settings.
2. Click the Y-Axis to specify the axis settings.
a. Click the Text tab to specify the Axis title and Axis format.
b. Click the Data range tab to limit the KPI value range.
c. Click the Thresholds tab to specify the KPI thresholds. See Configure KPI thresholds
3. Click an assigned source column of the Y-Axis and specify the settings.
4. Click the assigned source column of the Partition and specify the settings.
5. Click an assigned source column of the More columns (invisible) box and specify the settings.
6. Click OK to save your settings and to leave the dialog.
The chart is displayed with real data of the data source assigned.
Option list
Option
Description
Axis title
Title of the x- or y-axis. Activate 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 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 tool tip. If desired, you can add a prefix or postfix to the format, e. g. $ 1,234 or 1,234 mm.
Display name (data point)
New column name displayed in the component, e. g. used for KPI, data point or tool tip. By default the data source column name is used.
Format
Output format of the column values, e. g. used for data points or tool tip. Available for columns of date and numeric typ.
Sorting
Sorts the labels of the x-axis data points ascending or descending. Or it sorts the x-axis labels by another 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. By default activated.
Aggregation
Specifies how the KPI value is calculated. Available for numeric columns. Default is average value (Avg).
Text tab
Enables you to specify the Axis title and Axis format.
Data range tab
Enables you to specify minimum value (From) and maximum value (To) of the KPI value range. If the values are not set the values are calculated automatically.
You can enter fixed values manually or assign data source columns for a dynamic value assignment via drag and drop.
Coloring
Enables you to specify KPI thresholds and ratings. You can set the background or the graphic color depending on the KPI values.
Thresholds tab
Enables you to specify the thresholds values range and to set the background and graphic color accordingly. You need to assign at least one KPI to the y-axis.
Rating tab
Enables you to specify the KPI rating and to set the data point color accordingly. You need to assign exactly one KPI to the y-axis.
Copyright © 2013-2017 Software AG, Darmstadt, Germany. (Innovation Release)

Product LogoContact Support   |   Community   |   Feedback