Creating a metric using formula

Get step-by-step guidance on create metrics using formulas in Drivetrain.

You can create a metric using a formula by simply referencing any existing metrics in the formula builder.

We can use formulas in Drivetrain to build the ARR/FTE metric, which we will define as:

$ARR\:per\:FTE = Closing\:ARR / Closing\:Headcount$

Note: Assume that both Closing ARR and Closing Headcount metrics have already been created in Drivetrain

• In the Metric Builder page, select the Calculate using Formula option.

• In the Formula column, start typing in the metric names and the auto-suggest will load the metric names that match. Select the metrics and click Apply.

You can break down metrics created using formulas by dimensions.

Only those dimensions that are common to all of the metrics used in the formula can be applied to the calculated metric.

The Formulas section contains the nuances around adding time shifts or offsets as required.

Formulas in Drivetrain

Now that you've created your metrics, the next step is to add the dimensions by which you can drill down a metric in your reports.