General chart settings

The different diagrams (charts) share many settings. These are described here rather than in the respective diagram types.

The following should be noted here:

  • If two different settings are mutually exclusive, then the corresponding options are shown or hidden. Therefore, the screenshots shown here may differ.

  • Some settings are not always compatible with all other possible settings. This can affect both the purpose and the visual result. Here it is necessary to check accordingly whether the desired result has been obtained. (Example: Show headings with only one visible chart (no cluster)).

Chart type

images/download/attachments/189435471/image-2024-10-22_9-35-29-version-1-modificationdate-1729582529444-api-v2.png

(1) Here you can load presets for different chart types. See below, 'Presets'.

(2) The Chart type enables four different types:

  • Seriell: The data is displayed in a classic X/Y coordinate system.

  • Radar: In this coordinate system, the categories are arranged circularly at 360°. (There must be at least 2 categories).

  • Kuchen/Donut: This is also a pie chart (spatial) where the values are plotted proportionally on a circle.

  • Summen: Here the values are displayed in numerical form.

(3) The Line Type determines how the values are connected. This option is not always available.

(4) Here the measured values can be swapped with the series attributes on the category axis.

(5) Here it is possible to select whether only the categories are displayed for which the values of the cluster were found (only effective in connection with clusters).

Presets

images/download/attachments/189435471/image-2024-10-22_9-37-11-version-1-modificationdate-1729582631245-api-v2.png


Presets can be loaded for the following types:

  • Bar charts

  • Line charts

  • Curve charts

  • Area diagrams

  • Curved area diagrams

  • Radar charts

  • Pie charts

  • Summary charts

The presets options differ depending on the type. In any case, the chart type and the line type are set. This also applies to the thickness and the visibility for existing lines.

Chart display

Various display options can be determined under the chart display.

Show bullets

(1) A mark is drawn on each value.

Values as bullets

(2) The respective value is used as a marker. This item is not visible if (1) is switched off.

Show info tooltip

(3) A tooltip displays the respective values when the mouse cursor hovers over the corresponding areas.

Show title

(4) A title is displayed above the chart. In a chart without a cluster '(default)' the value is displayed here, otherwise the value over which the cluster was created.

Stack type

(5) The stack type specifies whether and how the values are to be totaled. It can also be displayed as a percentage ('100%'), if yes. (See note below.)

Switch axis

(6) Here the coordinate axes can be swapped.

Line alpha

(7) Here the visibility (transparency) of the line ('outline' for bar charts) is set.

Line thickness

(8) Here, the thickness of the line is set.

Fill alpha

(9) Here it is possible to set the visibility (transparency) of the graph (e.g. the "content" of bar charts).

Enable 3D

(10) This can be used to display a spatial view for certain charts. (See also note below.)

Animation

Show animation when the chart is displayed or its data is updated.

Start animation duration (ms)

Duration of the animation when showing the chart in milliseconds. (Visible when animation is switched on.)

Update animation duration (ms)

Duration of the animation when updating the data of the chart in milliseconds. (Visible when animation is switched on.)

Max. columns for cluster charts

(11) The number indicates how many charts are drawn next to each other if clusters are present.

Chart axes

Under the chart display, various display options can be set for the chart axes.

Exchange axes

(6) Here the coordinate axes can be switched.

Allow zoom of category axis

Allow zoom of value axis

(12,13) Here it is possible to set whether the respective axis may be zoomed in or out.

If allowed, the underlying area of the axis can be enlarged by pressing and dragging with the mouse button.

As soon as a chart has been enlarged, a blue symbol with a minus sign appears in the upper right corner. This can be used to switch back to the unenlarged view.

Show value as axis tooltip

Show category as axis tooltip

(14,15) Controls the display of the value/category at the mouse position on the respective axis.

images/download/attachments/189435471/image2020-11-12_15-10-31-version-1-modificationdate-1729520936198-api-v2.png

Value axis: Start value

Only available for series charts (bars, lines and areas).

Sets the minimum level for the value axis. If this property is left empty, the value axis automatically scales to a suitable range of values to make differences visually clearer between values.

