Constant Sum Total in Data | Experience Community
Skip to main content
Solved

Constant Sum Total in Data

  • July 28, 2022
  • 4 replies
  • 763 views
A
Forum|alt.badge.img+3

Does the constant sum total show up in the data set? I would like that info to be in the data set so I don't have to calculate it after the fact.

Best answer by lizb311

I think the total does not show up in the data by default. But you should be able to go into your Survey Flow and add an embedded data field to save the total.
image.png

    4 replies

    lizb311
    Level 3 ●●●
    Forum|alt.badge.img+20
    • lizb311
    • Level 3 ●●●
    • Answer
    • July 29, 2022

    I think the total does not show up in the data by default. But you should be able to go into your Survey Flow and add an embedded data field to save the total.
    image.png

    A
    Forum|alt.badge.img+3
    • AWW15
    • Author
    • July 29, 2022

    Thank you! So I would create an embedded data "total sum" for each constant sum question, correct?

    lizb311
    Level 3 ●●●
    Forum|alt.badge.img+20
    • lizb311
    • Level 3 ●●●
    • July 29, 2022

    yes, that's right! make a separate embedded data field for every constant sum question you have. and just make sure that your embedded data fields come after the block in which the relevant questions appear.
    if you wanted to be able to analyze the results from that embedded data field directly in Qualtrics (e.g., in the Results tab), then you should also change the "Options" for the embedded data field to something like "Number." More info about the other options on this support site.

    J
    Forum|alt.badge.img+1
    • JMSurveys
    • September 20, 2023

    I think the total does not show up in the data by default. But you should be able to go into your Survey Flow and add an embedded data field to save the total.
    image.png

    When I attempted this, I do not see the “Total sum” option as a value to select (like the image you’ve shared here). The question I’m trying to base the embedded data off of is a constant sum question, so I do not understand why it does not show up. 

     

    Here is a screen shot. 

     

     

    Terms & ConditionsAccessibility statement