Welcome to the LimeSurvey Community Forum

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

Can I track groups of question responses using Relevance Equation?

  • teracomp
  • teracomp's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
7 years 5 months ago #142513 by teracomp
I'm working on a survey with 90 questions, all with simple 5-point Likert responses.
There are 6 buckets for which these 90 questions contribute. For example Q001 is part of bucket 2, Q002 is part of bucket 4 and 6, so that in the end the responses will result in some number in each bucket. The report I'm preparing shows the respondent a rank ordering of the buckets.
As I'm building the survey, it seems prudent to add this information with each question to streamline reporting at the end.
It's also possible that I could branch into another set of questions if a bucket reaches some critical point, e.g., Bucket #3 total == 50.

It seems like this is a Relevance Equation function, but I'm unable to determine how to do this with the examples I've seen.

My guess is I would establish the buckets so {BUCKET1+=Q1.value} or some such syntax in the relevance equation input for the question.

Is it possible to track groups of question responses using a relevance equation?

Should I just manage all of this in the post survey processing?

I'm probably not asking the right question, but I hope the explanation provides enough info to point me in the right direction. Most, if not all of my surveys, require this kind of logic.

Dave Phillips
The topic has been locked.
  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
7 years 5 months ago #142515 by Joffm
Well, terracopm,
I did not understand ypour approach well, I always need examples.

But the point to calculate your bucket total:

Just add a question (type equation) "SumBucket1" in which you sum up the results of bucket 1.
E.g.
sum(Q1.NAOK,Q2.NAOK...)
Then you can use relevance "SumBucket1<50", or so to branch into other sets

Best regards
Joffm

Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.
  • teracomp
  • teracomp's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
7 years 5 months ago #142517 by teracomp
I don't think this is a new concept, but in the past I've written this logic in custom code. I'm trying to use Lime Surveys instead of custom code for each survey.

Here's the general concept:
There are generally 12 questions per group and anywhere from 5 to 15 groups per survey. At the end of each group, I need to decide which group is next based on the current group's bucket counts.

Group 1: Q001 - Q012
Group 1 refinement: Either Group 2, 3 or 4 depending on bucket totals:
  • If Bucket1 is highest, goto group 2 questions.
  • If Bucket3 is highest, goto group 3 questions.
  • If Bucket5 is highest, goto group 4 questions.
Following Group 2, 3 or 4, proceed to Group 5


Detailed example using a Likert-5 scale:
Q001 Have you considered ...
Bucket loading for each answer: A1:Bucket1, A2:Bucket1, A3:Bucket3, A4:Bucket5, A5:Bucket5
Weight: 1
Q002 Given this scenario...
Bucket loading for each answer: A1:Bucket5, A2:Bucket3, A3:Bucket3, A4:Bucket1, A5:Bucket1

re: "Just add a question (type equation)..."
First of all, I didn't know there was an Equation Type of question, so my inexperience is showing.
In looking at it in detail, I assume I put the sum(Q1.NAOK, Q2.NAOK...) in the Equation textbox.

Since I'm adding buckets per answer, should I do the following:
Add Equation Type Question named SumBucket1
-- Set "Always Hide this question" to On
-- Enter equation: sum(Q1A1.NAOK,Q1A2.NAOK,Q2A5,...)

Add another Equation Type Question named SumBucket3 with sum(Q1A3.NAOK,Q2A2.NAOK,Q2A3.NAOK..)
And another Equation Type Question named SumBucket5 with sum(Q1A4.NAOK,Q1A5.NAOK,Q2A1.NAOK...)

If that's even close, how do I display the appropriate group questions next?

Dave Phillips
The topic has been locked.
  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
7 years 5 months ago #142518 by Joffm
Hi, teracomp,

Q001 Have you considered ...
Bucket loading for each answer: A1:Bucket1, A2:Bucket1, A3:Bucket3, A4:Bucket5, A5:Bucket5
Weight: 1
Q002 Given this scenario...
Bucket loading for each answer: A1:Bucket5, A2:Bucket3, A3:Bucket3, A4:Bucket1, A5:Bucket1


So, if Q001 and Q002 are your question codes,
A1, A2,... are the answer codes:

Then you can create these "Equation" questions like
"Bucket1": {sum(if(Q001=="A1",1,0),if(Q001=="A2",1,0),if(Q002=="A4",1,0),if(Q002=="A5",1,0))} etc.
"Bucket3": {sum(if(Q001=="A3",1,0),if(Q002=="A2",1,0),if(Q002=="A3",1,0))}

Well, you see the way?
E.g. you can change the weight changing the summed value like "if(Q002=="A4",999,0)"

So you get the value of your buckets and can decide what to do next.

Best regards
Joffm

Volunteers are not paid.
Not because they are worthless, but because they are priceless
The following user(s) said Thank You: teracomp
The topic has been locked.
  • teracomp
  • teracomp's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
7 years 5 months ago #142526 by teracomp
I still have a lot to learn. Thanks for your input!

Dave Phillips
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose