- Posts: 14
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Can I get a % of replied answers/missing values when exporting responses?
- Rita2019
- Topic Author
- Offline
- New Member
Less
More
4 years 3 weeks ago - 4 years 3 weeks ago #196378
by Rita2019
Can I get a % of replied answers/missing values when exporting responses? was created by Rita2019
Dear Community,
I would like to know if there's a way to know the response rate per questionnaire.
I need to validate answers, and it would help to know how many questions each participant replied.
I also found this:
bugs.limesurvey.org/view.php?id=12622
I think it is what I was looking for, but I don't know how to do it.
Can someone help me out?
Also, those percentages refer to the answers that participants should have replied (excluding the filter questions) or do those percentages refer to all the answers that participants didn't reply? (including filter questions)
Off course I would like to see the response rate of each participant excluding the filter questions, that is to say, I would like to see in % "no answer" and not "N/A" answers
I should add that there were no mandatory questions, and that the survey was designed anonymous, so no token.
I thank you in advance
I would like to know if there's a way to know the response rate per questionnaire.
I need to validate answers, and it would help to know how many questions each participant replied.
I also found this:
bugs.limesurvey.org/view.php?id=12622
I think it is what I was looking for, but I don't know how to do it.
Can someone help me out?
Also, those percentages refer to the answers that participants should have replied (excluding the filter questions) or do those percentages refer to all the answers that participants didn't reply? (including filter questions)
Off course I would like to see the response rate of each participant excluding the filter questions, that is to say, I would like to see in % "no answer" and not "N/A" answers
I should add that there were no mandatory questions, and that the survey was designed anonymous, so no token.
I thank you in advance
Last edit: 4 years 3 weeks ago by Rita2019. Reason: found a new link to add, that made my quest for help clearer
The topic has been locked.
- Rita2019
- Topic Author
- Offline
- New Member
Less
More
- Posts: 14
- Thank you received: 0
4 years 3 weeks ago #196380
by Rita2019
Replied by Rita2019 on topic Can I get a % of replied answers/missing values when exporting responses?
I also don't have a survey participants table... Don't know whether that was needed...
The topic has been locked.
- Joffm
- Online
- LimeSurvey Community Team
Less
More
- Posts: 12923
- Thank you received: 3977
4 years 3 weeks ago #196381
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Replied by Joffm on topic Can I get a % of replied answers/missing values when exporting responses?
Hi,
as far as I understand you want to know how many of the - not mandatory - question were answered.
The feature request you linked to was something to provide the response rate of questionnaires in total
Like: I invited 500 persons, 200 answered -> 40%
I think you have to count the "no answer" answers - which is not so difficult, if you have a specific code for that.
To be able to distinguish between you should use a specific code for "I do not want to answer this question" instead of showing the default "no answer" option (both show "empty" in the answer table, what I think you saw already) and make it mandatory.
Then you can do something like
{countifop("==","[yourCode]",Q1.NAOK,Q2.NAOK,that.Q3.NAOK,...)} for single punch and array
{countifop("==","Y",M1_SQ099,M2_SQ099,M3_SQ099,...)} for multiple
and other countings by ExpressionScript.
But I do not think this should be done in LimeSurvey.
This can be calculated more easily in your statistic software, let it be SPSS or EXCEL or R or whatever.
Because there is nothing else to do than to create an example, you should provide your survey as lss export, and I will try to show you something.
Joffm
as far as I understand you want to know how many of the - not mandatory - question were answered.
The feature request you linked to was something to provide the response rate of questionnaires in total
Like: I invited 500 persons, 200 answered -> 40%
I think you have to count the "no answer" answers - which is not so difficult, if you have a specific code for that.
To be able to distinguish between you should use a specific code for "I do not want to answer this question" instead of showing the default "no answer" option (both show "empty" in the answer table, what I think you saw already) and make it mandatory.
Then you can do something like
{countifop("==","[yourCode]",Q1.NAOK,Q2.NAOK,that.Q3.NAOK,...)} for single punch and array
{countifop("==","Y",M1_SQ099,M2_SQ099,M3_SQ099,...)} for multiple
and other countings by ExpressionScript.
But I do not think this should be done in LimeSurvey.
This can be calculated more easily in your statistic software, let it be SPSS or EXCEL or R or whatever.
Because there is nothing else to do than to create an example, you should provide your survey as lss export, and I will try to show you something.
Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.
- Rita2019
- Topic Author
- Offline
- New Member
Less
More
- Posts: 14
- Thank you received: 0
4 years 3 weeks ago #196383
by Rita2019
Replied by Rita2019 on topic Can I get a % of replied answers/missing values when exporting responses?
Thank you much Joffm!
You understood exactly what I as asking.
If it has to be done in Excel or Spss, than it is fine, I think I can do it.
But I wonder, for the next time: Limesurvey would do this - the response rate for each participant - if I had used tokens and/or a participant survey table? Is this doable in LimeSurvey by any chance?
I thank you in advance
You understood exactly what I as asking.
If it has to be done in Excel or Spss, than it is fine, I think I can do it.
But I wonder, for the next time: Limesurvey would do this - the response rate for each participant - if I had used tokens and/or a participant survey table? Is this doable in LimeSurvey by any chance?
I thank you in advance
The topic has been locked.
- Joffm
- Online
- LimeSurvey Community Team
Less
More
- Posts: 12923
- Thank you received: 3977
4 years 3 weeks ago #196385
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Replied by Joffm on topic Can I get a % of replied answers/missing values when exporting responses?
Hi,
I told you how it can be done in LS.
At the moment LS doesn't distiguish between not answered question because of relevance equations or because the respondent didn't answer.
So it's up to you to mark questions that are not answered by the respondent. (E.g. by setting them to mandatory - by the way everything else is nonsense - and add (a) specific answer option(s) "DK/NA")
It's really easy to achieve. Though you might have a long equation to calculate this.
We once used something like that to screen out respondents who answered "NA" for more than 85% of the previous questions.
Joffm
I told you how it can be done in LS.
At the moment LS doesn't distiguish between not answered question because of relevance equations or because the respondent didn't answer.
So it's up to you to mark questions that are not answered by the respondent. (E.g. by setting them to mandatory - by the way everything else is nonsense - and add (a) specific answer option(s) "DK/NA")
It's really easy to achieve. Though you might have a long equation to calculate this.
We once used something like that to screen out respondents who answered "NA" for more than 85% of the previous questions.
Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.
- Rita2019
- Topic Author
- Offline
- New Member
Less
More
- Posts: 14
- Thank you received: 0
4 years 3 weeks ago #196394
by Rita2019
Replied by Rita2019 on topic Can I get a % of replied answers/missing values when exporting responses?
Dear Joffm,
Thank you so much for your prompt reply and all the help through this!
Many thanks
Kind regards,
Rita
Thank you so much for your prompt reply and all the help through this!
Many thanks
Kind regards,
Rita
The topic has been locked.