Formatting Numbers

Note: IT Visibility is being upgraded with the introduction of Technology Intelligence Platform beginning in September 2024. Flexera will contact you directly regarding the timeframe of your upgrade. With Technology Intelligence Platform, out-of-the-box IT Visibility dashboards are being replaced with new, enhanced IT Visibility Technology Intelligence Platform reports. For more information, see IT Visibility With Technology Intelligence Platform Reports.

You can customize the format of the measures and attributes you add to the Measure section in your insights. For example, you can round numbers, shorten large numbers, display fixed number of zeros, display currency symbols, add colors, and so on.

For every measure and attribute in your Measures section, you can configure your own custom format using specific syntax or select from a variety of predefined formats.

The formatting applies only to the individual measure/attribute instance and current insight.

Refer to the following subsections on this page:

• Regional Settings
• Defining Custom Number Formats
• Digit Placeholders
• Selecting Predefined Number Formats
• Predefined Formats
• Default Format

Regional Settings

Your regional settings define how the decimal point and the thousands separator are displayed in your insights.

Defining Custom Number Formats

The custom number format enables you to:

• Select a specific format from various formatting templates
• Define your own number format
• Adjust an already selected format.

For information about placeholders' syntax in definitions, see Digit Placeholders.

To define custom number formats:

1. In the Measures section, click Format > Custom in the measure settings.

2. In the custom format section, do one of the following:
a. In the format definition, use digit placeholders.
b. Click Templates to select from a list of predefined formats.

c. Hover your mouse over the question mark on the right side of the template name to display examples of the formatting.

d. Adjust a previously defined/selected format in the Definition section.
3. Click Apply.

The insight now displays the numbers in your selected format.

Digit Placeholders

When defining your custom number format, use the following placeholders to define the custom number format.

Placeholder

Description

0
(zero)

Digit placeholder.

The number of 0 (zeros) in the format definition corresponds with the numbers of digits displayed.

#
(hash)

Digit placeholder.

Displays digits without extra 0 (zeros).

.
(dot)

Decimal point.

Based on your Regional Settings, displays as. (dot) or, (comma).

,
(comma)

Thousand’s separator.

Based on your Regional Settings, displays as, (comma) or. (dot).

%
(percentage)

Percentage placeholder.

Multiplies the value by 100 and adds the % (percentage) character.

Selecting Predefined Number Formats

Data Explorer offers predefined formats you can choose from.

To choose a predefined number format:

1. In the Measures section, click Format in the measure settings.

2. In the dropdown menu, select a format.

For details, see the Predefined Formats section.

The insight now displays the measure in your selected format.

Predefined Formats

The following table provides descriptions of predefined formats.

Placeholder

Description

Format

Input Examples

Output Examples

Inherit

The format is inherited from the definition in Manage > Metrics section.

-

-

-

Rounded

Number with the thousand's separator rounded to the nearest whole number.

#,##0

1234.5678
0.123

1,235
0

Decimal (1)

Number with one decimal digit.

#,##0.0

1234.5678
0.123

1,234.6
0.1

Decimal (2)

Number with two decimal digits.

#,##0.00

1234.5678
0.123

1234.57
0.12

Percent
(rounded)

Number multiplied by 100 with the thousand’s separator rounded to the nearest whole number.

#,##0%

1,234.5678

123,457%

Percent (1)

Number multiplied by 100 with the thousand's separator with one decimal digit.

#,##0.0%

1,234.5678

123,456.8%

Percent (2)

Number multiplied by 100 with the thousand's separator with two decimal digits.

#,##0.00%

1,234.5678

123,456.78

Default Format

When you add measures or attributes to your insight, Data Explorer assigns the following default number formats.

• Measures > Decimal (2)—Measures are displayed as numbers with two decimal digits.
• Calculated measures > Inherited—Calculated measures inherit the format from their definition in the Manage > Metrics section.
• Attributes > Rounded—Attributes (count of attributes) are displayed as rounded whole numbers.

If you enable show in %, the default format will switch to Percent (2).