Number Format

Number Format

Number Formatting allows you to change the way numerical entities appear on the X and Y-axes. It is applicable for features under Measures (numerical variables).
The figure below shows the available Number Format options.



The table given below describes different fields available for Number Formatting.

Field

Description

Remark

It allows you to select the format in which the number is displayed.

The following options are available:

  • General
    • displays the number in the default format
  • Currency
    • displays the number as Currency
  • Percentage
    • displays the number as a percentage

It allows you to select the Currency and its symbol next to the number on the axis.

  • The following currencies are available:
  • ₹ English (India)
  • $ English (United States)
  • £ English (United Kingdom)
  • € Euro
  • ¥ Chinese
  • CHF French (Switzerland)
  • This option is disabled when you use the percentage option.

% (Percentage)

It allows you to convert the axis values into a percentage.

The remaining two options (Currency and Comma) are disabled when applying the percentage.

',' (Comma)

It allows you to insert a comma in numbers as per the conventional standards.

This option is disabled when you use the percentage option.

Prefix

It allows you to add a prefix to the axis value.

It is used when you want to add a time or currency indicator to the value.

Suffix

It allows you to add a suffix to the axis value.

It is used when you want to add a time or currency indicator to the value.

To use the Number Format option, first plot a Column Chart using the dimensions and measures from the dataset. For example, we plot a Column Chart of the Maximum of Sales by Segment. The Region is used as the Legend.
The figure given below shows the original Column Chart. The General number format selection indicates that the Sales values (on Y-axis) are the default values in the dataset.



Now,

  • change the number format settings to Currency and
  • select Euro from the currency dropdown.

The resultant widget is shown below.


You can simultaneously apply the Comma separator for the values.
The resultant widget is shown below.


Now, select the Percentage option. Subsequently, the Currency and Comma options are disabled for selection.



Also, enter a suitable PREFIX or SUFFIX in the designated fields for the axis values.
The resultant widget is given below.



    • Related Articles

    • Number Plate Detection

      For Number Plate Detection, the pre-trained models used are Pytesseract Trained Neural Network Notes: Pytesseract is an independent library inside Python for text detection in images. It can detect alphanumeric as well as special characters from the ...
    • Number Plate Detection

      For Number Plate Detection, the pre-trained models used are Pytesseract Trained Neural Network Notes: Pytesseract is an independent library inside Python for text detection in images. It can detect alphanumeric as well as special characters from the ...
    • Tooltip

      The Tooltip is a little box that pops up when you hover over the widget. It is always attached to something, like a bar on a bar chart or a dot on a line chart. Tooltip provides us the contextual information and additional important information on a ...
    • Configuring Display Unit Mapping

      Display Unit Mapping-Formatter To display chart labels/tooltip values/axis labels and such applicable values wherein the display unit is displayed, the formatter -Display Unit Mapping is available in the page level Format pane options. (To Navigate: ...
    • Data Labels in Pie and Donut Charts

      Refer Data labels for using general formatting options for the charts. Along with these options, Pie and Donut charts are provided with additional formatting options. The below options are available with their respective formatting options- Figure 1: ...