Line, Bar, Scatter and Area Chart

Multi-Chart

Line-, Bar-, Scatter- and Area-Chart can be used together. Meaning you can visualize one series with a line and another one with bars in the same chart. This is why this widget type is also called multi-chart.

Creating a multi-chart

A simple example of how to build a multi-chart can be found here.

There are a few options you have in displaying your series (depending on the type of series you choose). For line and area series, you can select a stepping mode. Instead of connecting the data points with a straight line, the line will make a step at the given point. The option cumulative or delta is available for all types, where cumulative sums up the values of all previous (lower x value) points and delta displays the difference between consecutive points.

Set color or color conditions for data series

To customize the color in your line chart, uncollapse the color section. 1. If you want to set a specific color for a data series, click on "Fixed" and choose a color. 2. If you want to set a color, based on numeric conditions for a data series, choose "Conditional". There you can set a condition and choose a color for it. You can add multiple conditions for each data series. For that, just add another condition with the button "ADD CONDITION" beneath the settings. 3. You can decide to respect this color in the legend. After activating the setting, you can choose a name for the color in the legend.

Open

Set additional tooltip values

By default, when you hover over a series, you will see the timestamp and the value of the data point closest to your mouse cursor.

In the section Additional tooltip values, however, you have the option to include additional information in the chart's tooltip.

To do so, follow these steps:

1. Open the Additional tooltip values section.

2. Click the Add tooltip value button.

3. Select a label and a column from your chart's dataset that you want to be displayed in the tooltip, alongside the default timestamp and value information.

This allows you to customize the tooltip to show specific data points relevant to your analysis.

Open

Line chart series with one additional tooltip value

Auto-Generated Series

If you have a variable or big amount of series (e.g. one series for every machine) you do not necessarily need to create separate series in your widget. You can use "auto-generated series". Consider the following data:

As you can see for every distinct value in the column selected as a series column a new series is generated. Make sure to select a series type beforehand saving will be disabled.

Alphabetical sorting

If you are using the Auto-Generated Series option then all series are sorted by the order of the data which is displayed in this chart. This means if data for 'Series B' comes first in the input data, then some data of 'Series C' and then 'Series A', the order in the legend will be the same (Series B, Series C, Series A).

If this is not desired you also have the option to alphabetically sort the order of the series in the chart legend. If the same series names appear in multiple widgets on a dashboard, alphabetically sorting also ensures that they have the same colour over the entire dashboard.

Customization

In the following, we will describe some of the options of customization which are not self-explanatory.

Chart

Stacking Mode

The following picture explains the three options.

Zoom Mode

The zoom mode is used by clicking and dragging a window on the widget. This has the advantage that you do not accidentally zoom into a widget when scrolling down on a dashboard.

Axis

Ordinal (Horizontal Axis)

X values are automatically arranged by their value and according to the distance (or time) between them. If you activate ordinal the distance between them is ignored. Instead, the data points are arranged on an equidistant grid.

.

Plotlines

With the plotlines feature you can add additional vertical or horizontal lines to your multi-chart using a different data source than the one you used for the series in the chart. This can be used for example to combine live data and aggregated data, where the live data comes from one dataset and e.g. the minimum, maximum values, benchmark, or threshold come from a different dataset.

Dashboard filters are applied to the data source used for the plotlines in the same way they are applied to the main data source.

Labels

With the labels feature, you can set triggers for critical values that display a label in the graph with the name of the data series. In order to do this, your multi-chart should have auto-generated series or custom ones. You can set up different conditions for a trigger.

• Compare series column values with another datasource column value All the values from the series column will be compared considering the selected operator against the first value of the datasource column value

• Compare series column values with another fixed value All the values from the series column will be compared considering the selected operator against the fixed value defined

When the trigger condition meets, a label will be displayed with the name of the data series column.