Custom formatting gives you greater control over how numeric data appears in a Analytics result set. With custom formatting, you can apply Excel-style formatting options to numeric data shown in visualizations, or produced by custom fields or table calculations.

• Using Custom Formatting in Visualizations
• Using Custom Formatting with Table Calculations and Custom Fields
• Custom Formatting Examples

Using Custom Formatting in Visualizations

To use custom formatting with numeric data in a visualization:

1. Click on the visualization’s gear menu.
2. Select the Values tab.
3. In the Value Format field, enter the custom formatting string.

Using Custom Formatting with Table Calculations and Custom Fields

When creating or editing a table calculation or custom field, select Customin the formatting drop-down and enter the custom format in the field below:

Custom Formatting Examples

Some of the most common formatting options are shown below. A format code using 0 requires that non-significant zeros be displayed if the number contains fewer digits than specified in the code. A format code using # only displays significant digits, even if there are fewer digits than specified in the code.

Some special characters, such as international currency symbols, must be treated as strings and enclosed in double quotes.