Gauge Formatting

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:

  1. Open a gauge in the gauge builder.
  2. Select the Design tab.

    bg_gaugebuilder_designtab.png

  3. Click on a field in the Formatting section.

    bg_gaugebuilder_designtab_formatting.png

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.

bg_gaugebuilder_format_decimal.png

 

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.
Was this article helpful?
13 out of 47 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