Hello all! So I’m looking for a solution here – how do I get the survey respondents answers to my open ended questions to pull into the data export in an already compiled chart? I need all the people who answered “A” to pull into the chart (and hopefully it will tell me how many people answered “A”), all the people who answered “B” to pull under that, then “C”, “D”, etc etc etc.
Is this possible?
I am not sure I understand what your situation is. Could you answer a few questions?
Has the survey already been taken by the respondents?
At the time you want your chart(s), will the data gathering be over, or will data gathering be ongoing with a need for on the fly updates to your charts?
When you say open ended questions, do you mean a text box question type?
Are the expected answers really as simple as “A”, “B”, “C”, etc. ?
I don’t understand what you mean by, “pull into the data export in an already compiled chart”. Are you talking about a Gizmo standard report, or some other program that will display this compiled chart?
When you say chart, do you mean tabular data or a something like a pie chart or bar chart?
I ask these questions because what you want to do may or may not be possible depending on these details. Even if not possible, there may be ways to achieve something similar and just as useful to you, but the options depend a lot on the specifics of your situation.
Gizmo’s open text analysis is a great tool, but will require you (or another administrator) to manually code the responses into buckets. Once that is done, you should be in great shape.
If you had just wanted a table of the answers with exact matches grouped and counted together, a Gizmo standard report can do that without the text analysis requirement of manual coding. That would not work well though for feeding data into a pie chart.
If the answers had been simpler, you might have been able to do the coding automatically using a custom script.
I assume you are reading this page:
I really do think that will be the best way to go for your situation.