Data (Reporting)
Click here to see this page in full context


Data

Data Values

The required settings in this area depend on the chart type you selected on the Chart page:

Select Y-Value

This setting is required for all chart types. Using these expressions you determine the y-axis values. Make sure the expressions always return numeric values.

Select X-Value

Using these expressions you determine the x-axis values.

This setting is only required for Scatter and Bubble charts. In these charts, the x-axis values can differ from the category group values. The x-values are typically numeric values or date/time values.

If you want to plot multiple y-values, you must provide the same number of x-values and y-values. We recommend using the same data field for all x-values.

Select Size

Using this expression, you determine which values the bubble size is based on.

This setting is only required for Bubble charts.

If you want to plot multiple y-values, you must provide the same number of size expressions and y-values. Make sure the size expressions always return numeric values.

We recommend using aggregating functions for all of these expressions, as the category group may contain multiple values (see Category Group).

Add the selected data field to the active settings.

Remove the selected data field from the active settings.

fx

Edit the currently selected expression.

Data Value Properties

Using this button, you open a dialog where you can configure the labels of the y-axis and the appearance of the data points.

Category Group

Select Grouping for X-Axis

This expression determines how the data will be grouped. In line charts and column charts, the category grouping automatically corresponds to the x-axis labels.

In scatter and bubble charts, the category group expression can differ from the x-value that determines the position of the data points. Therefore the category group does not influence the appearance of the x-axis in these chart types, it only has an affect on the amount of data points shown in the diagram (see Category Group).

fx

Edit the currently selected expression.

Category Properties

Using this button, you open a dialog where you can configure the labels of the x-axis and filter or sort the data plotted on the x-axis.

Series Group

Select Grouping for Series

This expression defines the number of series shown in the chart. Series are displayed as several lines or as data points with different colors in a diagram.

For more information, refer to the example under Series Group.

fx

Edit the currently selected expression.

Series Properties

Using this button, you open a dialog where you can configure the series labels in the legend and filter or sort the series data.

This setting is not available for bubble charts.

See Also