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.
- On the Home page, hover over a workbook, click Actions, and then select Open.
- In the Data Panel, select the column.
- 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.
- General - Change the column name,
data type, treat as (measure or attribute), and aggregation type.
- Click Save.