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
  • Rita2019's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 2 weeks ago - 4 years 2 weeks ago #196378 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
Last edit: 4 years 2 weeks ago by Rita2019. Reason: found a new link to add, that made my quest for help clearer
The topic has been locked.
  • Rita2019
  • Rita2019's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 2 weeks ago #196380 by Rita2019
I also don't have a survey participants table... Don't know whether that was needed...
The topic has been locked.
  • Joffm
  • Joffm's Avatar
  • Away
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
4 years 2 weeks ago #196381 by Joffm
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

Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.
  • Rita2019
  • Rita2019's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 2 weeks ago #196383 by Rita2019
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
The topic has been locked.
  • Joffm
  • Joffm's Avatar
  • Away
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
4 years 2 weeks ago #196385 by Joffm
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

Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.
  • Rita2019
  • Rita2019's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 2 weeks ago #196394 by Rita2019
Dear Joffm,
Thank you so much for your prompt reply and all the help through this!
Many thanks :)
Kind regards,
Rita
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose