The Number formatting menu allows you to change the number of decimal places used or add additional information about the values being displayed.
- Locate the widget you want to change the number format for on your dashboard.
- Click the in the top right corner to bring up the widget options.
- Click .
Each aspect of the Number formatting menu is automatically set to Auto - this will detect whether there is a known abbreviation, number of decimal places or unit for the data you're visualizing.
Example
If you're using a Dataset and have created the value type as a currency, the widget will automatically use the associated prefix or suffix. If the value is 135,600, the widget will automatically show 135.6 with the abbreviation K for thousand.
Abbreviation options
The Abbreviation options allow you to indicate that a number has been abbreviated by including the correct suffix for the units shown. There are preset values of K for thousand, M for million and B for billion. You can also remove any automatically applied value by choosing None.
Decimal Places options
The Decimal Places options allow you to add or remove decimal places for your numbers. The Auto option will show up to 3 decimal places. It is possible to show between 0 and 6 decimal places using the Fixed option.
Unit options
The Unit options allow you to add up to 3 characters to the beginning or end of your number to indicate what it shows.