Formatting Data in a Visualizer Table

Visualizer provides data formatting options for measures and numeric attributes displayed in visualizations. Note: Formatting for numeric attributes is only available in Visualizer for Table and Crosstab reports.

You can format:

Units that represent magnitude, such as M for millions, to display in tooltips.

Suffixes

Currency symbols for measure values to display in tooltips and axis labels.

The number of decimal places to display in tooltips.

For other table formatting options, such as  the default Grand Total for measures, see Creating a Table in Visualizer.

To format the measure values and numeric attributes in a Visualizer table

  1. Create a table in Visualizer.
  2. Click Columns in Chart Builder. An options menu for each column displays.

  3. Click Data Formatting for the column you want to change. Note: Data formatting is available for measures and attributes with numeric values. Chart Builder displays the options with the defaults highlighted.
  4. Select your formatting options. Visualizer immediacy updates the table with your changes. Data can be formatted with Units, Suffix, Decimal Precision, and Currency.

  5.  Units
    • Auto default - commas (13,281,647)
    • None - no commas (13281647)
    • K - divide by 1,000 (13,281.65K)
    • M - divide by 1,000,000 (13.28M)
    • B - divide by 1,000,000,000 (0.01B)
    • % - multiply by 100 (1,328,164,700%)
  6. Suffix
    • None - 99
    • % - 99%
  7. Decimal Precision
    • All (695.5091224)
    • 0 Decimal (695)
    • 1 Decimal (695.5)
    • 2 Decimals (695.50)
    • 3 Decimals (695.509)
    • Custom. The custom range can be set as an integer between 1 - 99.
  8. Currency:
    • Tips:
      • Currency and date formatting also depends on the user's language locale setting. For more information, see Changing the Language.
      • The currency setting does not change the data. It is for display purposes only.
      • Visualizer supports dynamic currency symbols. You can define a variable and use it as the currency format by entering the GetVariable('variable_name') syntax. See Using Variables.