Create a formula metric

Who can use this: Business admin

Available on: Gong Forecast

Ideal for: RevOps

Required permissions: Manage metrics

A formula metric combines two or more existing metrics, targets, or forecast submissions using a mathematical expression. Use this type when you need a measurement that cannot be calculated from a single field, for example win rate (closed-won divided by total closed), pipeline coverage (open pipeline divided by target), or booking attainment (bookings divided by booking target). For aggregating a single field directly, see Create a basic metric.

Step 1: Create the entities that assemble the formula

A formula metric calculates a result from existing entities. Before creating the formula metric, confirm that its underlying entities already exist.

• To create a basic metric (for example, Closed Won $ or Open Pipeline $), see Create a basic metric.

• To create a target (for attainment or gap formulas), see Create a target.

• Forecast submissions are configured through the Forecast board. They appear as selectable entities in the formula builder once a Forecast board exists.

If all your entities exist, continue to Step 2.

Step 2: Open the metric builder

Navigate to Data Studio and open the formula metric builder.

To open the metric builder:

1. From the left sidebar, click Admin center.

2. In the Settings tab, click Metrics on the Data Studio card.

3. Click New metric and select Formula metric.

Step 3: Build the formula

Enter a name and construct the formula expression.

To configure the formula:

1. Enter a name for the metric.

2. (Optional) Add a description to explain what the metric measures.

3. In the Formula field, build your expression:

   • Click Add entity to insert a metric, target, or forecast submission.

   • For forecast submissions, also select the Forecast board (line of business), the submission category, and whether to use individual submissions or team rollups. Individual submissions use the latest submission by that specific person; team rollups sum the latest submissions of the selected manager’s direct reports.

   • Use the operator buttons ( ) + − * / to compose the expression. For example: {Bookings $} / ( {Bookings $} + {Total Lost $} )

4. (Optional) Turn on Always treat null operands as 0s to prevent null values in any entity from producing a null result for the whole formula. This setting does not apply to target values: if a target is empty, the formula nulls out regardless of this toggle.

Tip:

Enable "Always treat null operands as 0s" when any metric may return no data for some team members, for example, a new hire who has not yet closed any deals. Without this setting, a null value in one centity produces a null result for the whole formula, which appears as blank rather than zero on dashboards.

Note:

Formula metrics cannot reference each other in a circular chain. Gong blocks the configuration if a circular dependency exists.

Note:

Formula metrics that use targets as entities cannot be used in custom chart widgets.

Step 4: Set the number format

Choose how the formula result is displayed on dashboards. Select the format that matches what your formula calculates.

To set the number format:

In the Formatting section, select the Number type:

• Number: A plain numeric value.

• Percent: The result is displayed as a percentage. Use this for ratios like win rate.

• Currency: The result is displayed as a currency amount.

• Custom: Define a custom display format.

Step 5: Save the metric

Review the formula result in the Preview panel to confirm the calculation looks correct, then save.

To save the metric:

1. Check the Preview panel to confirm the result for the selected team and period.

2. Click Save.

The metric appears in your metric list and is available to select when configuring dashboard widgets and Forecast boards.

Note:

Any edits to this metric take effect immediately in all dashboards and Forecast boards that use it. Learn more about managing your metrics.

Frequently asked questions