Responses are being split into two in report


For many of the questions, when creating a report one of the possible responses is being shown twice in the results, with the responses split between the two.  This response is only listed once in the questionnaire and these are tick box type answers.  I have tried re-running the reports but the same thing happens every time and I can not figure out why.  Here is an example:

Question: Level of education

Answers to choose from:

none, primary, secondary, university


In the report of the results, the tallies show as follows:

none, primary, secondary, university, none


This is happening with a lot of questions which is creating a lot of work for me because I have to now manually combine the responses in excel to get the correct results and graphs.


Would appreciate some advice as to why this might be happening and how to fix.



Lola Gill answered
    • ETA: I have now realized that in addition to showing an answer twice, the total number of responses is more than the N being shown and more than the total number of surveys.

    Lola Gill 6.97K Rep.

    It’s a bit difficult to say without having access to your account/report. In general something like this would point to edits being made to answer options during data collection (just my hypothesis).

    If that were the case, and if it is something that you do periodically – I would recommend reviewing this document for best practices:

    Hope this is helpful for the future!

    Lola Gill answered


      Question stats

      • Active
      • Views606 times
      • Answers1 answer
      • Followers1 follower