SUM across multiple submissions | XM Community
Skip to main content
Solved

SUM across multiple submissions

  • November 9, 2021
  • 1 reply
  • 55 views
EvyLizarraga
Forum|alt.badge.img+4

We have a survey that helps users track their physical activity each day.
Each day a user can report their physical activity for a chosen calendar date. We'd like to show the user the sum of all of their entries each time they log in to the survey before they enter more time.
Is there a way to have the survey's entries sum displayed to the participant after each submission and/or at the beginning of each entry?
Thank you.

Best answer by TomG

You could keep a running sum as a field in your contact list (e.g. sum):

  1. Add sum as an embedded data field to be populated from the contact list at the beginning of the survey flow

  2. Display the sum in a question: ${e://Field/sum}

  3. At the end of the survey flow, calculate the new sum: sum = $e{ e://Field/sum + new_activity_field_or_question_value_goes_here }

  4. Use a contact trigger or action to update the contact's sum.


Evy L. Edwards

      1 reply

      TomG
      Level 8 ●●●●●●●●
      Forum|alt.badge.img+27
      • TomG
      • Level 8 ●●●●●●●●
      • Answer
      • November 9, 2021

      You could keep a running sum as a field in your contact list (e.g. sum):

      1. Add sum as an embedded data field to be populated from the contact list at the beginning of the survey flow

      2. Display the sum in a question: ${e://Field/sum}

      3. At the end of the survey flow, calculate the new sum: sum = $e{ e://Field/sum + new_activity_field_or_question_value_goes_here }

      4. Use a contact trigger or action to update the contact's sum.


        Terms & ConditionsAccessibility statement