Chart - Data

Select the 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 shuld 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.

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). If a date field is used as row, a unit (day, month, year, etc.) can be selected. This allows you to display, for example, how high sales were on individual days.

By selecting [One Row], which can be selected for all diagram types except the pie chart, the values will be added together.

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

Here you will see an example, in which sales by employees per day are entered into two teams and then displayed in various ways.

The chart can be sorted by values or rows in ascending or descending order.