Hello,
My initial goal is to save assessment score in the database within the result of the participants. I succeed in displaying assessment information in the end message as described in the manual
My current issue is to save the assessment score to be able to work on it for report or statistics.
Reading the forum, I use then the question type "equation" and expression in the equation value to save the result of assessment. It works for single question but not for multiple choice question where I trying to get the final assessment score.
Example : 2 questions G2Q1 (multiple choice) and G2Q2 (simple choice)
G2Q1 with assessment value of 3 for each subquestion marked
SQ1 marked
SQ2
SQ3 marked
I expect that {sum(G2Q1.value,G2Q2.value)} return 6 but it returns the text {sum(G2Q1.value,G2Q2.value)}
I expect that {sum(G2Q1_SQ001.value,G2Q1_SQ002.value,G2Q1_SQ003.value,G2Q2.value)} return 6 but it returns the value of G2Q2.value
First problem encountered: For the first group, your evaluation was put into the logic part, you need to put it into the question text of the equation question.
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.
Second group: Multichoice questions do not have a assessment value that could be specified. It alwasy returns Y or nothing. Should be 3 though I think. Might be a bug.
So in this case you will have to do a little workaround like this: You will need to check for each subquestion if it is "Y", if so apply 3 points, if not apply 0 points and sum them all up.
Another hint: Only hide your equation questions once you know the equations are working. Because when you display them, they can give you valuable information if what you are doing is having an effect or not.
I will see if I can write the example for one of the questions in the second group as an example for you.
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.
Unfortunately somehow G2Q1_SQ001.value doesn't give us the assessment value (3 if ticked), but rather it gives 'Y'. I will file a bug report, because this is weird.
Please find my solution attached as LSS.
I have left the equations to be shown, so you can test and see what is happening and how they are changing values while you are ticking answers.
{ASSESSMENT_CURRENT_TOTAL} only works when a button has been pressed, so to have this working you need to put it one page after the last question that needs to be assessed, which I did by creating a third group. I also used an equation there, summing up the two previous equations, just to check if the calculations are right (and they are).
Funny enough, the ASSESSMENT_CURRENT_TOTAL seems to take the correct assessment value of '3' for the multiple choice question, while .value gives 'Y'. So I think this is definitely a bug.
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.