You can customize how values appear on your widgets and dashboards to make data easier to read or format according to your preference.
What's in this article:
This procedure works when the Business Type of the Dataset Column Display is set to Number. |
Ensure that you are customizing the column with Number as the selected Business Type, else the customization will not succeed. |
Order | Field Value (raw format) | Formatting | Output | Descriptions |
---|---|---|---|---|
1 | 10000 | 0,0.0000 | 10,000.0000 |
|
2 | 10000.23 | 0,0 | 10,000 |
|
3 | 10000.23 | +0,0 | +10,000 |
|
4 | -10000 | 0,0.0 | -10,000.0 |
|
5 | 10000.1234 | 0.000 | 10000.123 |
|
6 | 100.1234 | 00000 | 00100 |
|
7 | 1000.1234 | 000000,0 | 001,000 |
|
8 | 10 | 000.00 | 010.00 |
|
9 | 10000.1234 | 0[.]00000 | 10000.12340 |
|
10 | -10000 | (0,0.0000) | (10,000.0000) |
|
11 | -0.23 | .00 | -.23 |
|
12 | -0.23 | (.00) | (.23) |
|
13 | 0.23 | 0.00000 | 0.23000 |
|
14 | 0.23 | 0.0[0000] | 0.23 |
|
15 | 1230974 | 0.0a | 1.2m |
|
16 | 1460 | 0 a | 1 k |
|
17 | -104000 | 0a | -104k |
|
18 | 1 | 0o | 1st |
|
19 | 100 | 0o | 100th |
|
You can use the $ symbol in the formatting, however, the output will be your local currency sign $, £, or € ) (Local Currency is based on account language setting.) | ||||
---|---|---|---|---|
Order | Field Value (raw format) | Formatting | Output | Description |
1 | 1000.234 | $0,0.00 | $1,000.23 | Adds separators in the whole number where appropriate and rounds two digits after the decimal point and rounds to the nearest number and adds the local currency symbol before the number. |
2 | 1000.2 | 0,0[.]00 $ | 1,000.20 $ | Adds separators in the whole number where appropriate and rounds two digits after the decimal point and rounds to the nearest number and adds the local currency symbol after the number and if no decimal, displays whole number. |
3 | 1001 | $ 0,0[.]00 | $ 1,001 | Adds separators in the whole number where appropriate and rounds two digits after the decimal point and rounds to the nearest number and adds the local currency symbol before the number and if no decimal, displays whole number. |
4 | -1000.234 | ($0,0) | ($1,000) | 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. |
5 | -1000.234 | $0.00 | -$1000.23 | Adds two digits after the decimal point, rounds to the nearest number, and adds the local currency symbol before the number. |
6 | 1230974 | ($ 0.00 a) | $ 1.23 m | Displays the nearest thousandth with two digits after the decimal, a letter for the magnitude change, and the local currency symbol before the number.If the number is negative, it shows in parenthesis. |
Order | Field Value (raw format) | Formatting | Output | Description |
---|---|---|---|---|
1 | 100 | 0b | 100B | Adds B after the number. |
2 | 1024 | 0b | 1KB | Divided by 1000 and rounds to the nearest whole number and add 'KB' after the number. |
3 | 2048 | 0 ib | 2 KiB | Divided by 1024 and rounds to the nearest whole number and add 'KiB' after the number. |
4 | 3072 | 0.0 b | 3.1 KB | Divided by 1000 and adds one digit after the decimal point and rounds to the nearest number and add 'KB' after the number. |
5 | 7884486213 | 0.00b | 7.88GB | Displays the nearest thousandth with two digits after the decimal and add 'GB' after the number. |
6 | 3467479682787 | 0.000 ib | 3.154 TiB | Displays the nearest thousandth with three digits after the decimal and add 'TiB' after the number. |
Order | Field Value (raw format) | Formatting | Output | Description |
---|---|---|---|---|
1 | 1 | 0% | 100% | Multiplies the value by 100 and adds a percent sign. |
2 | 0.974878234 | 0.000% | 97.488% | Multiplies the value by 100 and adds three digits after the decimal point and rounds to the nearest number and adds a percent sign. |
3 | -0.43 | 0 % | -43 % | Multiplies the value by 100 and adds a percent sign. |
4 | 0.43 | (0.000 %) | 43.000 % | Multiply the value by 100 and adds three digits after the decimal point and rounds to the nearest number and adds a percent sign.If the number is negative, it shows in parenthesis. |
Order | Field Value (raw format) | Formatting | Output | Description |
---|---|---|---|---|
1 | 25 | 00:00:00 | 0:00:25 | Seconds: Numbers less than 60 are displayed in the seconds position. |
2 | 238 | 00:00:00 | 0:03:58 | For numbers greater than or equal to 60 and less than 3600:
|
3 | 63846 | 00:00:00 | 17:44:06 | For numbers greater than or equal to 3600:
|
Order | Field Value (raw format) | Formatting | Output | Description |
---|---|---|---|---|
1 | 1123456789 | 0,0e+0 | 1e+9 | Displays the nearest thousandth with the whole number and add 'e', and add 10-based exponent when the exponent is positive, subtract when the exponent is negative. |
2 | 12398734.202 | 0.00e+0 | 1.24e+7 | Displays the nearest thousandth with two digits after the decimal and add 'e' and add10-based exponent when the exponent is positive, subtract when the exponent is negative. |
3 | 0.000123987 | 0.000e+0 | 1.240e-4 | Displays the nearest thousandth with three digits after the decimal and add 'e' and add10-based exponent when the exponent is positive, subtract when the exponent is negative. |