Formatting and Localization of Widget Data
You can change the way numbers are displayed and formatted in widgets. For example, you can display a number as a percentage, and you can define the number of decimal places.
Formatting Numbers in Widgets
How to Format Numbers in a Widget
In the Widget Designer, for example, in the X-Axis, Y-Axis, Values, Categories areas, and so on, hover over and click 123.
Select how the number, currency or percentage appears. The preview area at the bottom of this window shows a preview of how each option will appear in the widget.
By default, each abbreviation rule is applied to the number that matches its level. For example, when 1M is selected, it will only abbreviate those values that are equal to or bigger than 1M.
Abbreviate All Values
When you need all of the data values to be formatted as per the selected abbreviation - apply the additional option “Abbreviate all values“.
For example, when only 1M is selected:
40 000 → 0.04M
445 514.3 → 0.45M
952 823.07 → 0.95M
1 200 000 → 1.2M
If several abbreviations are selected - the values are rounded to the next highest selected abbreviation for formatting. For example, if “1K” and “1B” are selected:
400 → 0.4K
445 514.3 → 445.51K
952 823.07 → 952.82K
1 200 000 → 1200K
1300000999 → 1.3B
This should be useful for financial and other fields, where consistent formatting is required across the whole data.
Currency Settings
The default currency symbol used in the dashboard is the US dollar ($), however you can change the symbol by either selecting another symbol from the drop-down list, or by typing in a different symbol. The list of currency symbols will include common currency symbols, the currency defined in your browser's locale settings, and the symbol that you added (if you did so).
After you select a different symbol, additional viewers will see the same symbol that you applied.