Overview
This article describes the various number formatting options available for number fields in the Gauge Builder. Change the format of the numbers in your gauges to best fit the data being displayed. Please note that at this time, text fields cannot be formatted (font, text size, etc.).
Access Gauge Formatting Settings
To access the gauge formatting settings:
- Open a gauge in the Gauge Builder. You can either:
- Click Gauges in the top menu bar and click on the desired gauge in the list, or
- From a dashboard, click on the 3 dot menu icon in the upper-left corner of the gauge and select Edit in Gauge Builder.
- Select the Design tab.
- Click on a number field in the Formatting section. Number fields are indicated by the pound sign (#).
Standard Number Formats
By default, numbers in gauges round to the nearest whole (no decimals). To format a number field, open the gauge in the Gauge Builder and select the Design tab. Then click on a number field in the Formatting section.
The following number formats are available for number gauges:
- 123 (numeral): Displays the number without notation.
- % (percent): Displays the number as a percentage. The raw number in the dataset must be a decimal. The raw number is multiplied by 100 and displayed with the percent (%) symbol.
- $$ (currency): Displays the number in your local currency.
- 00011 (binary): Displays the number in binary. The raw number must be in bytes. The raw number is converted using 1024 base binary calculation.
The following clip outlines how the standard formatting options work:
Decimals
By default, gauges round numbers to the nearest whole. If you would like to display a number as a decimal, hover your mouse over the Decimals field and click the arrows to increase or decrease how many digits are displayed after the decimal.
Abbreviations
The Numeral and Currency options provide two options to display the number:
- Regular: Shows the full number using commas to separate the number places accordingly (hundreds, thousands, etc.).
- Abbreviated: Rounds to the nearest thousandth and displays a letter for the magnitude change. For example, the number 1,000 displays as 1k.
Custom Formatting
To use the Custom formatting option, select Custom from the number formatting modal. The Custom option provides additional number formats and allows for greater flexibility in how numbers display in your gauges. Refer to the tables below for all custom formatting options.
Custom Formatting Options
Numerals
| Field Value (raw format) | Formatting | Output | Description |
|---|---|---|---|
| 79880 | ###0 | 79880 | Rounds to the nearest whole. |
| 82345 | #,###.0 | 82,345.0 | Adds a digit after the decimal point and separators in the whole number where appropriate. |
| 28951245643 | #,###.#0 | 28,951,245,643.00 | Adds two digits after the decimal point and separators in the whole number where appropriate. |
| 49 | #.####0 | 48.991562 | Adds five digits after the decimal point. |
| 6155 | #,#.###0 | 6,154.7591 | Adds four digits after the decimal point and separators in the whole number where appropriate. |
| 42345 | #,0 | 42,345 | Adds separators in the whole number where appropriate and rounds to nearest whole number. |
| 824 | +#,0 | +824 | Rounds to the nearest whole, adds separators where appropriate, and displays positive or negative notations where appropriate. |
| 1237 | #.##0 | 1236.889 | Adds three digits after the decimal point. |
| 222 | #[.]####0 | 221.44589 | If appropriate, adds five digits after the decimal point. If no decimal, displays whole number. |
| 225 | #[.]####0 | 225 | If no decimal, displays whole number. If appropriate, adds five digits after the decimal point. |
| -2984 | (#,#.###0) | (2983.1490) | Adds four digits after the decimal point and separators in the whole number where appropriate. If the number is negative, it appears in parenthesis. |
| 3234 | .#0 | .54 | Strips the whole number and displays only the decimals to two digits after the decimal. |
| 23413 | #.####0 | 23412.97000 | Adds five digits after the decimal point and displays the whole number. |
| 1965 | #.#[###0] | 1965.125 | Displays one digit after the decimal with allowance up to five total, if appropriate, and displays the whole number. |
| 254976 | #.0a | 255.0k | Rounds to the nearest thousandth with one digit after the decimal and displays a letter for the magnitude change. |
| 127423 | 0 a | 127 k | Rounds to the nearest thousandth and displays a letter for the magnitude change, with a space between the magnitude symbol and the number. |
| 896783 | 0a | 897k | Rounds to the nearest thousandth and displays a letter for the magnitude change. |
| 156 | 0o | 156th | Adds ordinal letters after the number, rounds to the nearest whole number (1st, 2nd, 3rd, 4th...). |
Percentages
| Field Value (raw format) | Formatting | Output | Description |
|---|---|---|---|
| 3 | ##.#0% | 300.00% | Multiplies the value by 100, adds a percent sign, and adds two digits after the decimal. |
| 3.556 | #0% | 356% | Multiplies the value by 100, adds a percent sign, and rounds to the nearest whole number. |
Computer Notation
| Field Value (raw format) | Formatting | Output | Description |
|---|---|---|---|
| 28180294 | 0b | 27MB | Converts the number to bytes using binary calculation (1024 base). Rounds to the nearest whole number. |
| 4246 | 0 b | 4 KB | Converts the number to bytes using binary calculation (1024 base) with a space between the number and the unit. Rounds to the nearest whole number. |
| 5231 | #.0b | 5.2KB | Converts the number to bytes using binary calculation (1024 base). Adds one digit after the decimal. |
| 23190 | #.##0 b | 23.190 KB | Converts the number to bytes using binary calculation (1024 base). Adds three digits after the decimal. |
Currency
| (Use the $ symbol in the formatting, but the output will be the local currency sign $, £, or € ) (Local Currency is based on account language setting.) | |||
|---|---|---|---|
| Field Value (raw format) | Formatting | Output | Description |
| 231987 | $#,#.#0 | $231,1986.52 | Adds two digits after the decimal point, separators in the whole number where appropriate, and the local currency symbol before the number. |
| 6745 | #,#[.]#0 $ | 6,745.32 $ | If there are numbers after the decimal, adds two digits after the decimal point, separators in the whole number where appropriate, and a space and the local currency symbol after the number. |
| 3459 | $ #,#[.]#0 | $ 3459.48 | If there are numbers after the decimal, adds two digits after the decimal point, separators in the whole number where appropriate, and a space and the local currency symbol before the number. |
| 5222 | ($#,0) | $5,222 | Adds separators in the whole number where appropriate, rounds to the nearest whole number, and adds the local currency symbol before the number. If the number is negative, it shows in parenthesis. |
| 9998 | $#.#0 | $9997.98 | Adds two digits after the decimal point and the local currency symbol before the number. |
| 4246 | ($ #.#0 a) | $4.25 k | Displays the nearest thousandth with two digits after the decimal, a letter for the magnitude change, a space between the magnitude symbol and the number, and the local currency symbol at the front of the number. If the number is negative, it shows in parenthesis. |
| 8232567 | $#.0a | $8.2m | Displays the nearest thousandth with one digit after the decimal, a letter for the magnitude change, and the local currency symbol before the number. |
| 50675183678 | $0a | $51b | Rounds to the nearest thousandth, displays a letter for the magnitude change, and shows the local currency symbol before the number. |
| 2657 | $ 0a | $ 3k | Rounds to the nearest thousandth, displays a letter for the magnitude change, and shows the local currency symbol before the number separated by a space. |
Comments
10 comments