How do I avoid returning zero in my data when a respondent skips a question | XM Community
Solved

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

  • 24 October 2018
  • 3 replies
  • 156 views
T
Userlevel 1
Badge +2
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
icon

Best answer by TomG 24 October 2018, 23:11

View original

3 replies

A
Hello @TCA ,

Assuming by null you mean blank

Store 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 dashboard

Image:
!
TomG
Rank
Userlevel 7
Badge +27
@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.
T
Userlevel 1
Badge +2
perfect, that makes complete sense. I've tried and it works - thanks @TomG and @Shashi

Leave a Reply


Terms & Conditions