en GPS Tab2 Labels (bubbles) LDE

Value Format

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

Value Format basic

Set the format for absolute and percental values according to the numeral.js rules – see Number Formatting. Locale can be changed here. If set to AUTO the locale of the data source is used.

Value Format extended

If you need a fixed format for the data labels you can set it here for all values. Choosing the parenthesis „(" as the Negative Sign leads to negative numbers being shown inside parenthesis: (1234). The parameter in the Scaling field will be used as a divisor to scale the data labels.

Value Format universal

You access the configuration by clicking on an element in the list. You can create and define additional formats using the + symbol.

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), ordinal (ordinal number) and Time (time unit).
• 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).
• Time Units: If Time has been specified for the format type, the time units can be set here. The default setting interprets data values as seconds and displays them as hours and minutes with decimal places in the format h:mm.m 
• Description: Defines a description for the set configuration.

Time Unit Pop Up

For the Format Type Time, a system of units can be configured with the help of the Time Units Property, which in the default setting consists of hours and minutes. Each number formatted in this way is then splitted in its values for each unit. The order of the unit list defines their relationship from the largest unit (top) to the smallest unit (bottom). Each unit contains the following options:

• Modulus: defines the arithmetic relationship between the units. In terms of modular arithmetic, the number reflects how many entities of the next smaller unit fit into an entity of the current unit. If the current unit is the smallest of the unit system, the modulus establishes the reference to the raw value to be formatted. Thus, in the case of a unit system of hours and minutes with raw values that are given in minutes, the hours unit carries the modulus 60 and the minutes unit carries the modulus 1.
• Prefix: Defines the local prefix with which the value of this unit should begin. It can be used as a separator to values of larger units.
• Suffix: Defines the local suffix that should follow the value of this unit. For example, it can contain a unit abbreviation or be used as a separator to values of smaller units.
• Omit If Zero: Sets whether values of this unit should be omitted if they equal 0.
• Leading Zeros: Sets whether values of this unit should be displayed with one or more leading zeros (depending on the reference to the next larger unit).
• Description: Sets a description for the unit to make it easier to recognize in the list.

Additional Information

Legend

If the checkbox is activated, a legend is displayed if data has been selected for one of the fields Circle, Arc or Deviation.

Tooltip

If the tooltip is activated, the data of the respective bubble is displayed when hovering on element.