- Posts: 12
- Thank you received: 2
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Can LimeSurvey help me in making a person focussed spreadsheet?
- dosch
- Topic Author
- Offline
- New Member
Less
More
6 years 1 month ago - 6 years 1 month ago #164946
by dosch
Can LimeSurvey help me in making a person focussed spreadsheet? was created by dosch
Hey all,
I need to map the processes in my company on an individual basis and I thought that it would be easiest to send employees a survey to ask them about their work, processes and other stuff. With this I hope to gain a unified register that maps all processes in a unified manner.
To make it clear, the current export feature aggregates all answers and this is not useful for me. I don't need to know that 68% answered 'yes' to some question. But I need to see exactly who answered 'Yes' and who answered 'No' in the export.
So the spreadsheet would have a breakdown per person who completed the survey, not a breakdown on the questions asked.
Something like:
I hope this is clear and thnx for your answers!
I need to map the processes in my company on an individual basis and I thought that it would be easiest to send employees a survey to ask them about their work, processes and other stuff. With this I hope to gain a unified register that maps all processes in a unified manner.
To make it clear, the current export feature aggregates all answers and this is not useful for me. I don't need to know that 68% answered 'yes' to some question. But I need to see exactly who answered 'Yes' and who answered 'No' in the export.
So the spreadsheet would have a breakdown per person who completed the survey, not a breakdown on the questions asked.
Something like:
Name | Do you like fruit? | What is your favorite dish? | How often do you think about food? |
Bas | Yes | Curry fruit rice | Less then 1 minute a day |
Eva | No | Chocolate | Between 1 hour and 2 hours a day |
Kevin | Other ... only mangos | Mango Lassy | The whole day |
I hope this is clear and thnx for your answers!
Last edit: 6 years 1 month ago by dosch. Reason: clearifying my question
The topic has been locked.
- Deusdeorum
- Offline
- Senior Member
Less
More
- Posts: 72
- Thank you received: 17
6 years 1 month ago #164949
by Deusdeorum
What 'current export feature' are you using? Limesurvey does indeed allow you to export on a individual level. Go to Responses and statistics > Export results > Choose excel and export. Or am I misunderstanding you somewhere?
Replied by Deusdeorum on topic Can LimeSurvey help me in making a person focussed spreadsheet?
dosch wrote: To make it clear, the current export feature aggregates all answers and this is not useful for me.
What 'current export feature' are you using? Limesurvey does indeed allow you to export on a individual level. Go to Responses and statistics > Export results > Choose excel and export. Or am I misunderstanding you somewhere?
The following user(s) said Thank You: dosch
The topic has been locked.
- Joffm
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 12880
- Thank you received: 3964
6 years 1 month ago #164950
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Replied by Joffm on topic Can LimeSurvey help me in making a person focussed spreadsheet?
Hi, if you export to EXCEL (in "Show answers"), you will get the following.
Of course, best with single punch questions.
Remeber: LS is a data collecting tool, not a analysing tool.
In your case I always recommend to write your own small php script to delect the desired data and create a spreadsheet to display them.
Best regards
Joffm
Of course, best with single punch questions.
Remeber: LS is a data collecting tool, not a analysing tool.
In your case I always recommend to write your own small php script to delect the desired data and create a spreadsheet to display them.
Best regards
Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Attachments:
The topic has been locked.
- dosch
- Topic Author
- Offline
- New Member
Less
More
- Posts: 12
- Thank you received: 2
6 years 1 month ago #164951
by dosch
Replied by dosch on topic Can LimeSurvey help me in making a person focussed spreadsheet?
hey Deusdeorum, I now use 'statistics -> view statistics' this allow me to save survey results as .xls file.
But in that file all answers are in the left column and next to that the percentages of how many people chose an answer. I can't see anymore *who* gave what answer.
So to use my example above, I currently get:
etc...
But in that file all answers are in the left column and next to that the percentages of how many people chose an answer. I can't see anymore *who* gave what answer.
So to use my example above, I currently get:
Answer | Count | percentage |
Yes | 1 | 33% |
No | 1 | 33% |
Other... | 1 | 33% |
etc...
The topic has been locked.
- Deusdeorum
- Offline
- Senior Member
Less
More
- Posts: 72
- Thank you received: 17
6 years 1 month ago #164952
by Deusdeorum
Replied by Deusdeorum on topic Can LimeSurvey help me in making a person focussed spreadsheet?
The statistics view is just what is says it is, statistics Use the "Export results" feature instead and you will get your desired output.
The following user(s) said Thank You: dosch
The topic has been locked.
- dosch
- Topic Author
- Offline
- New Member
Less
More
- Posts: 12
- Thank you received: 2
6 years 1 month ago #164975
by dosch
Replied by dosch on topic Can LimeSurvey help me in making a person focussed spreadsheet?
That was it. I guess that LS has so many features I just need time to find them all.
Thank you for your fast answer and this perfect welcome to the forum
Thank you for your fast answer and this perfect welcome to the forum
The topic has been locked.