Source data overlay

Sometimes, plain text or source information helps finding the reason behind certain values of a chart. With the source data overlay, data can be displayed in the form of a simple table, just by clicking a bar of a chart:

The configuration of this table can be made individually on each of the columns of a bar chart by clicking the gear wheel:

A click on Source data Add in the column settings opens a new configuration window:

The source data configuration is the same as the table widget. All parameters of the current dashboard as wells as the charts x, y, z (if applicable) and pivot key values can be used to filter data.

Parameter

Description

${params.x}

The value of the x coordinate of the chart (same applies for y and z)

${params.key}

The column name or pivot value

Example

The following chart shows data aggregated by state (kanton) and city. If one of the cities (colored area of a stacked bar) is clicked, the underlying data should be displayed:

Here is the source data table configuration, showing the SKOOR object filter and columns used to provide the data:

In the Conditions section of the table configuration, the ${params.key} placeholder is used to filter data by object name and the custom property City:

A click on one of the colored areas now opens the source data of the SKOOR objects, with the three configured columns City, Yes votes and No votes: