Page Comparison

Value Format

With the Value Format you define the way values are displayed in the diagram. 

Use Pre-Formatted Data

If this option is activated, the number formatting of the data source is used.

Value Format basic

Select the format of the absolute and percentage values according to guidelines of numeral.js. locale sets the label country format in the Basic mode. DE, FR, EN and AUTO are available options. Choosing AUTO the Locale is retrieved from the Data Source.

Value Format extended

If a fixed format is preferred, put the format for absolute and percentage values here. Choosing a “(“ in the box Negative Sign will show negative values in brackets: (1234). The parameter in the box Scaling is used as a divisor for scaling the data label. The resulting format string can also be set via scripting language – for further details see the Number Formatting.

NULL Value Replacement

If set, all NULL values are displayed as this string.

Infinity Replacement

If set, all Infinity values are displayed as this string.

Zero Replacement

If set, all 0 values are displayed as this string.

Suppress Zero Labels

Hiding Category Labels in case of zero values.

Value Format universal

You can access the configuration by clicking on an element in the list.

Define the number format using the following options:

• Locale: Defines abbreviations, decimal and thousand separators for the respective language. You can choose between en, de, fr and auto.
• Format Type: Defines the type of number output. You can choose between number (decimal number), percent (percentage) and ordinal (ordinal number).
• Abbreviations: Defines the type of abbreviations for all numbers to be formatted. You can choose between mean (abbreviation of the mean value), min (abbreviation of the minimum value), max (abbreviation of the maximum value), auto (best-suited abbreviation for the respective number), trillion (trillion abbreviation), billion (billion abbreviation), million, thousand and none (no abbreviation at all).
• Negative Sign: Defines how negative numbers are displayed. You can choose between minus, parenthesis, and none (no sign).
• Prefix: The input value is placed before the number.
• Suffix: The input value is placed after the number.
• Thousands Separator: Replaces the thousand separator set by the selected locale.
• Decimal Separator: Replaces the decimal separator set by the selected locale.
• Total Digits: Defines how many digits the number may consist of. Total Digits is prioritized over Decimal Digits.
• Decimal Digits: Defines how many decimal places of the formatted number are displayed.
• Scaling Factor: The value of each data point is multiplied by the entered number to scale values.
• Zero Format: When the checkbox is activated, any data value equal to 0 (the number zero) is replaced by the entered value.
• Null Format: Any data value that equals NULL (no value) is replaced by the entered value.
• Error Format: If a data value is undefined or the result of an arithmetic error such as dividing by 0 (zero), the data value is replaced by the entered value.
• Rounding Method: Defines the rounding method. You can choose between half up (23.5 → 24, -23.5 → -23), commercial (23.5 → 24, -23.5 → -24) and trim (23.5 → 23, -23.5 → -23).
• Explicit Positive Sign: Defines whether a positive number should always be preceded by a + (plus sign).
• Description: Defines a description for the set configuration.

Value Labels

Label Positioning

Determine the mode that controls the data labeling. Three modes are available:

• none: The data label is not displayed.
• fix: The data label is always displayed.
• auto: In case of overlaps, the data label is hidden or offset; adjustable by means of Collision Adjustment

Collision Adjustment [px]

Adjusts the collision algorithm of the labels of the auto mode of the value labels. The smaller the value, the more sensitive the algorithm is to collisions. Negative values are also allowed. (Note: Bold labels are not considered by the collision algorithm, so they always appear).

Background

This option draws a colored area behind the Value Labels. With Background Color you define the desired color.

Background Color

With Background Color you define the desired color of the area.

Visible Element Labels

Specify whether or not the element labelling should be displayed for a series.

Label Picking

If this option is enabled, you can use the subordinate settings to control which labels are displayed according to certain criteria. Consequently, only those labels that match the selected criteria are displayed. The following options are available:

Force First Value Label

The first label of a series is displayed.

Force Last Value Label

The last label of a series is displayed.

Force Min Value Label

The minimum value of each series is displayed.

Force Max Value Label

The maximum value of each series is displayed.

Force Before Separators

All values before a separator are displayed. This option depends on the settings under Separators.

Force Peak Labels

This option displays local minima and maxima. What a local minimum/maximum is can be controlled with the option Minimum Peak Size in %.

Minimum Peak Size in %

Determines how much values must deviate from their neighbors to be considered a local minimum/maximum.

Check Only Leading Values For Peak

The peak calculation only refers to the previous value; the following value is not taken into account.

Font

Size [px]

This property determines the font size in pixel. 

Family

Define the global font. You can choose between Arial, Tahoma, Lucida Console, Verdana and Calibri or type in the name of a font which is installed on your system.

Color

This property determines the font color as HEX code. Alternatively, the Color Picker can be used.

Title

Title Text

You can enter a title for the diagram here. If the checkbox is activated, the title is displayed. Multiple-line texts are reproduced accordingly, i.e. the line break is adopted.

Series Labels

Left/Top

Activate the checkboxes to display the data label on the left/top of the data series.

Right/Bottom

Activate the checkboxes to display the data label on the right/bottom of the data series.

Series Label

Enter the desired labeling of a series manually.

Max Series Labels Width [px]

Maximum width of the data series labels, up to where the padding is scaled. If this value is exceeded, the labels are cut off.

Category Labels

If the check mark is set, category labels are displayed on the diagram.

Visibility

Set line by line (level x) whether the category label should be displayed or not.

Max Width [px]

If this value is greater than 0, it indicates the reserved space for the category labels in pixels. If the length of the labels is greater than the specified width, they are shortened by omission points. For values smaller or equal to zero, the reserved  space is calculated automatically. Max Category Label Width can only be set in Structure Mode and with deactivated hierarchical labels (Hierarchical Label Display set to false).

Suppress Repetition

Controls line by line (level x) whether repetitive category labels should be suppressed or displayed.

Hierarchical Label Display

Enables a hierarchical display of category labels. The category labels of each member are displayed in a separate column. The hierarchical display is only possible in Structure Mode.

Line Break Category Labels

The character or string in place of which category labels are split across multiple lines. For example, using a space for the label "ACT Jan 2001" would make it a three-line label.

Category Label Rotation [degree]

Specifies the angle by which the category labels are rotated. The rotation is counterclockwise.

Crop Category Labels

If this option is enabled, the category labels in Time mode will have a maximum width of the specified category width. If the labels are longer, they will be truncated by ... cut off.

Selected Members in Categories

Specifies whether the members of selected measures should be displayed as a supplement in the category labels.

Selected Measures in Categories

Specifies whether the selected measures should be displayed as a supplement in the category labels.

Axis Labels

Left/Top

Activate the check boxes to display the axis label on the left/top of the data series.

Right/Bottom

Activate the check boxes to display the axis labeling on the right/bottom of the data series.

Axis Labels

Enter the desired labeling of the axis manually.

Line Break Axis Labels

The character or string where the axis labels are split over several lines (similar to the property line break category labels).