How to save assessment final score of multiple choice question ?

More
1 week 8 hours ago #190882 by GreenerDaddy
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

Any idea ?
Thanks for your help

Please Log in or Create an account to join the conversation.

LimeSurvey Partners
More
1 week 8 hours ago #190884 by holch
Difficult to help you based on the information provided.

Can you upload a LSS file with only the relevant questions (copy the survey, delete everything unnecessary and export it as LSS and upload it here).

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Please Log in or Create an account to join the conversation.

More
1 week 8 hours ago #190885 by cdorin

Please Log in or Create an account to join the conversation.

More
1 week 7 hours ago #190886 by holch
One thing that I can tell already, this won't work:

{sum(G2Q1.value,G2Q2.value)} return 6 but it returns the text {sum(G2Q1.value,G2Q2.value)}

For a multipe choice question, there is no such thing as G2Q1.value, there would only be G2Q1_SQ001.value, G2Q1_SQ002.value, etc.

Multiple choice questions are basically as many subquestions as answer items and the status is "Y" if clicked and empty if not clicked.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Please Log in or Create an account to join the conversation.

More
1 week 5 hours ago #190892 by GreenerDaddy
Here is the lss file of my syrvey example

I would like the G2Q3 Evaluation questions to save the result of assessment of this group of questions
Attachments:

Please Log in or Create an account to join the conversation.

More
1 week 5 hours ago #190893 by holch
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.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Please Log in or Create an account to join the conversation.

More
1 week 5 hours ago #190895 by holch
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.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Please Log in or Create an account to join the conversation.

More
1 week 4 hours ago - 3 days 12 hours ago #190898 by holch
OK, for the second question group you will have to write something like this into the equation question:
{sum(if(G2Q1_SQ001 == 'Y', 3, 0), if(G2Q1_SQ002 == 'Y', 3, 0), if(G2Q1_SQ003 == 'Y', 3, 0), G2Q2.value)}
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.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds
Attachments:
Last edit: 3 days 12 hours ago by holch.

Please Log in or Create an account to join the conversation.

More
1 week 4 hours ago #190899 by holch

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds
The following user(s) said Thank You: DenisChenu, tpartner

Please Log in or Create an account to join the conversation.

More
6 days 11 hours ago #190912 by GreenerDaddy
Hi,
THanks. Unfortunately I'm not able to import your file. Seems not to be a valid format

Please Log in or Create an account to join the conversation.

More
6 days 10 hours ago - 6 days 10 hours ago #190914 by holch
I accidentally exported a lsq file, instead of a lss file. When I have my notebook, I'll upload the correct file.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds
Last edit: 6 days 10 hours ago by holch.
The following user(s) said Thank You: GreenerDaddy

Please Log in or Create an account to join the conversation.

More
3 days 13 hours ago #191005 by GreenerDaddy
Thanks
I'm looking forward to testing your file

Please Log in or Create an account to join the conversation.

More
3 days 12 hours ago #191008 by holch
I just edited the post with the file, deleted the LSQ and uploaded the LSS file. Have a look and see if it helps you.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Please Log in or Create an account to join the conversation.

More
3 days 10 hours ago #191022 by GreenerDaddy
Thanks for the correction. I understood and will apply.

Please Log in or Create an account to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!