Zero Filling | XM Community
Skip to main content

Zero Filling

  • November 15, 2017
  • 4 replies
  • 206 views

RachelTHREE
Level 2 ●●
Forum|alt.badge.img+2
Hey All - I know zero filling (0's showing up in data when they should be missing data, as well as 0's not showing up when they should be) is an issue that Qualtrics is actively working on solving. In the meantime, do you have best practices/tips/tricks for adjusting the data on the back end?

4 replies

Forum|alt.badge.img+1
  • November 16, 2017
Agree-- Qualtrics does appear to have this issue on their agenda, but in the meantime, we've been advised to use the Legacy Data Export option. When you click "Export Data" select "Use Legacy Exporter" and select your preferred file type. Also, be sure to check "Recode seen but unanswered questions as '0'". You can also code this whatever number that works best, especially if you already have answers coded as zeros. This export option solves for zero-filling with multi-select questions, but we're noticed it's not a cure-all-- especially when you have display logic on statements. I would suggest working closely with your analytics department to make sure things are populating correctly. I will say the pitfall I've noticed with using the legacy data export is your applied filters do not hold. In my experience it's the entire dataset or nothing.

RachelTHREE
Level 2 ●●
Forum|alt.badge.img+2
  • Author
  • Level 2 ●●
  • November 30, 2017
@AnthonyR @JenF @lillianc Have you found a solve for this yet? Curious to know how you handle if you've experienced in the past.

AnthonyR
Level 4 ●●●●
Forum|alt.badge.img+7
  • Level 4 ●●●●
  • November 30, 2017
@RachelTHREE We are still using the legacy export, but if I were to need the newer output for headers, I would use the legacy and the new and merge them outside of the system. We handle a lot of data cleanup outside of Qualtrics, using a data mapping process, prior to loading it into our database for use in reporting.

RachelTHREE
Level 2 ●●
Forum|alt.badge.img+2
  • Author
  • Level 2 ●●
  • December 1, 2017
Thanks @AnthonyR — good to know that we're not missing anything here as of yet!