Help!! How do I get answers to my open ended questions to pull into the data export in a nice, neat chart?

0

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?

Many thanks,

Matt

IS answered
    0
    IS 2.20K Rep.

    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:

    https://help.surveygizmo.com/help/open-text-analysis

    I really do think that will be the best way to go for your situation.

     

    IS answered
      0
      IS 2.20K Rep.

      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.

       

      Matt commented
        • Hello, and thanks so much for your response! My answers are below..

          Has the survey already been taken by the respondents? Yes

          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? Data gathering will be over

          When you say open ended questions, do you mean a text box question type? Yes, a text box or short answer question type

          Are the expected answers really as simple as “A”, “B”, “C”, etc. ? No – I was just using that in my question. The question will be similar to “If you selected other, please explain your response”…but most people will respond with a 1 or 2 word answer which will create a decent amount of duplicates

          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? So when I export the data into Excel, I then make it pretty and send to clients in a PPT. I was wondering if there’s a way for SG to pull the open ended answers and automatically put them into a chart of some sort. I count up the answers and say “52 people said A”, “36 people said B”, etc etc. I’m hoping there’s a function within the export tool of SG that will do this piece for me..

          When you say chart, do you mean tabular data or a something like a pie chart or bar chart? Some sort of pie chart or bar chart

          Again, thanks for taking time out of your busy day to help me with this. I’m reading about Open Text Analysis right now and am hoping this is it.

        ×

        Login

        Question stats

        • Active
        • Views1289 times
        • Answers2 answers
        • Followers1 follower