Formulas to create a new metric

Aggregation Formulas

You can create new metrics from your data source by writing a Aggregation Formula to calculate a Column in the data source.

Use Table to create, name and calculate a new metric:

• Click + to create a new metric

Create a new metric

• Type the new metric name and click Create metric:

Name the new metric

• Ctrl+Double-click and type = to use Aggregation Formulas

Aggregation Formulas

• Choose a Formula and type the correct column name to find the column from the raw data table (data source)

Find the correct Column from the data source

Modeling Formulas

You can also create new metrics by calculating from existing metrics in a Table by Ctrl+Double-clicking at the empty cell and type the existing metrics name

Modelling a formula

Presight currently only supports 1 formula for a metric, so even if you change the formula of the past or future segment of a metric, or even a sub metric, this would be applied to the whole metric.

Check more about Formulas in the documentation below:

Formulas