An area chart can display values for two iterations:
Two dimensions (X axis and partition) and one measure (Y axis)
One dimension (X axis) and multiple measures (Y axis)
If two dimensions or multiple measures are used, they are displayed as stacked areas of different colors.
Setup options
Data assignment
You can assign a text or date column to the X axis and Y axis and a number column as a measure.
The following setup options are available.
Setup options |
Description |
---|---|
Data source |
Displays the columns of the assigned data source. Click |
X axis |
Displays the dimension assigned to the X axis. In an area chart, the X axis is the horizontal axis. Click + Add dimension and select a dimension. |
Y axis |
Displays the measure assigned to the Y axis. In an area chart, the Y axis is the vertical axis. Click + Add measure and select a measure. Depending on the assigned data source, you can select more
than one measure. AVG (average) is preset as default aggregation method. Click the Click the
Specify an alternative label or color for the total aggregation value. |
2. Y axis |
Displays the measure assigned to the second Y axis. Depending on the assigned data source, you can add more than two Y axes to the widget. Click + Add measure and select a measure. |
Partition |
Allows you to split the criteria displayed on the X axis by adding an additional dimension. Click + Add dimension and select a dimension. |
Hidden columns |
Displays the list of hidden columns added to the widget. They are not displayed in
the widget but can be used, for example, for filtering the widget. Click + Add dimension or measure to add a hidden column. For numerical measures, AVG (average) is preset as default aggregation method. Click the |
Multiple selection |
Enables multiple selection for the widget. In view mode, the user can select multiple values at the same time in the corresponding widget, for example, multiple rows in a table or multiple coordinates in a chart. The multiple selection can be used, for example, to filter other dashboard widgets. See Use interactive filters in dashboards for details. The values selected are processed as a list. If the option is enabled, columns of List type are provided in the filter configuration dialog to configure filter conditions. See Define filters for dashboard widgets for details. |
Auto-refresh data |
Enables automatic data retrieval for the widget. |
Edit a dimension, measure, or hidden column
You can edit the columns assigned to the widget. Move the mouse pointer over a dimension,
measure, or hidden column and click Edit.
The options provided depend on the data type of the assigned column.
The following setup options are available.
Setup options |
Description |
---|---|
Display name |
Name of the criteria displayed in the widget. Click Revert to '...', to restores the initial display name. |
Date column |
|
Date formatting |
Enables you to specify the date format. |
Precision |
Time unit, for example, second or hour. The default setting is Auto. |
Time of day only |
Displays only the time of the criterion value. Example If the option is enabled, the date value 23 Oct 2008 12 AM is displayed as 12 AM only. You can enable the option if the precision is hours, minutes and seconds or if the criterion value contains time units. |
Numerical form |
Displays the date in numeric form. Example 23 Oct 2008 is displayed as 23/10/2008. The option is disabled by default. It is disabled for year and quarter precision. |
Long form |
Displays the full date without any short notations. Example 23 Oct 2008 is displayed as 23 October 2008. The option is disabled by default. |
Number column |
|
Aggregation |
Aggregation type for the column values: Average, Sum, Minimum, Maximum, and Count. Default is Average (AVG). Select an aggregation type. |
Treat as timespan |
The column is used as timespan. The option is disabled by default. Enable the option and specify the time span settings. Base unit Select the base unit for the timespan, for example, seconds or minutes. Use decimal fractions Allows to specify the number of decimals. The option is enabled by default. Select the decimal fraction in the Precision drop-down menu. The default is Auto. |
Precision |
Allows to select the decimal fraction in the drop-down menu. The default is Auto. |
Enable Prefix/Suffix |
Allows to specify a prefix and suffix.
|
Thousands separator |
Displays a thousands separator in the column values. |
Abbreviation |
Values are displayed abbreviated. |
Appearance
Widget appearance
You can configure the appearance of the widget.
The following appearance options are available.
Appearance options |
Description |
---|---|
Chart type |
Displays the chart type of the widget. Depending on the assigned data source, you can switch the chart type in the drop-down menu. |
Title |
Optional widget title. You can specify a title in the input field. |
Add subtitle |
Adds an optional subtitle. |
Series color |
Selects the color with which the map cells are to be filled. Click the box, open a tab (Two tone, Palette, Mono, or Custom) and select a color series. On the Custom tab, you can select individual colors to fill the cells. |
Sort |
Specifies the sort order of the axis values. You can select the sort criterion in the drop-down menu. The values are sorted in ascending order by default. |
Sort descending |
Enables descending sorting. |
Legend |
Displays a legend in the widget. Activate Show legend and select the position where the legend should be displayed in the widget. |
Axes and measures |
Allows you to specify the appearance of the axes and the measure values. Click |
Stacking |
Displays the values of two dimensions as stacked areas of different colors. The option is disabled by default. |
Stacking (percentage) |
Displays the dimension values in the stacked areas as percentages. The option is only available if you have previously activated Stacking. |
Enable data download |
Allows downloading the source data of the widget in view mode. In view mode, click the |
Axes and measure appearance
You can configure the appearance of the axes and the measure values. Click Edit in the line of a measure or axis to specify its appearance.
The options provided depend on the selected criterion (axis or measure) and the data type of the assigned column.
The following appearance options are available.
Appearance options |
Description |
---|---|
Measures |
|
Line type |
Specifies the line type of the area chart. Linear, Curved or Step line types are available. The default is Linear. Select the line type in the drop-down menu. |
Show measure name |
Displays the measure values in the chart. The option is disabled by default. |
Show measure values |
Displays the measure values in the chart. The option is disabled by default. |
Show data points |
Shows data points in the chart. The option is disabled by default. |
Interpolate |
Enabled: A lack of values results in a continuous line. Disabled: A lack of values results in gaps within the line. The option is disabled by default. |
Configure per measure |
Allows you to configure the appearance of each measure individually. The option is disabled by default. |
Axes |
|
Axis title |
Title displayed on the X or Y axis. By default, the column name is automatically used as title. Disable Auto axis title to change the title in the input field. Select the Label orientation in the drop-down menu. |
Date column |
|
Use time axis |
Arranges the data values according to the distance between the points in time. The option is disabled by default. |
Number column |
|
Data range |
Allows you to specify a range for the measure values to be displayed for constants or numeric data columns. By default, the data range is dynamically adapted. To define a data range, disable the Dynamically adapt option and specify the rage limits From/To. You can enter If you specify a data range, the cells outside the range are displayed with a fully saturated color. |
Switch axis position |
Places the axis on the opposite side. |
Logarithmic scale |
Displays the measure values of numeric data columns in a logarithmic scale. This is useful if you want to display a large range of values. The option is disabled by default. |