In this article
This page covers how to create a number formatter and lists the default number formatters and their intended use.
Creating a Number Formatter
To create and configure a number formatter, follow these steps:
Click the Formatters icon in the Sidebar to open the Formatters panel.
Click the Number tab to open the list of existing number formatters.
Click the plus + icon next to "Formatters".
Decide on an Integer seperator, Decimal separator and Number of decimals.
In the Empty value field, define what you want to appear if there is no value, for example you may want to use N/A, - or just keep the Empty value field blank.
In the Pre fixed string and Post fixed string fields, define "fixed strings". These will always appear before (pre) and after (post) your formatter.
Decide whether to toggle "Keep trailing zeros", which maintains zeros at the end of a decimal point. For example 12.34000.
Decide whether to toggle "Use short form (K/M/G)". This represents large numbers in a shortened format.
1K = One thousand (1000), 1M = One million (1,000,000) and 1G = One billion (1,000,000,000)
Your number formatter will be saved automatically.
List of Default Number Formatters
| Formatter | Default usage |
|---|---|
integerDefaultFormatter | Response rate (statuses tile) Contact survey response (bar item) |
currencyDefaultFormatter | Table-based widgets (column currency) Summary (renewal risk tile - revenueFormat) Top accounts (account column - revenueFormat) |
percentDefaultFormatter | Response rate (statuses tile - percentFormat) Data Grid (stacked bar chart - percentFormat) Drop Off (valueFormatter) Quotas (valueFormatter) Survey Metrics (percentFormat) |
floatDefaultFormatter | KPI (value tile, kpi tile) Table-based widgets (column metric) Trend (format) |
oneDigitFloatDefaultFormatter | Summary (metric tile) |
metricsItemMetricDefaultFormatter | Metrics (metric item) |
statisticPercentsDefaultFormatter | Frequency table (percents statistics) |
numberStatisticDefaultFormatter | Frequency table (numeric statistics) |
statisticCountDefaultFormatter | Frequency table (count statistics) |
bigNumberFormatter | Survey metrics (numberFormat) |