Polar chart

Polar charts, also known as radar charts, consist of a sequence of axes, where each axis represents a single criterion. It is a cartesian chart where the X axis is wrapped around the perimeter. It can render common cartesian series types like line, column and area.

Polar charts compare multiple quantitative criteria and are useful for visualizing criteria with similar values and outliers among criteria. Polar charts are often used to compare multivariate data sets. Radar charts are also useful for determining which criterion in a data set have a high or low scoring.

The widget is available only for the new dashboard editor.

Example

Polar chart

Setup options

Data assignment

You can assign a text or date column to the X axis and multiple number columns to the Y axis or alternatively one number column to the Y axis and a text or date column as partition.

Example

Assign data

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.

X axis

Displays the dimension assigned to the X axis. Click + Add dimension and select a dimension. The column must be of Text or Date type.

Y axis

Displays the dimension assigned to the Y axis. Click + Add measure and select a measure. The columns must be of Number type. AVG (average) is preset as default aggregation method. Click the More icon and select an aggregation.

Partition

Displays the dimension used as partition. The column must be of Text or Date type. Click + Add dimension and select a dimension.

Hidden columns

Displays the hidden columns that can be used for filtering. Click + Add dimension or measure to add a hidden column. AVG (average) is preset as default aggregation method. Click the More icon and select an aggregation.

Multiple selection

Enables the 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 the automatic data retrieval of the widget.

Edit dimension, measure, and hidden columns

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.

Date column

Date formatting

Allows you to specify the date format.

Precision

Time unit, for example, second or hour. Default 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.

Number formatting

Allows you to specify the number format.

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. Default is Auto.

Precision

Allows to select the decimal fraction in the drop-down menu. 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

Allows you to change the chart type. The provided options for configuring the appearance depend on the selected chart type.

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 areas are to be filled. Click the box, open a tab (Two tone, Palette, or Mono) and select a color series.

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 descending order by default.

Legend

Displays a legend in the widget. Activate Show legend and select the position where the legend should be displayed in the widget.

Axes and measures

Allows you to specify the appearance of the axes and the measure values. To configure the measures individually, enable Configure per measure. Click Edit Edit to configure the appearance of a criterion.

Column stacking

Enables the column stacking. The option is available if at least two measures are specified and the data points are displayed as column (see Type in the table below).

Area stacking

Enables the area stacking. The option is available if at least two measures are specified and the data points are displayed as area (see Type in the table below).

Spiderweb

Displays the polar chart as spider web.

Enable data download

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

Axes and measures appearance

You can configure the appearance of the axes and the measure values. Click Edit Edit in the line of a measure or axis to specify its appearance.

The options provided depend on the selected criterion (axis or measure) and the data type of the assigned column.

The following appearance options are available.

Appearance options

Description

Axes

Number formatting

Allows you to specify the number format.

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. If you enable Treat as timespan the Precision option is disabled by default. Enable Use decimal fraction to enable the Precision option.

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.

Data range

Allows you to specify a range for the measure values to be displayed for constants or numeric data columns. By default, the data range is dynamically adapted.

To define a data range, disable the Dynamically adapt option and specify the rage limits From/To. You can enter Input constant values (default) or select specific columns to specify the limits. Click Add -> Grid Select column and select a column to specify the limit.

If you specify a data range, the cells outside the range are displayed with a fully saturated color.

Logarithmic scale

Scales the values logarithmically: The maximum value of the source column is set to 100 and the minimum is set to 1. All axis values are between 100 and 1. Negative values and 0 values of the source column are not taken into account.

Measures

Type

Specifies how the data points are displayed, that is as lines, columns, or areas.

Line type

If you select Line or Area as type you can select Linear, Curved, or Step as the line type.

Show measure name

Displays the measure names at the data points. The option is disabled by default. This option is not available if a dimension has been added as a Partition.

Show measure values

Displays the measure values at the data points. The option is disabled by default.

Show partition value

Displays the partition values at the data points. The option is disabled by default. This option is available only if a dimension has been added as a Partition.

Show data points

Displays the data points in the polar chart.

Interpolate

Calculates the intermediate values and connects them.

Data range

Allows you to specify a range for the measure values to be displayed for constants or numeric data columns. By default, the data range is dynamically adapted.

To define a data range, disable the Dynamically adapt option and specify the rage limits From/To. You can enter Input constant values (default) or select specific columns to specify the limits. Click Add -> Grid Select column and select a column to specify the limit.

If you specify a data range, the cells outside the range are displayed with a fully saturated color.