---
sourceDocument: Xanadu Platform Analytics
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/xanadu/now-intelligence

 Release :

    - xanadu

ft:locale :

    - en-US

ft:publication_title :

    - Xanadu Platform Analytics

ft:clusterId :

    - par

bundleId :

    - par

workflow :

    - Platform


---

# Value formatting in data visualizations

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

* Release version: Xanadu
* 
* Updated May 6, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 3 minutes to read

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}

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}