Creating a new formula/variable based off items selected in multiple answer questions | XM Community
Skip to main content
Solved

Creating a new formula/variable based off items selected in multiple answer questions

  • June 30, 2023
  • 4 replies
  • 866 views
I
Level 1 ●
Forum|alt.badge.img+2

Hi all,

 

I’m wanting to find out a way to create a new variable (via a multiple answer question) so it will tally the number of items participant’s selected. At this moment, the csv data file has their answer like “1, 3, 8, 9” instead of 4.

The final option they can select is “I haven’t experienced any” which I’ve coded as 0. I’m wanting to know the number of events people select (minus the final answer), because I have further data regarding the number of events. I know I can manually count each answer, but if I’m collecting 200 participants’ data, this isn’t a very good use of my time.

I’ve tried to create a new field/formula, however, it won’t allow me to select the relevant question when trying to put the selections in the formula (i.e., a+b+c, etc.). 

 

Any ideas would be helpful! This is my furst survey so I’m totally lost and don’t even know what phrases I would use to search if someone else had already asked haha.

 

Thanks!

Best answer by TomG

@IzzyS,

It isn’t clear to me if you’ve already fielded the survey.  If you haven’t, you can pipe the count of selected choices for a MC question into an embedded data field in the survey flow. It would be something like this:

Set Embedded Data: Q1count = ${q://QID1/SelectedChoicesCount}
Branch: IF Q1 Selected Choice Is Equal To I haven’t experienced any
    Set Embedded Data: Q1count = 0

If you’ve already fielded the survey, you can use a formula in Excel:

=IF(A1=0,0,LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1),",",""))+1)

TusharDalwani
R

4 replies

ArunDubey
QPN Level 8 ●●●●●●●●
Forum|alt.badge.img+41
  • ArunDubey
  • QPN Level 8 ●●●●●●●●
  • June 30, 2023

you can achieve this using Scoring option of Qualtrics. Please refer below link.  

 

https://www.qualtrics.com/support/survey-platform/survey-module/survey-tools/scoring/

~ Arun Kumar Dubey
PraDeepKotian_XM
O
I
Level 1 ●
Forum|alt.badge.img+2
  • IzzyS
  • Author
  • Level 1 ●
  • June 30, 2023

Thanks Arun, I followed the link and it definitely helped my csv output. However, I was wanting to do this in the survey prior to exporting the data (i.e., making a new variable/formula so when downloaded, it’s already done). Is this possible?

O
ArunDubey
ArunDubey
QPN Level 8 ●●●●●●●●
Forum|alt.badge.img+41
  • ArunDubey
  • QPN Level 8 ●●●●●●●●
  • June 30, 2023

I’m not sure if I’m getting you correctly. If you are looking to see multi select question data as 0,1 in separate column so you can check below settings. But you cannot get the scores as 4 for four selections.

 

Best thing about score is: If you forgot to add in a scoring category before sending out your survey, don’t worry! Scoring is retroactive for surveys and will be applied to all previously collected responses, as well as future responses. However, scoring is not retroactive for dashboards.

~ Arun Kumar Dubey
O
TomG
Level 8 ●●●●●●●●
Forum|alt.badge.img+27
  • TomG
  • Level 8 ●●●●●●●●
  • Answer
  • June 30, 2023

@IzzyS,

It isn’t clear to me if you’ve already fielded the survey.  If you haven’t, you can pipe the count of selected choices for a MC question into an embedded data field in the survey flow. It would be something like this:

Set Embedded Data: Q1count = ${q://QID1/SelectedChoicesCount}
Branch: IF Q1 Selected Choice Is Equal To I haven’t experienced any
    Set Embedded Data: Q1count = 0

If you’ve already fielded the survey, you can use a formula in Excel:

=IF(A1=0,0,LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1),",",""))+1)

I
Terms & ConditionsAccessibility statement