To create a calculated metric you need to populate the following fields and click the Create button when finished.

Name – Provide a descriptive name (i.e. "Average Order Value"). This will appear in the Metric selector for custom reports.

External Name – Automatically populated based on the value entered in the Name field and should not be modified. It can be changed from the recommendation during creation but it cannot be changed after it is created. The External Name value must be unique.

Formatting Type:

Integer (with customizable decimal places)

Currency (Decimal)

Time

Float

Percentage (with customizable decimal places)

Formula – Start typing and you'll see a list of predefined metrics which you can use to create a formula. Accepted operators include:

Plus (+)

Minus (-)

Divided by (/)

Multiplied by (*)

Parenthesis

Positive cardinal numbers (0-9), can include decimals

Using the minus operator as a negative is unsupported (i.e. A-B is supported, but -B+A is not). Formulas are limited to 1024 characters. Up to 5 (Standard) and 50 (360) calculated metrics are supported at the view level.

Note: Using another custom calculated metric in the creation of a new calculated metric isn't supported.

Using the Formula field and input examples

The Formula field provides a quick way to create and modify formulas using the following inputs: