Pie chart

A pie chart can display one numerical measure iterated over a dimension (text or date dimension).

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 Edit Edit to open the data source settings in the data feed editor. Click Delete Delete to remove the assigned data source.

Y axis

Displays the measure assigned to the Y axis. In a line 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 More icon and select an aggregation.

Click the Configure average icon to specify the total aggregation.

  • Enable Show to display the total aggregation value as a line.

  • Enable Show numerical value to display the total aggregation as a numerical value.

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 in the pie chart by adding an additional dimension. Click + Add dimension and select a dimension.

Measure

Measure assigned to the pie chart. Click + Add measure and select a measure.

AVG (average) is preset as default aggregation method. Click the More icon and select an aggregation.

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 More icon to select an aggregation method.

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 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.

  • Prefix: Appends given characters at the beginning of the cell value.

  • Suffix: Appends given characters at the end of the cell value.

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.

Values

Allows you to set the display of the values in the chart.

Partition values

Displays the values for each partition of the chart.

Absolute values

Displays absolute values.

Percentage values

Displays percentage values.

Values outside

Display the values outside the chart.

Show as donut

Shows the pie chart as a ring.

Enable data download

Allows downloading the source data of the widget in view mode.

In view mode, click the navigation icon in the chart > Download data.