Filter data to display only results of partial surveys

Question

I did not use reCAPCHTA, but the “next” button on a survey can essentially work the same. I want to pull and export data for partial responses who submit completed at least 2 survey questions - being that I have an NPS question and then you’re required to click the next button to the next page, so if they have at least 2 questions filled out I’m going to assume it wasn’t a bot taking it. I’m not sure though how to set it up. My survey has several different branches all with display logic and hundreds of questions so it is not necessarily feasible to use a “is not empty” filter on each of the questions.

Jona · Accepted Answer

On the “Data & Analysis” tab, click “Add Filter” and then you can create a filter for partial completion, like this:Once you’ve created the filter, click the dropdown arrow next to “Add Filter” and click the name of the filter you’ve just created. It will now show you only the survey responses which are partial. If you export the data with the filter applied, it will only download those responses which meet the filter, so you’ll get a file with only your partial completion responses.Note: you might want to add additional conditions to your filter, so it’s not truly *every* partial response, maybe you also want them to have answered the specific NPS question, so you can add that as an additional condition to the filter.

Dukester · Answer

This may not be idea but is a workaround we’ve used that requires a bit of manual, but easy, effort.When you click export from a survey’s data & analysis tab, click on, “More Options” at the bottom.We then check “Recode seen but unanswered questions at -99”When we export to Excel, we filter based on that field. When the specific number of responses is important, you can use an Excel formula to either count the -99 in each row or count the cells that are not -99 in each row.Hope this helps!

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded