How to eliminate "N/A" from a report? — Qualtrics Community
June 23, 2021: We have released an update to the theme of our Community site today. You can read more details about the changes and improvements introduced in this release in our New Updates to the Community Theme Released post. Please leave your feedback through this Community Redesign Feedback Survey.

How to eliminate "N/A" from a report?

Mindy
Mindy Portland, Oregon, USACommunity Member, Qualtrics Brand Admin Qubie ✭
edited June 23 in Survey Platform

For text entry questions and multiple-choice questions that include an "other" option, the report is adding "N/A" if a respondent leaves the field blank.

For example, I have a multiple-choice question that includes "Other (please specify)" as a response option with a text entry box. Even though the vast majority of the 300 respondents did not choose this "Other" response, the report includes several rows of "N/A". The same is happening to text entry questions where the field is left blank; the report still includes "N/A" row.

As such, my report is 77 pages long and two-thirds of those pages are majority "N/A" responses.

How do I filter these out?

AND how do I ensure this doesn't happen again during my next survey? Is it something I could've prevented in the survey setup?

Best Answer

  • MatthewM
    MatthewM Chicago, ILCommunity Member, Qualtrics Brand Admin Superuser ✭✭✭✭
    Accepted Answer

    Hi @Mindy ,

    I assume that you're working in the newer Report feature in Qualtrics, not Results.

    If that's correct, you can filter results within an individual question. See the two screen shots below. This would allow you to filter out all of the N/A responses from the report display.

    Hope this helps.

Answers

  • Guide
    Guide MichiganCommunity Member Qubie ✭

    Hi Matthew:

    Your solution above worked great for questions where there are no responses. The additional issue I am having is where there is only one or two responses but there are N/As below that. For example:

    Response

    Response

    N/A

    N/A

    N/A

    Is there a way to get rid of the N/As? Thanks for your help!

    Paul

  • MatthewM
    MatthewM Chicago, ILCommunity Member, Qualtrics Brand Admin Superuser ✭✭✭✭

    Hi @Guide ,

    I believe that Advanced reports represent empty with "N/A". So if you apply a filter like that shown above it should hide the N/A's from the list.

    Alternatively, a quick and dirty way to hide the N/A's is to use the "Sort by" option to make N/A appear last, and adjust the number of rows displayed so it shows everything but the N/A's.


  • AdamK12
    AdamK12 Bethesda, MDCommunity Member, XMPN Member, XMPN Champion, Qualtrics Brand Admin Sage ✭✭✭

    Hi, @Guide , @Mindy and @MatthewM -- these are all great ideas for working in the Reports function--I'll try using the filters the next time I'm using the Reports function.

    Another option is to export the report into Word, where you can sort and edit out the "N/A" responses. This is what I do for our leadership, because they do not have Qualtrics accounts. It works well because they have access to the verbatim responses in a familiar file format...

  • Guide
    Guide MichiganCommunity Member Qubie ✭

    Thanks Adam and Matt for your help with this.

  • Guide
    Guide MichiganCommunity Member Qubie ✭

    BTW, tried the filter option and it worked perfectly!

Sign In to Comment

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!