Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Exclude or filter out participants who answer "Don´t Know' to most questions

  • gabriela.garcia
  • gabriela.garcia's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
2 years 6 months ago #230507 by gabriela.garcia
Please help us help you and fill where relevant:
Your LimeSurvey version: [see right hand bottom of your LimeSurvey admin screen]
Own server or LimeSurvey hosting:
Survey theme/template:
==================
Hello!

We were asked to refine the quality of our responses by avoiding respondents that go through the entire questionnaire marking the "Don't know" option to all or almost all questions.
Our first guess was to make an equation question with a code that would sum up these answers (the code to "dont know" is '88' and our number of questions is 40). But I am not sure how to write this code and whether this is the best path.

How can we filter out these participants? Could we place these as a quota?

Thank you very much!

Please Log in to join the conversation.

  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 6 months ago #230511 by Joffm
Of course you have to count them.
But unfortunately you neither answered the questions at the beginning nor you mentioned the question type of these questions.

So it is difficult to help.

But generally:
Single punch questions: {countif("99",Q1.NAOK,Q2.NAOK,...)}
Questions with subquestions, like arrays: {countif("99",that.Q1.NAOK,that.Q2.NAOK,...)}

And of course you can screen out participants who answered "DK" too often.
So please, answer these questions and send a lss export of your survey (or a prototype of your survey).

Then we will proceed.

Joffm

 

Volunteers are not paid.
Not because they are worthless, but because they are priceless

Please Log in to join the conversation.

  • gabriela.garcia
  • gabriela.garcia's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
2 years 6 months ago #230516 by gabriela.garcia
Thank your reply, Joff! And sorry, my bad:
1. Your LimeSurvey version: LimeSurvey Community EditionVersion 5.3.6 220321
2. We have list (radio), array and multiple choice questions to be considered.

Also, one of our questionnaries to be fixed in this regard is already active, so we can no longer add an equation question to sum up. In this particular case, is it still possible to filter out only through quota?  

 

File Attachment:

File Name: limesurvey...5598.lss
File Size:67 KB

Please Log in to join the conversation.

  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 6 months ago #230517 by Joffm
Hi,
sorry,
I do not see any "99" in this survey. Were you confused and it is "88"?
Which questions do you want to take into account?

Furthermore:
1. The answer options of M2 are missing.
(By the way: Do all students of TUE use this same design of the question. Ask your fellow students.)

2. The hidden multiple question is not set by an equation.

3. The subquestions of "ratings" refer to a question "products" which is missing.

4. What is your idea of question "Ratings"?
You have a code "88" in the second scale. What for?
You know, once clicked "Don't know" in the second scale, you never can remove it.
At least you should have a second scale with "Yes", "No" , "DK".
And then you may set it to "mandatory".

Please, revise and send a working example.

But to count these "DKs". I take the code "88" of Ratings into account.
{sum(M2_SQ001_88.NAOK,countif("88",Q2.NAOK,that.Ratings.sq_1))}

Joffm

Volunteers are not paid.
Not because they are worthless, but because they are priceless
The following user(s) said Thank You: gabriela.garcia

Please Log in to join the conversation.

  • gabriela.garcia
  • gabriela.garcia's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
2 years 6 months ago #230518 by gabriela.garcia
Thanks a lot, Joff!

I had to quickly send you a model survey, just to try to illustrate the sort of questions we had in our real one.

This code as you sent it is already enough to solve our doubts on our first case! We will rewrite it including all questions that come with a DK answer option.

Now, for the second one, the survey that is already active (and also contains different question types), can we still filter them out through quotas or other tool?

Please Log in to join the conversation.

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 6 months ago #230538 by holch

I do not see any "99" in this survey. Were you confused and it is "88"?


No Joffm, you were confused. She mentioned the 88 from the beginning. You came up with the 99. ;-)

Our first guess was to make an equation question with a code that would sum up these answers (the code to "dont know" is '88' and our number of questions is 40).


Getting old, he?
;-)

Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.

Please Log in to join the conversation.

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 6 months ago #230539 by holch

Now, for the second one, the survey that is already active (and also contains different question types), can we still filter them out through quotas or other tool?


If you can't add any equation question anymore, because the survey is active, then I don't see how to do this from within the survey. Either you deactivate (save the responses so far as a backup), then add the questions, then reactivate and import the previous response table when activating. But you can't really exclude anyone that has already completed the survey. You will have to do so afterwards.

But what is the point of filtering them out if they need to go through the survey anyway as you coun't the don't knows? I mean if you screen someone out almost at the end of a survey, you could always just let them make it to the end and then exclude those from the results later, before analyzing. I think quotas and screenouts only make sense for the first couple of questions (must admit, I didn't look at your LSS, also because it doesn't seem to be working properly anyway).

Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.

Please Log in to join the conversation.

  • gabriela.garcia
  • gabriela.garcia's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
2 years 6 months ago #230541 by gabriela.garcia
Hahaha well noticed, Holch!

Please Log in to join the conversation.

  • gabriela.garcia
  • gabriela.garcia's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
2 years 6 months ago #230542 by gabriela.garcia
Indeed the lss model was quite bad. I will send a less messy one next time (it is the least we, the ones begging for help, can do, right?!)

Anyway, thanks a lot for your time as always, both of you, Holch and Joffm!

Please Log in to join the conversation.

  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 6 months ago #230543 by Joffm

She mentioned the 88 from the beginning. You came up with the 99.

Really?
Yes, I know, my glasses get worse and worse.

Getting old, he?

Better: Being old

Volunteers are not paid.
Not because they are worthless, but because they are priceless

Please Log in to join the conversation.

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 6 months ago - 2 years 6 months ago #230544 by holch

Better: Being old

I know, I know. Wanted to be at least a little bit polite within my cheekyness. 

Have a great weekend back there, enjoy the summer. I hope it is not too hot.

Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.
Last edit: 2 years 6 months ago by holch.

Please Log in to join the conversation.

Moderators: tpartnerholch

Lime-years ahead

Online-surveys for every purse and purpose