Formatting Numeric Values of Columns

You can format numeric values of a column in your visualizations using a wide range of ready-to-use formats. For example, you might change the aggregation type from Sum to Average.

  1. On the Home page, select a workbook, click the Actions menu, and then select Open.
  2. In the Data Panel, select the column.
  3. In the properties pane for the selected column, use the General or Number Format tabs to change the numeric properties.
    • General - Change the column name, data type, treat as (measure or attribute), and aggregation type.

      For example, to change how a number is aggregated, use the Aggregation option.

    • Number Format - Change the default format of a number column.
  4. Click Save.

Related Topics

Visualizing and Analyzing Data

Creating a Workbook Using Datasets and/or Subject Areas

Begin to Build a Workbook and Create Visualizations

Working with a Workbook's Datasets

Building a Visualization by Adding Data from Data Panel

About Visualization Types

Using Advanced Analytics Functions

Creating Calculated Data Elements in a Workbook

Sorting Data in Visualizations

Undo and Redo Edits

About Refreshing a Workbook's Data

Refreshing a Workbook's Data

Pausing Data Queries in a Workbook

Working with Canvas Properties

Copying and Pasting a Visualization or Canvas

Copy and Paste a Visualization's Data

Working with Multiple Visualizations on a Canvas

Changing Visualization Types

About Visualization Properties

Adjusting Visualization Properties

Highlighting Important Data Events with Conditional Formatting

Applying Color to Visualizations

Formatting Numeric Values of Visualizations

Setting Currency Symbols for Visualizations

Adding Notes to Visualizations

Analyzing Data with Explain

Assigning Shared Folder and Workbook Permissions


Last Published Friday, December 8, 2023