Example with three categories 'cat1', 'cat2', 'cat3' and the corresponding values '15', '14', '15':

Start value: Empty for auto

Start value: 0

images/download/attachments/189435471/image2021-5-5_14-45-11-version-1-modificationdate-1729520936164-api-v2.png

images/download/attachments/189435471/image2021-5-5_14-45-15-version-1-modificationdate-1729520936154-api-v2.png

Value axis: Final value

Only available for series charts (bars, lines and areas).

Sets the minimum level for the value axis. If this property is left empty, the value axis takes the maximum value in the graph.

Example (final value = 300):

images/download/attachments/189435471/image2021-8-25_14-46-10-version-1-modificationdate-1729520936149-api-v2.png

Category axis: Grid position

(16) If a grid is displayed, it can be used to determine where the lines of the grid of the category are positioned: At the beginning of the category, or centered in its middle.

images/download/attachments/189435471/dbdoku11-version-1-modificationdate-1729520936185-api-v2.png images/download/attachments/189435471/dbdoku10-version-1-modificationdate-1729520936188-api-v2.png

Category axis: Opacity

(17) Here it is possible to set the visibility (transparency) of the category axis.

Category axis: Grid opacity

(18) Here it is possible to set the visibility (transparency) of the grid of the category axis.

Category axis: Show labels

(19) This allows you to determine the display of labels on the category axis.

Category axis: Label rotation

(20) This can be used to determine the contact angle of the labels on the category axis.

Category axis: Parse dates

(21) This option can be used to control whether the values of the category axis should be treated as a date (with and without time).
For larger data sets, the data is thinned out accordingly depending on the zoom level of the graph.
Date values can be passed in the following forms:

  • As a string in the format 'yyyy-MM-dd' or with time 'yyyy-MM-dd HH:mm:ss'
    Example: '2020-01-30 10:38:12' for 30 January 2020 at 10:38:12

  • Timestamp

  • Long (Unix timestamp in milliseconds)

  • DateTime

  • Javascript Date

Tip: A calculation expression can be stored in the dashboard field ('Calculations' category) which can generate an appropriately resolved output format using the fd function.
Example: The 'created' timestamp of a business object: expression: '$fd({created},yyyy-MM-dd)' returns categories which are resolved on a daily basis.

►NOTE◄ With the above settings, and also with other options in connection with the chart types, even very unattractive or nonsensical charts can be created due to the high degree of freedom. Here it is necessary to find suitable display options by varying the values and selecting chart types.

►NOTE◄ In the 3D view the options 'Line alpha' (7), 'Fill alpha' (9) and 'Line thickness' (8) have a different function. (7) and (9) control the visibility of the graph and their frames together (multiplicative), while in this view the 'Line thickness' has no effect.

►NOTE◄ The stack type '3D' (5) is only useful when the '3D' view (10) is selected. However, here the values shown are not totaled, but lined up in Z direction. See image.

images/download/attachments/189435471/dbdoku30-version-1-modificationdate-1729520936190-api-v2.png

Chart legend

Under the chart legend you can set properties of the legend.

images/download/attachments/189435471/image-2024-10-22_9-38-18-version-1-modificationdate-1729582697962-api-v2.png

Visible?: This switch controls the display of the legend.

Position: With this selection, the position of the legend can be determined. Depending on the space used, it may be useful to display the legend above or below.

Gap to chart: This can be used to specify the distance of the legend to the chart. The width/height of the chart will be adjusted (the larger the distance, the smaller the chart). Only visible with serial charts.)

Max. columns: Here the maximum number of columns in the legend can be specified. If the value is left blank, the number of columns is automatically calculated based on the available width. If the legend is positioned on the right or on the left, this value is invariably set to 1.

Marker size: Here the size of the markers in the legend can be set.

Max. height (px) Defines the maximum height of the legend area. If this is exceeded, a scroll bar is displayed.

Max width: Defines the maximum width of the legend area. If this is exceeded, a scroll bar is displayed.