Decimal Place Formatter

Decimal Place Formatter

Formatting a Table

You can format the tables that appear in various charts. Tables can be plotted standalone like Table and Cross Table, or they accompany other charts (like Sparkline Chart in which they accompany a Line, Area, or Column Chart). The table formatting options are explained below.

Column

The column formatting option is available in widgets like Table, Cross Table, and Sparkline Chart.

Decimal Place Formatter

The decimal place formatter allows you to

  • Select the number of decimal places to be displayed in a number
  • Select a unit for the displayed number

This option is available in the following widgets for the following entities.

Table:

  • Measure Column selected in the Column formatting option
  • Total formatting option
  • Sub-total formatting option

Cross Table:

  • Column Grand Total formatting option
  • Row Grand Total formatting option
  • Column Sub Total formatting option
  • Row Sub Total formatting option
  • Value formatting option for the selected measuring section

Sparkline:

Column formatting option for the selected measuring section

(info) Notes:

  • The DECIMAL PLACES formatter and DISPLAY UNIT options appear only for numerical variables.
  • These options appear when you select a particular variable for the entity. For example, in the case of a Sparkline Chart, if you select a variable like Sales or Quantity as Column variable, these options appear in the Format pane. |




The table given below describes different fields present on the Decimal Place Formatter.

Field

Description

Remark

Decimal Places

It allows you to select the number of decimal places in all the numbers belonging to a selected variable.

  • By default, Auto is selected. It means that the number of decimal places is the same as that present in the dataset.
  • You can select any number of decimal places up to 15.

Display Unit

It allows you to select the multiples of units in which the value is measured.

  • By default, None is selected as the Display Unit. None represents that no unit is set for the value.
  • You can select any of the following units
    • Default
    • None
    • Thousand
    • Lakhs
    • Millions
    • Billions
    • Trillions
  • Default indicates that the unit is assigned automatically by parsing the value.

To use the Decimal Place Formatter options, first plot a chart using dimensions and measures from the dataset.
For example, we plot a Table of Maximum of Sales by Category and Segment below.



Now, change the

  • Decimal places to three (3)
  • Display unit to Lakhs

The resultant table is shown below. After each value in the Sales (max) column, the letter ' L' indicates Lakh as the display unit. Also, the respective values are rounded off to the nearest number with three decimal places.



Similarly, you can apply the Decimal Place formatter to Column and Row Grand Total, as well as Column & Row Sub Total in a Cross Table chart.
Below is a Cross Table of the Average of Profit by Ship Mode and Region. The value at the bottom-right corner of the table (434.79) is called the Column Grand Total.



Now, change the

  • Decimal places to four (4)
  • Display unit to Thousands

The resultant Cross Table is shown below. After each value in the Sales (max) column, the letter ' K' indicates Thousand as the display unit. Also, the respective values are rounded off to the nearest number with four decimal places.



Since Sparkline chart accompanies a column containing numerical variable, you can apply the Decimal Place formatter to it.
Below is a Sparkline chart plotted for Sales per Ship Mode and Order Priority. The Sales(count) is the numerical column to which the decimal place formatter is applied.



Now, change the

  • Decimal places to four (4)
  • Display unit to Thousands

The resultant Sparkline Chart is shown below. After each value in the Sales (max) column, the letter ' K' indicates Thousand as the display unit. Also, a zero (0) is added at the end of each value to respect the number of decimal places.


    • Related Articles

    • Fixed Line

      The figure given below shows the Add Fixed Line page. The table given below describes different fields present on Add Fixed Line page. Section Field Description Remark Line Name It allows you to select a name for the Fixed Line. · Select a proper ...

    • Aggregate Line

      The figure given below shows the Add Aggregate Line page. The table given below describes different fields present on Add Aggregate Line page. Section Field Description Remark Line Name It allows you to select a name for the Aggregate Line. · Select ...

    • Date and Time Formatting on Chart

      In RubiSight, when you plot a chart using the Date and Time formatting feature, the coordinates of the plot appear in the standard ISO format, by default, as given below. Format: YYYY-MM-DD HH:MM:SS Where, YYYY-MM-DD is the date components of the ...

    • Data Labels

      Data labels refer to the text, values, or a combination of both, that appear on a chart. For example, a data label on a Column chart gives you information about the variable plotted on the Y-axis corresponding to that column. By default, the data ...

    • Changing the Workspace

      A workspace is a place where you can manage multiple datasets and projects. Workspaces are the parent structures that include datasets and projects. Workspaces are mapped to the login, which means you may have limited access to specific workspaces as ...