How Is a Most Recent Value Metric Calculated for a Group?

Last updated: November 17, 2026

A Group's Most Recent Value metric total doesn't add up every value that has been attributed to its members during a certain time frame. Instead, Ambition takes each member's latest value in the time frame and combines those values based on the metric's Group Computation Type.

Required permissions:

  • No special permission is required to view a Group's Most Recent Value metric totals.

How the Group Total Is Calculated

  1. Ambition finds each member's latest value in the time frame you're viewing.

  2. Ambition combines those values using the option chosen in the Group Computation Type drop-down menu when the metric was created. This option can't be changed after the metric is saved.

    1. Sum: Adds each member's latest value together.

    2. Average: Adds each member's latest value together, then divides by the number of members who have a value.

Members with no value in the time frame aren't included in the Group's total.

Most Recent Value Totals for Groups

Weekly Group Total

The East Team tracks open opportunities. During one week, its three members send these values:

  • Ana: 12 on Monday, 12 on Tuesday, and 10 on Wednesday. Ana's latest value is 10.

  • Ben: 8 on Monday, 4 on Tuesday, and 9 on Thursday. Ben's latest value is 9.

  • Carla: 6 on Tuesday only. Carla's latest value is 6.

If Sum is the chosen computation type, then the East Team's weekly total will be 25 (10 + 9 + 6).

If Average is the chosen computation type, the Group's Most Recent Value total is 8.33 (25 ÷ 3).

Daily Group Total

A daily total only counts the members who sent a value on that day. Using the same week as above, the East Team's members send these values on Monday:

  • Ana: 12 on Monday.

  • Ben: 8 on Monday.

  • Carla: No value on Monday, so Carla isn't counted.

If Sum is the chosen computation type, then the East Team's Monday total will be 20 (12 + 8).

If Average is the chosen computation type, the Group's Most Recent Value total for Monday will be 10 (20 ÷ 2).

Custom Period Group Total

A custom period, such as a 60-day range, works differently from a weekly total. Ambition uses only the last day in the range that has data and counts only the members who had a recorded value on that day. For this example, assume that values were recorded between September 1 to October 30 for the three East Team members:

  • Ana: 14 on September 15 and 15 on October 28. Ana didn't send a value on October 30, so Ana isn't counted.

  • Ben: 10 on September 2 and 11 on October 30. Ben's value on October 30 is 11.

  • Carla: 5 on October 1 and 7 on October 30. Carla's value on October 30 is 7.

If Sum is the chosen computation type, then the East Team's total for the 60 days will be 18 (11 + 7).

If Average is the chosen computation type, the Group's Most Recent Value total for the 60 days will be 9 (18 ÷ 2).

Note:

  • It's a best practice to send users' Most Recent Value totals daily, even if the totals have not changed.


Related Articles