🎨 Format Numbers in Your Metrics (e.g. conditional formatting)

You can customise how numbers are displayed in metrics when using the Advanced Analytics tool. For example, you can round values, shorten large numbers (e.g. thousands, millions), display a fixed number of decimal places, use currency symbols, and apply colours or other formatting as needed.

🧾 Why Number Formatting Matters

It ensures your visualisations are readable and that number values align with your audience’s expectations (e.g. “1.2 M” instead of “1,200,000”).
It helps highlight key information by formatting numbers as percentages, currencies, or with colours for thresholds or conditions.

🛠️ How to Apply Number Formatting

To apply custom formatting:

In the metric editor, create a new metric or duplicate an existing one, then open the Number format dropdown at the bottom.
Select Custom.
Enter the desired format or choose from the available templates.
Use the Preview field to check your result.
Click Apply to save the format.

🧠 These formats control how numbers are shown in the visualisation — not how they’re stored.

📊 Examples

Format	Input	Output	Description

Format	Input	Output	Description
`#,##0`	1234.56	1,235	Rounded whole number
`#,##0.00`	1234.56	1,234.56	Two decimal places
`#,##0.00%`	0.847	84.70%	Converts to percent
`#,,.0 M`	1234567	1.2 M	Shortens to millions

Preserve Zeros

#.00 → 7 becomes 7.00
#.## → 7 becomes 7

Add Symbols or Text

$#,##0.00 → $1,234.56
#,##0 "views" → 1,000 views

🌟 Font & Background Colour Formatting

Text colour formatting is available in tables and headline reports only.
To apply colour, paste the below rules in the Custom formatting space.

Named Colours (Font Only)

Use named colours in square brackets at the start of your format:

[Red]#,##0.0

Available colours: Black, Blue, Cyan, Green, Magenta, Red, Yellow, White.
Use Hexadecimal Colours if the colour you wish to use is not in this list (see next paragraph).

Hexadecimal Colours

You can use hex codes for precise control:

[color=99AE00]#,##0.0

To set a background colour:

[backgroundcolor=FFD580]#,##0.0

You can combine both:

[color=99AE00][backgroundcolor=000000]#,##0.0

📅 Note: Do not prefix hex codes with #.

♻ Conditional Formatting (Colour-coded)

Use conditional formatting to apply colour rules based on the value of the metric. This is especially useful for visualising things like task completion rates or progress indicators.

Font Colour Example (with % Conversion)

This example formats a decimal number as a percentage and applies colour based on performance:

[>=0.8][color=006400]0.0%;
[>=0.5][color=CC6600]0.0%;
[<0.5][color=CC0000]0.0%;

0.8 becomes 80.0% in dark green
0.5 becomes 50.0% in orange
Below 0.5 is shown in red

Font + Background Colour Example

Adds background shading to match thresholds:

[>=0.8][color=003300][backgroundcolor=99FF99]0.00%;
[>=0.5][color=663C00][backgroundcolor=FFD580]0.00%;
[<0.5][color=FFFFFF][backgroundcolor=CC0000]0.00%;

🧬 Use this to draw attention to high, medium, and low performance ranges.

⏱️ Format Durations (Advanced)

Convert raw numbers (e.g. seconds) into time formats using arithmetic blocks:

{{{86400||#}}} days, {{{3600|24|00}}}:{{{60|60|00}}}:{{{|60.|00.000}}}

This would display:

120523.521 → 1 days, 09:28:43.521 hours

💪 Final Notes

Formatting affects how values display, not how they are calculated
You can format directly in the metric editor, or override it in the visualisation settings
Best practice: always copy the original metric or “save as new” when adding new formatting.
Always preview your changes before saving.

Last Reviewed: Nov 11, 2025