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
Go to Admin --> Data --> Metric Library, click on Create New Metric, and select Salesforce Metric or Standard Metric.
Under Basics, fill in the Name, Description, and Source-of-Truth fields.
Set the Metric Computation Type as Most Recent Value
Under Computation, select your report from the Source Object/Report drop-down menu, or your integration from the Integration and Object drop-down menus.
Select Most Recent Value from the Computation Type drop-down menu.
Select Sum or Average from the Group Computation Type drop-down menu to choose how Group values are combined.
Select the number field from the Value drop-down menu.
Set Who Receives Credit and When
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.
Choose a format from the Display As drop-down menu.
Click on Confirm and Save Changes.
Note:
The Computation Type and Group Computation Type can't be changed after the metric is saved.