In Qualtrics, you can mark the seen but unanswered data as -99. Does that solve your problem/?
Alissa Swartz : That was the workaround that Qualtrics recommended as well, to deal with the fact that their Web Data Connector is incapable of putting nulls into the output. But there are three problems:
- The option to substitute non-responses with -99 is only available for file exports. There are no configuration options for the Web Data Connector.
- The alternative, then, is to use custom response codes to ensure that zero is never a valid (internal) data value. At that point, you can interpret it as a non-response. The problem is, this method only works for responses going forward. If you want to get an existing survey working with the WDC, this option won't help for historical responses.
- -99, and even zero, adversely affects any aggregations. So you pretty much have to create a calculated field for every single numeric response to convert the non-response value to null. It's doable, but it makes a huge mess of your data source. (Pivoting, as described in the Steve's blog article, mitigates this mess substantially — but that's only available for files, not WDC data sources.)
Susan Baier : It's important to understand that Qualtrics, at least, does know the difference between a "zero response" and a "non-response". The issue is simply that their Web Data Connector does not properly interact with the SDK to generate nulls where nulls are needed. We have asked them to deal with this bug, and presumably they have ticket open internally, but I have yet to get traceability or a commitment to fix the bug in a specific timeframe.
And with that, I'll stop resurrecting old threads.