Format 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.