Inforiver comes packaged with intelligent number format & scaling recognition capabilities that help display data in a perceptive manner right out of the box. The in-built intelligence does the hard work so that you do not have to.
Let us take a sample dataset as shown below. You can immediately spot data of mixed granularity – with values in millions, thousands, and even one that is just a few dollars’ worth.
Let us see how Inforiver handles such a dataset of varying granularities & formats.
- Default Number Formatting
When you load this data, Inforiver scales each measure individually by default (and 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.
You can change this behavior by using the number formatting pane on the menu. You may select a ‘number formatting theme’ from the dropdown and customize it further using the icons shown right beneath the dropdown.
When you expand the dropdown, you see several options. The default behavior that formats each measure individually is labeled, well, ‘Default’.
Let’s observe what happens when we change this selection.
- Unified Number Formatting
When you change the format to ‘Unified’, Inforiver applies one fixed scale to the entire table, and moves the scaling unit display to the header. In addition, the number of decimals is reduced to one for better readability.
- Native Number Formatting
If you do not want any fancy formatting and need the numbers just as they are in the source data, select the ‘Native’ option.
- Auto Number Formatting
Auto formatting is a big favorite for many as it allows each cell to have its own scaling. Check this out. Notice how Category 1 total and Product 1 are scaled to millions while Product 9 is not scaled at all.
Other Intelligent Number Formatting Options
Inforiver uses a monospace font (Roboto Mono) that enables the scaling units ‘k’ and ‘m’ (for thousands and millions respectively) to occupy uniform width. If this were not the case (as with most standard fonts – like Arial, Times New Roman, Segoe UI, Open Sans etc.,) the decimals in the numbers would not align properly.
Inforiver also leaves some space on the right for Product 9 so that the decimal point continues to align perfectly with the other rows.
And what more, Inforiver also shows the unscaled values in the tooltip (available upon publishing to service). This means that you can still scale values without losing the ability to look up the unscaled value using the tooltip.
You may choose one of the four options, and continue to fine-tune the format at a row, column/measure or cell-level using the icons just below the dropdown. These options include conversion to % format, scaling (thousands, millions, etc.,), attaching prefix/suffix, and decimal spaces.
Check out this example where we have used the custom options above to change the formats of specific cells. (These actions can also be performed for individual rows or columns/measures)
Number formatting with Inforiver is much quicker and a lot of fun. Go ahead & try it out today.
* * *
Resources & Links