Chart - Data

Select the Application and Data group, the values of which will be displayed in the chart. With

Filter, a filter can be set up. Next, by clicking on

Add subordinate data groups, you can select in a further dialog the subordinate data groups that should be included in the chart.

The setting to Show dependent lines affects the way records that exist in a parent-child relationship to the superior, currently selected data record will be shown.

In the Values area, you will see the selected chart type. Here, choose the data source for the Values, Rows, and Categories. For categories of the Date type, a corresponding Unit (Second, Minute, Hour, Day, Week, Month, Quarter, and Year) can be selected for display in the chart.

In the Values selection list, a field should be selected that contains a meaningful value. The values of this field will be automatically summed. This sum defines, depending on the type of chart, the height of the columns, length of bars, or size of the areas in the chart. Negative values can also be displayed, in that the individual rows will then be shown in the bar chart below the row axis.

In the Rows selection list, you will define by which criteria the values will be arranged on the x-axis (horizontal axis). By selecting [One row], which can be chosen for all chart types other than the pie chart, the Values are summed.

In the Categories selection list, a field can be selected, by which values will be displayed in the chart in groups.

In the lower area of the dialog box, a Data field can be selected, by which the chart is sorted. You can also define whether the sorting occurs in ascending or descending order.

The following example shows how sales by employee in two teams can be recorded and displayed in various ways.

For the chart XY which is available in the chart type Further the description of the values can be edited.

Click on

change description.