How do I avoid returning zero in my data when a respondent skips a question

Question

Hi, I'm very much still learning how to use Qualtrics, and cannot find a solution to this problem.

I use maths operations in embedded data in survey flow to calculate percentages from data provided in a respondent's survey. That gives me dynamic data for each respondent that I can average across all respondents and report in a dashboard widget (I'll share some widgets with respondents). However, the maths operations return a zero value when a respondent has skipped that question.  For example, if I have 20 respondents, but 10 skip the question, my maths operations is returning 0 for those ten when they should be null. This in turn skews the average when I report in a widget.

This must be a very common problem. Maths ops don't permit if statement as far as I can see - what am I missing? I hope someone can help - thanks

TomG · Accepted Answer

@TCA - you can put the math operation inside a branch and only execute it if the question wasn't skipped.You haven't told use about the skipped question, so I can't provide any insight on what the branch condition would look like.

Anonymous · Answer

Hello @TCA ,Assuming by null you mean blankStore  the math operation result in an embedded data(m) Apply two branch logic on the m i.e (1) if m=0 then just declare new embedded data(m1) without setting any value(2) if m is not equal to 0 then set same new embedded data(m1) with value of math operation result embedded data(m) Now use this new embedded data(m1)  for dashboardImage:!

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded