Gauge Formatting

This article details all of the different ways to format your number gauges and labels.
 
When a field value is a number, you can apply various different number formats. These are located under the Formatting section of the Design setting within the gauge builder. To access in the Gauge builder, click on the "Design" option under the BrightGauge logo on the top left of the screen.
 
By default, numbers formats in gauges round to the nearest whole number (no decimals). This, along with adding desired notations, can easily be changed using our Standard or Custom number formats outlined below.

 

Standard Formatting

The clip below outlines how the standard formatting options work:

123 (Numeral) - Allows the number to de displayed without any notation

% (Percent) - Allows the number to be displayed as a percentage (Please note that the raw format of the number in the dataset must be a decimal. The number format then multiplies the decimal by 100 and displays the percent symbol.)

$$ (Currency) - Allows the number to be displayed in your local currency. (Uses the $ symbol in the formatting, but the output will be the local currency sign $, £, or €. Local Currency is based on account's language setting.)

00011 - Allows the number to be displayed in computer notation (Please note that the raw format of the number must be in bytes. The number format then converts the number to the appropriate magnitude using binary calculation [1024 base].)

 

Decimals

All four options listed above, allow the option to display decimals. To configure the desired number of decimal places to display, simply hover of the box titled "Decimals:" and use the arrows that appear to select the desired number.

Please note by default all numbers are set to not display decimals, which rounds the number to the nearest whole.)

 

Abbreviations

The Numeral and Currency options listed above, provide two options to display the number:

-Regular: Which shows the full number using commas to separate the number places accordingly (ones, tens, hundreds, etc)

-Abbreviated: Rounds to the nearest thousandth and displays a letter for the magnitude change 

Custom Formatting

To use our Custom formatting option, Select the "Custom" option from the number formatting modal.

 

Formatting Options

Field Value (raw format) Formatting Output Description
 Numerals
79880 ###0  79880 Rounds to nearest whole
82345 #,###.0 82,345.0 One forced figure after the decimal point and separators in the whole number where appropriate
28951245643 #,###.#0 28,951,245,643.00 Two forced factors after the decimal point and separators in the whole number where appropriate
49 #.###,#0 48.991562 Five forced factors after the decimal point
6155 #,#.###0 6,154.7591 Four forced factors after the decimal point and separators in the whole number where appropriate
42345  #,0 42,345 Separators in the whole number where appropriate and round to nearest whole number
824 +#,0 +824 Round to nearest whole, separators where appropriate, and display positive or negative notations where appropriate
1237 #.##0 1236.889 Three forced factors after the decimal point 
 222 #[.]####0  221.44589  If appropriate, 5 factors after the decimal point (if no decimal, it shows as a whole number)
 225 #[.]####0  225 (same as above just noting difference) 
 -2984 (#,#.###0)   (2983.1490) Four forced factors after the decimal point and separators in the whole number where appropriate.  If the number is negative, it will appear in parenthesis.
3234  .#0  .54 Strips the whole number and displays only the decimals to two forced  factors after the decimal
23413  #.####0  23412.97000  Five forced factors after the decimal point and displays the whole number
 1965  #.#[###0] 1965.125  Displays 1 forced factor after the decimal with allowance up to 5 total, if appropriate and displays the whole number 
 254976 #.0a  255.0k  Rounds to the nearest thousandth with one factor 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 leters after the number, rounds to the nearest whole number (1st, 2nd, 3rd, 4th...)
Percentages
3 ##.#0% 300.00% Multiplies the value by 100, adds a percent sign, and forces two factors after the decimal
3.556 #0% 356% Multiplies the value by 100, adds a percent sign, and rounds to the nearest whole number
Computer Notations
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).  One forced factor after the decimal.
23190 #.##0 b 23.190 KB Converts the number to bytes using binary calculation (1024 base).  Three forced factors 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.)
 231987 $#,#.#0   $231,1986.52 Two forced factors after the decimal point, separators in the whole number where appropriate, and adds the local currency symbol at the beginning of the number
 6745 #,#[.]#0 $  6,745.32 $  If there are numbers after the decimal, there are two forced factors after the decimal point, separators in the whole number where appropriate, and adds a space and local currency symbol at the end of the number 
3459   $ #,#[.]#0 $ 3459.48  If there are numbers after the decimal, there are two forced factors after the decimal point, separators in the whole number where appropriate, and adds a space and local currency symbol at the beginning of the number  
 5222  ($#,0) $5,222 Separators in the whole number where appropriate, round to nearest whole number, and adds local currency symbol at the beginning of the number.  If the number is negative, it will show in parenthesis.
 9998  $#.#0 $9997.98  Two forced factors after the decimal point and adds local currency symbol at the beginning of the number 
 4246  ($ #.#0 a) $4.25 k  Displays the nearest thousandth with two factors after the decimal, displays a letter for the magnitude change, a space between the magnitude symbol and the number, and local currency symbol at the front of the number.  If the number is negative, it will show in parenthesis.
8232567 $#.0a $8.2m Displays the nearest thousandth with one factor after the decimal, displays a letter for  the magnitude change, and local currency symbol at the front of the number
50675183678 $0a $51b Rounds to the nearest thousandth, displays a letter for the magnitude change, and local currency symbol at the front of the number
2657 $ 0a $ 3k Rounds to the nearest thousandth, displays a letter for the magnitude change, and local currency symbol at the front of the number separated by a space
Was this article helpful?
3 out of 3 found this helpful

Comments

10 comments

  • Is there a way to make a zero appear as a hyphen or just blank?

    0
  • Hi Sonny,

    There's issues when displaying zeros when there's a lack of data.  It's something that we're working on and you can track here: https://support.brightgauge.com/entries/21441572--Gauges-Say-No-Tickets-are-Currently-Open-instead-of-no-data-available-

     

    Randall

    0
  • Well, the zeros are displaying just fine.  For example, I'd like a chart that looks like this:

    0 | 2 | 7

    0 | 0 | 9

    1 | 8 | 0

    To look like this:

       | 2 | 7

       |    | 9

    1 | 8 | 

    0
  • Would it be possible to add some formats in for time? eg: converting x number of seconds to hh:mm:ss or mm:ss ?

    0
  • Would love to have the ability to display ratios as well.

    0
  • How about adding a "blank" icon picture to the Set Conditional options under Colors & Thresholds... then we could add the condition "if = 0, set icon to blank". Also add a couple of dashes... one black, one red, one yellow and one red. Simple.

    Now about "division by zero"... it would be good if we could blank that as well... (!)

    Thanks!

    //ray

    0
  • "Now about "division by zero"... it would be good if we could blank that as well... (!)" I agree - I'd love to be able to suppress that or convert it to zero (like Excel's handling of the Div/0 error).

    0
  • In there any way to display the result as a % without multiplying the result by 100? For example, I want a result of 98 to simply be 98%, not 9800%.

    0
  • @John Hall - You can open the gauge, click on Design, click on the field under formatting, select % and set the number of decimal places you want.

    0
  • I have tried that but what it does is give me a result that looks like 9800.00% (still multiplying by 100, then just adding 2 decimals after the whole number of 9800)

    0