6.6. Number formatting

Inforiver Analytics+ comes prepackaged with intelligent number formatting & scaling recognition capabilities that help display data in a perceptive manner in your table/matrix reports.

1. Number scaling

Analytics+ can auto-detect the granularity of your measures and display them accordingly. For instance, if your report contains data with mixed granularity i.e. some values may be in thousands, some in hundreds, and some in millions - Analytics+ will render the table accordingly. You can also override the default scaling and apply a custom scaling factor with the Quick format options.

Let's take a quick look at the different options.

i) Uniform scaling

The 'Uniform' option applies one fixed scale to the entire table and moves the scaling unit display to the header. This is useful when all the measures are of comparable magnitude (e.g., Sales vs Forecast) in the same table.

Universal scaling

Inforiver automatically applies a scaling factor that is best suited for your data, but you can set a custom scaling factor as well.

Uniform scaling with custom scaling factor

ii) Measure level scaling

When your measures are of different magnitudes, you can apply measure-level scaling. The scaling for each measure is shown in the column header. This is useful to show measures of varying granularities (e.g., Revenue & Quantity) in the same table.

Measure-level scaling

iii) Auto scaling

When using the 'Auto' option, each cell is formatted individually, this can be used when the measures have mixed granularities of data in them. In the example, notice how the suffixes - m and k have been used to denote millions and thousands.

Auto scaling

iv) Native scaling

To view the source data as-is without any formatting, you can choose native scaling.

Native scaling

2. Percentage, prefix/suffix, and decimals

Analytics+ provides additional formatting options to convert values to percentages, add a suffix/prefix, and calibrate the number of decimal places to be displayed.

Additional number formatting options

i) Percentages

In the example below, the Margin field is actually a percentage value. To display this as a percentage, you need to first select the field - the % button gets enabled. Then click on the button to convert the values to percentages.

% option is enabled on selecting the column/row/cell

Column is converted and displayed as a percentage

ii) Prefix/suffix

You can add more context to your data using a prefix or suffix when applicable. For instance, you can add a currency prefix to a column that contains price data.

Adding a prefix and suffix

The column is displayed with the specified prefix and suffix

iii) Decimals

You can increase or decrease decimal precision at a cell/row/column level. Select the column for which you want to adjust the decimal places - the precision buttons are enabled on selecting a column/row/cell. Click on the buttons to increase or decrease the precision.

Let's increase the precision for the forecast variance.

Select column/row/cell/ to adjust precision

Decimal precision has been increased for the column

Next, let's see how to embed charts in your tables.