Cleaning Up a Report for Scheduling | XM Community
Skip to main content

Greetings XM Community,

I created a scheduling tool in Qualtrics and had a question on how to clean a report to make it more readable.  

I have quite a few, “I do not need this class” responses.  Is there a way to filter out that response inside Qualtrics and export a readable Excel file of needed classes or does it have to be edited directly in Excel?

I’ve tried it a couple of ways but I keep running in to the issue that these answers are all tied to a student, they have a force response on all questions, so I think at best all I can pull is a blank field.

Here’s a snip of the responses I’m trying to get rid of from one of my test responses:

FYI - There survey was already launched and closed

Thank you! 

 

Go into your survey editor and select the option “I do not need this class.” It will open a drop box with an option for “Exclude From Analysis.” I believe that should clean up that data even in the export to Excel . 

 

Did that do what you wanted? 

 

 

Thank you, I had seen this option and assumed that it was only available for the Likert scale questions.  It might work, I would be curious to see what the report would look like with adding this logic.  

The only other roadblock is that I need the full report available with the “I do not need this class” responses for some (myself and the program director) and the cleaned up version excluding that response for others (the AA that is doing the actual scheduling) which makes me wonder if it lends itself more toward an Excel fix vs. Qualtrics?  

Terms & Conditions