Number formatting

Numbers in supported dashboard widgets can be displayed with a common format or a custom Numeral pattern. The preview shows how the active format displays a current or representative value.

Choose a format

• Number format starts as a compact summary of the active format and preview. Select the summary to show or hide the presets and Pattern field.
• The current widget value is shown in the preview when one is available. In a Grid, selecting a numeric cell uses that cell as the sample. A representative value is shown otherwise.
• Source keeps the number format supplied by the underlying model. When a selected Grid cell matches a supported Numeral format, its pattern is shown in the Pattern field.
• Default keeps the widget's built-in format. For example, a Big Number uses its compact format, such as 8k, and shows that default pattern in the Pattern field.
• A preset can be selected by choosing its formatted example.
• The selected preset's pattern is placed in the Pattern field and can be edited.

The available presets include whole numbers, numbers with two decimal places, percentages, and compact thousands or millions.

Enter a custom pattern

A Numeral pattern can be entered directly in the Pattern field. Common examples include:

• #,##0 displays 12345.67 as 12,346.
• #,##0.00 displays 12345.67 as 12,345.67.
• #,##0% displays 0.1234 as 12%.
• #,##0.00% displays 0.1234 as 12.34%.
• #,##0a displays 12345.67 as 12k.
• #,##0.0a displays 12345.67 as 12.3k.

The pattern shown for Source or Default is informational and does not create an override. Selecting a preset or editing the field creates one. The override can be removed with the clear button in the Pattern field, restoring the widget's Source or Default format.

Invalid patterns

An invalid pattern is retained so it can be corrected. The preview is marked as invalid, and the widget continues to use its configured fallback format until a valid pattern is entered or the override is cleared.