- Posts: 11
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
I need help reporting on a survey with large numbers of answers in an array
- wstone
- Topic Author
- Offline
- New Member
Less
More
4 years 1 month ago #194175
by wstone
I need help reporting on a survey with large numbers of answers in an array was created by wstone
I've made a survey to nominate students in a school election. It consists of 6 arrays containing a total of 3100 names. I'm having trouble with the reporting. Since large numbers of students receive no votes I need a way to filter them out of the final results. Does anyone have any ideas as to how I can do this?
The topic has been locked.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11757
- Thank you received: 2753
4 years 1 month ago #194180
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic I need help reporting on a survey with large numbers of answers in an array
Are you referring to the online reporting? Because usually this is not for analysis, but just a first glance. You should do the real reporting in a different software that is made for this. LS is rather a data collection than a data analysis tool.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The topic has been locked.
- wstone
- Topic Author
- Offline
- New Member
Less
More
- Posts: 11
- Thank you received: 0
4 years 1 month ago - 4 years 1 month ago #194184
by wstone
Replied by wstone on topic I need help reporting on a survey with large numbers of answers in an array
I've tried exporting the answers out to excel but its not showing any of the selections from the array. Any idea why that might be?
Last edit: 4 years 1 month ago by wstone.
The topic has been locked.
- Joffm
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 12788
- Thank you received: 3940
4 years 1 month ago #194189
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Replied by Joffm on topic I need help reporting on a survey with large numbers of answers in an array
No, no idea without seeing the structure of your survey.
What kind of array?
Subquestions, answer options.
Can't be a "normal" array with names as subquestions. That would exceed the MySQL column limit.
Joffm
Are your answers shown in the answer table?
Did you try to export to other formats, like *.csv or SPSS?
The SPSS *.dat file is a text file you can explore with a simple text editor.
What kind of array?
Subquestions, answer options.
Can't be a "normal" array with names as subquestions. That would exceed the MySQL column limit.
Joffm
Are your answers shown in the answer table?
Did you try to export to other formats, like *.csv or SPSS?
The SPSS *.dat file is a text file you can explore with a simple text editor.
Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.
- wstone
- Topic Author
- Offline
- New Member
Less
More
- Posts: 11
- Thank you received: 0
4 years 1 month ago #194190
by wstone
Replied by wstone on topic I need help reporting on a survey with large numbers of answers in an array
I've tried but without any luck. The answers total 3100 but on each question they vary from around 700 to 953. Any export I run shows no answers. I can see them under "statistics" but I lack any way to sort them. I'd be happy to send a copy of my survey if that would help.
The topic has been locked.
- Joffm
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 12788
- Thank you received: 3940
4 years 1 month ago #194195
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Replied by Joffm on topic I need help reporting on a survey with large numbers of answers in an array
Yes, of course, attach the lss export.I'd be happy to send a copy of my survey
Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.
- wstone
- Topic Author
- Offline
- New Member
Less
More
- Posts: 11
- Thank you received: 0
4 years 1 month ago #194196
by wstone
Replied by wstone on topic I need help reporting on a survey with large numbers of answers in an array
here you go
Attachments:
The topic has been locked.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11757
- Thank you received: 2753
4 years 1 month ago #194197
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic I need help reporting on a survey with large numbers of answers in an array
Hmmm, the export shows no answers? That sounds strange? What version of LS are you using and how are you trying to export the answers?
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The topic has been locked.
- wstone
- Topic Author
- Offline
- New Member
Less
More
- Posts: 11
- Thank you received: 0
4 years 1 month ago #194198
by wstone
Replied by wstone on topic I need help reporting on a survey with large numbers of answers in an array
Version 4.0.1+200120
The answers start at line 24740 apparently. I'm exporting by going to the survey and going to "Display/Export"
The answers start at line 24740 apparently. I'm exporting by going to the survey and going to "Display/Export"
The topic has been locked.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11757
- Thank you received: 2753
4 years 1 month ago #194199
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic I need help reporting on a survey with large numbers of answers in an array
I wasn't able to import your survey, got an error message.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The topic has been locked.
- wstone
- Topic Author
- Offline
- New Member
Less
More
- Posts: 11
- Thank you received: 0
4 years 1 month ago #194200
by wstone
Replied by wstone on topic I need help reporting on a survey with large numbers of answers in an array
try this
Attachments:
The topic has been locked.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11757
- Thank you received: 2753
4 years 1 month ago #194201
by holch
So now I am a little confused what we are talking about here.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic I need help reporting on a survey with large numbers of answers in an array
this exports the survey structure aka the questionnaire, but not the answers given by respondents. You need to go to "respondents" to export results to CSV, Excel or SPSS when you want to get the results of your survey.The answers start at line 24740 apparently. I'm exporting by going to the survey and going to "Display/Export"
So now I am a little confused what we are talking about here.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The topic has been locked.