Keyboard shortcuts

Press ← or → to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

Show several datasets in a chart

A chart normally draws one dataset (one line, bar series or ring) per data source. Under Datasets you can draw several datasets from one data source, and style each one.

Requires: Write access to the dashboard and panel editing enabled in the instance.

  1. Open the dashboard and select Edit Panel on a chart panel.
  2. Open the Type tab and select Datasets in the list of sections at the top. Each data source of the panel is listed by name, followed by the datasets it draws in their legend colours.
  3. Select Add dataset (the list icon) next to a data source. Each entry draws one dataset, or one per value when Split by is set. Leave a field empty to keep its default.
  4. Check the preview, confirm the dialog with OK and save the dashboard.

The examples below use a chart with labels on the x axis and values on the y axis. If you change the orientation, the label and value axes swap; use the corresponding value axis when assigning datasets.

Split one data source by a field

Use Split by when a data source returns one row per date and category. For example, a data source named Daily check-in returns one row per week and question:

weekquestionanswer
2026-01Sleep2
2026-01Mood4
2026-02Sleep6
2026-02Mood4
  1. Under Axes, set Value to ${week} for the x axis and to ${answer} for the y axis.
  2. Under Datasets, select Add dataset for Daily check-in.
  3. Enter ${question} in Split by. The chart draws two datasets: Sleep and Mood.
  4. Optional: enter ${datasource}: ${key} in Label to name them "Daily check-in: Sleep" and "Daily check-in: Mood". ${key} is the value of the split field and ${datasource} is the data source name.

Rows with an empty split field form one more dataset, named after the data source. A week without a row for a question has no point in that question's dataset; a line connects the points around it.

Draw several values from the same rows

Use one entry per value when each row carries several numbers:

weeksentansweredrate
2026-016467
2026-0266100
  1. Select Add dataset three times.
  2. Enter a Label and a Value for each: Sent with ${sent}, Answered with ${answered} and Answer rate (%) with ${rate}.
  3. To draw the rate on its own scale, select Add axis under Axes and name the axis y1. Then select y1 under Axis for the answer rate. Axis appears only when the chart has more than one value axis.

Value and Split by also work together. For example, two entries with Split by ${question} draw the answers with Value ${answer}, and a target per question with Value ${target} and Label ${key} target.

Style a dataset or a single value

  1. Select Add style (the + button) and pick a style, for example Fill color, Line style or Point size. For a data source without entries, Add style sits next to its name; for an entry, below its fields. Each style appears as a chip; select its remove icon to delete it.
  2. For an entry with Split by, select Style a value. In Split value, enter or pick a value such as Mood, then add its styles with Add style. These apply after the styles of the whole entry.

Styles belong to the data source rather than its name: renaming the data source keeps them, and Duplicate and Copy to dashboard copy them with the panel.

Fields

FieldEffectWhen empty
LabelName of the dataset in the legend and tooltip. Can contain ${key}, ${datasource} and fields of the dataset's first row.The split value, otherwise the data source name
ValueThe number that is drawn, for example ${score}.The value-axis value
Split byOne dataset per distinct value of this field, for example ${question}.One dataset
AxisThe value axis the dataset is drawn against.The default value axis

All datasets of a chart share one set of category labels, merged from every data source.