How Do I Create a Most Recent Value Metric?

Last updated: November 17, 2026

Most Recent Value metrics can be built from a Salesforce summary report or from any Performance Data API, FTP, File Upload, or Manual Entry integration that uses Daily Totals. The option won't appear in the Computation Type drop-down menu for Records data.

Required permissions:

  • The Metrics: Edit permission or the Integrations: Edit permission is required to create a Most Recent Value metric.

Prepare the Data

  • Salesforce: Build a Summary report grouped by user and then by a Today() date field, with the number you want to track as a summarized column. Then sync the report to Ambition.

  • Other integrations: Make sure the integration's Data Schema is Daily Totals and the value is mapped as a Number field. Send today's date with each day's values.

Access the Metric Creation Page

  1. Go to Admin --> Data --> Metric Library, click on Create New Metric, and select Salesforce Metric or Standard Metric.

  2. Under Basics, fill in the Name, Description, and Source-of-Truth fields.

Set the Metric Computation Type as Most Recent Value

  1. Under Computation, select your report from the Source Object/Report drop-down menu, or your integration from the Integration and Object drop-down menus.

  2. Select Most Recent Value from the Computation Type drop-down menu.

  3. Select Sum or Average from the Group Computation Type drop-down menu to choose how Group values are combined.

  4. Select the number field from the Value drop-down menu.

Set Who Receives Credit and When

  1. Select the user field from the Who Gets Credit? drop-down menu and the date field from the When Do They Get Credit? drop-down menu.

  2. Choose a format from the Display As drop-down menu.

  3. Click on Confirm and Save Changes.

Note:

  • The Computation Type and Group Computation Type can't be changed after the metric is saved.


Related Articles