How to properly create a formula field using embedded data? | XM Community
Skip to main content
I am trying to create an embedded data field that takes the ratings of three questions (single select scale 1-5) and creates an average.



Efficient (Number) = ${q://QID2032/SelectedChoicesRecode}

Easy (Number) = ${q://QID2033/SelectedChoicesRecode}

Emotion (Number) = ${q://QID2034/SelectedChoicesRecode}



CX (Number)= $e{ ( q://QID2032/SelectedChoicesRecode + q://QID2033/SelectedChoicesRecode + q://QID2034/SelectedChoicesRecode ) / 3 }



It doesn't return any data. Is there something wrong in my formula?



Thanks,

Melissa
You should be able to do this through Scoring.

https://www.qualtrics.com/support/survey-platform/survey-module/survey-tools/scoring/
Scoring is a useful tool, but it doesn't allow for equations.



You should just need to add the ```${ }``` back in where you removed it. I think I also used to have issues with spaces, but I can't remember for sure. Try:



CX (Number)= $e{(${q://QID2032/SelectedChoicesRecode}+${q://QID2033/SelectedChoicesRecode}+${q://QID2034/SelectedChoicesRecode})/3}
Thanks Kate...I tried it but still no data comes through.



Any other thoughts? I'm so frustrated...
> @Melissa_Kaiser_psu89 said:

> Thanks Kate...I tried it but still no data comes through.

>

> Any other thoughts? I'm so frustrated...



Your original equation is correct (spaces are required). The problem must be with your piped values. Some examples: they aren't all numbers (e.g. multi-select would be a comma separated list), it isn't a valid pipe for the question type(s), or the QIDs are wrong.
Thanks Tom...you were right. I went back to my original equation and changed what I piped in. Now I see data for the most recent 6 responses but nothing beyond that. Is there some reason it doesn't show data for all my records? Is there something else I have to do?



Thanks so much for your help!

Melissa
> @Melissa_Kaiser_psu89 said:

> Thanks Tom...you were right. I went back to my original equation and changed what I piped in. Now I see data for the most recent 6 responses but nothing beyond that. Is there some reason it doesn't show data for all my records? Is there something else I have to do?

>

> Thanks so much for your help!

> Melissa



If the formula wasn't correct when the respondent took the survey, the field won't be populated. I think you can create a new field in Data & Analysis and create a formula there to do the calculation.
Thanks...that's what I was afraid of! I need to be able to pull this data into an existing dashboard and I don't think I can with the calculated field in Data & Analysis. I wonder if there's a way to go back and populate the embedded data field correctly so I can use it in the dashboard? Any thoughts?
> @Melissa_Kaiser_psu89 said:

> Thanks...that's what I was afraid of! I need to be able to pull this data into an existing dashboard and I don't think I can with the calculated field in Data & Analysis. I wonder if there's a way to go back and populate the embedded data field correctly so I can use it in the dashboard? Any thoughts?



Two ways:

1. Manually edit the responses where the value is missing

2. Update the embedded field using the API, see: https://api.qualtrics.com/reference#update-response-1

Leave a Reply