---
sourceDocument: Australia Platform Analytics
sourceDocumentLink: https://www.servicenow.com/docs/r/australia/now-intelligence

 Release :

    - australia

ft:locale :

    - en-US

ft:publication_title :

    - Australia Platform Analytics

ft:clusterId :

    - par

bundleId :

    - par

workflow :

    - Platform


---

# Value formatting in data visualizations

# Value formatting in data visualizations {#ariaid-title1}

Release version: Australia  
Updated May 6, 2025  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 3 minutes to read
Summarize  
![AI sparkle icon](https://servicenow.com/docs/portal-asset/ai-sparkle-icon) Summarized using AI  
This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.  

## Summary of Value formatting in data visualizations

ServiceNow enables you to customize how numerical values are displayed in data visualizations, improving readability and relevance when publishing reports.
These formatting options are accessible via theFormat valuesbutton in the Metric section of your visualization's configuration panel.
Show full answer Show less  

## Key Features

* **Unit format:** Display time values in days, hours, minutes, and seconds (d/h/m/s or full labels).
* **Maximum/Minimum duration unit:** Set the largest or smallest time unit shown (Day, Hour, Minute, or Second).
* **Hide seconds option:** Automatically remove seconds from durations longer than one minute (available only if seconds are the minimum unit).
* **Decimal precision:** Control the number of decimal places from zero to four. Note that decimal precision is not supported on currency fields.
* **Rounding:** Simplify values greater than one minute with several rounding methods to keep numbers close to their original value.
* **Thousands group separator:** Insert commas or periods to separate thousands, improving number clarity.
* **Enable abbreviation:** Show large numbers with abbreviated units (e.g., K for thousands), except for currency values.
* **Hide value in tooltip:** Optionally prevent the unrounded and unabbreviated value from appearing in tooltips.

## Rounding Options

Rounding applies only to values greater than one minute and offers various modes to fit different reporting needs:

* **Up:** Rounds away from zero (e.g., 1.1 becomes 2, -1.6 becomes -2).
* **Down:** Rounds toward zero (e.g., 1.6 becomes 1, -1.6 becomes -1).
* **Ceiling:** Rounds toward positive infinity (e.g., -1.6 becomes -1).
* **Floor:** Rounds toward negative infinity (e.g., -1.6 becomes -2).
* **Half up:** Rounds to nearest whole number; ties round up (e.g., 2.5 becomes 3).
* **Half down:** Rounds to nearest whole number; ties round down (e.g., 2.5 becomes 2).
* **Half even:** Rounds to nearest even whole number in ties (e.g., 2.5 becomes 2, -2.5 becomes -2).

These options allow you to present data values in a manner that best suits your reporting standards and audience expectations.

## Practical Benefits

* Enhances clarity and professionalism of reports by tailoring numerical displays.
* Improves accessibility of time-based data with flexible unit and rounding configurations.
* Supports better decision-making by showing data with appropriate precision and formatting.  
In most data visualizations, you can configure how numerical values look when you publish the report.

## Types of value formatting {#value-formatting-dv__section_ck5_rqn_nnb}

Access value formatting from the Format values button in the Metric section of the configuration panel of your data visualization.  

Unit format
:   Show the format of time fields as d/h/m/s or day/hour/minute/second.

Maximum/Minimum duration unit
:   Select the largest or smallest unit to be shown: Day, Hour, Minute, or Second.

Hide seconds when unit is greater than one minute
:   Removes seconds display when a duration value is greater than one minute. Only available if you choose Second as the minimum duration unit.

Decimal precision
:   Number of decimal places to show, from zero to four decimal places.  
    Note:  
    Decimal precision is not supported on currency fields.

Rounding
:   For values greater than one minute, simplifies a number by rounding, while keeping it close to its value. See the next section, Rounding options.

Use the thousands group separator
:   Separate a value of thousands or higher with a comma or period.

Enable abbreviation
:   Show a value of thousands or higher with a single character.  
    Note:  
    Abbreviation for Currency, Price, or FX Currency values is not supported.

Hide value in tooltip
:   Do not show the unrounded, unabbreviated value in the tooltip.

## Rounding options {#value-formatting-dv__section_pb5_v5n_nnb}

For values greater than one minute, rounding options simplify a number, but keep it close to its value. Select from these rounding options:

* Up - to the next larger whole number if positive and to the next smaller whole number if negative. Example: For original values of:
  * 1.1 returns a value of 2
  * 1.6 returns a value of 2
  * -1.6 returns a value of -2
  {#value-formatting-dv__ul_vhl_qv1_5mb}
* Down - to the next smaller whole number if positive and to the next larger whole number if negative. Example: For original values of:
  * 1.1 returns a value of 1
  * 1.6 returns a value of 1
  * -1.6 returns a value of -1
  {#value-formatting-dv__ul_whl_qv1_5mb}
* Ceiling - to the next larger whole number, toward the positive. Example: For original values of:
  * 1.1 returns a value of 2
  * 1.6 returns a value of 2
  * -1.6 returns a value of -1
  {#value-formatting-dv__ul_xhl_qv1_5mb}
* Floor - to the next smaller whole number, toward the negative. Example: For original values of:
  * 1.1 returns a value of 1
  * 1.6 returns a value of 1
  * -1.6 returns a value of -2
  {#value-formatting-dv__ul_yhl_qv1_5mb}
* Half up - to the nearest neighboring whole number. If both neighbors are equidistant, rounds to the next larger whole number. Example: For original values of:
  * 1.1 returns a value of 1
  * 1.6 returns a value of 2
  * 2.5 returns a value of 3
  {#value-formatting-dv__ul_n1n_sqn_nnb}
* Half down - to the nearest neighboring whole number. If both neighbors are equidistant, rounds to the next smaller whole number. Example: For original values of:
  * 1.1 returns a value of 1
  * 1.6 returns a value of 2
  * 2.5 returns a value of 2
  {#value-formatting-dv__ul_o1n_sqn_nnb}
* Half even - to the nearest whole number. If both neighbors are equidistant, rounds to the closest even number. Example: For original values of:
  * 1.1 returns a value of 1
  * 1.6 returns a value of 2
  * -2.5 returns a value of -2
  {#value-formatting-dv__ul_p1n_sqn_nnb}
{#value-formatting-dv__ul_m1n_sqn_nnb}

Summary of rounding options:
{#value-formatting-dv__table_u2h_1cf_w4b__entry__8}

| Input number | Up | Down | Ceiling | Floor | Half up | Half down | Half even |
|-|-|-|-|-|-|-|-|
| 5.5 | 6 | 5 | 6 | 5 | 6 | 5 | 6 |
| 2.5 | 3 | 2 | 3 | 2 | 3 | 2 | 2 |
| 1.6 | 2 | 1 | 2 | 1 | 2 | 2 | 2 |
| 1.1 | 2 | 1 | 2 | 1 | 1 | 1 | 1 |
| 1.0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| -1.0 | -1 | -1 | -1 | -1 | -1 | -1 | -1 |
| -1.1 | -2 | -1 | -1 | -2 | -1 | -1 | -1 |
| -1.6 | -2 | -1 | -1 | -2 | -2 | -2 | -2 |
| -2.5 | -3 | -2 | -2 | -3 | -3 | -2 | -2 |
| -5.5 | -6 | -5 | -5 | -6 | -6 | -5 | -6 |
[Table 1. Result of rounding input to one digit with the given rounding mode]

{#value-formatting-dv__table_u2h_1cf_w4b}