- Posts: 90
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Scoring and Reporting
- BITCNI
- Topic Author
- Offline
- Premium Member
Your LimeSurvey version: LimeSurvey Cloud Version 6.4.1
Own server or LimeSurvey hosting: Hosted
Survey theme/template: Vanilla
==================
Hello.
Our Survey is about a benchmarking tool, so we ask companies many questions about their current practices, and then we use Excel to do an analysis of their answers. We would, however, like to get this done by LimeSurvey, if possible, even if it's done by a plugin. Where is the best place to start?
Essentially, a question will have (eg) 3 answers, and each answer gets a score AND a comment.
For example:
Do you have this system in place?
Answer 1: Yes
Answer 2: Not yet, but we are in the process of implementing it
Answer 3: No
What we'd like is a report that scores and inserts a comment based on each Question.
Do you have this system in place?
Answer 1: Yes
Score: 10 points
Comment: Well done
Answer 2: Not yet, but we are in the process of implementing it
Score: 5 points
Comment: Well done on starting to implement this system.
Answer 3: No
Score: 0 points
Comment: Consider implementing this system, as it is vital for reporting.
Can anyone advise whether LimeSurvey can do this and then create a detailed Report for each Participant?
It would have a total score , and the Question, the Participant's Answer, and the Comment would appear in the report for each Question.
Thanks in adavance for any guidance.
Sorry if this should have been in the Development thread.
Please Log in to join the conversation.
- tpartner
- Offline
- LimeSurvey Community Team
- Posts: 10109
- Thank you received: 3595
- manual.limesurvey.org/Notifications_%26_..._Notifications_Email
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Please Log in to join the conversation.
- BITCNI
- Topic Author
- Offline
- Premium Member
- Posts: 90
- Thank you received: 0
This looks promising. Are you a Developer? We would like to retain someone to work on this for us
Please Log in to join the conversation.
- Joffm
- Offline
- LimeSurvey Community Team
- Posts: 12940
- Thank you received: 3979
Are you interested in this?
Or may I give a further explanation?
Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Please Log in to join the conversation.
- tpartner
- Offline
- LimeSurvey Community Team
- Posts: 10109
- Thank you received: 3595
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Please Log in to join the conversation.
- Joffm
- Offline
- LimeSurvey Community Team
- Posts: 12940
- Thank you received: 3979
the easiest way to is to code the answer options according to the weight.
10: Yes
5: Not yet, but we are in the process of implementing it
0: No
Then it is sufficient to write something like
{Q1.question}
Your answer: {Q1.shown}
Your score: {Q1}
Comment: {if(Q1==0,'Consider implementing this system, as it is vital for reporting.',if(Q1==5,'Well done on starting to implement this system.','Well done'))}
And to show the total score you sum all single ones
{sum(Q1.NAOK,Q2.NAOK,Q3.NAOK)}
[url] manual.limesurvey.org/ExpressionScript_-...mplemented_functions [/url]
and a similar nested if to show a comment
This works as long you do not use negative weights or equal weights of several answer options.
In this case you may use assessment values.
Set the values, like
and calculate the scores as above.
BUT: Now you do not use the code of the answer option, but the assessment values, which you access by the property ".value" resp. ".valueNAOK"
[url] manual.limesurvey.org/ExpressionScript_-...#Access_to_variables [/url]
So it can be like
{Q1.question}
Your answer: {Q1.shown}
Your score: {Q1.value}
Comment: {if(Q1.value==0,'Consider implementing this system, as it is vital for reporting.',if(Q1.value==5,'Well done on starting to implement this system.','Well done'))}
And to show the total score
{sum(Q1.valueNAOK,Q2.valueNAOK,Q3.valueNAOK)}
and a similar nested if to show a comment
It might be better to do some calculations before in some questions of type equation and use these results in your email notification.
Further questions?
Send the lss export of your survey.
Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Please Log in to join the conversation.
- BITCNI
- Topic Author
- Offline
- Premium Member
- Posts: 90
- Thank you received: 0
Regarding, "Then it is sufficient to write something like..."
Where does this get written?
Is this something that can be done *easily*, or do you offer a development service? Not sure if this forum allows PMs, but if you would be willing to help us with the development of this, then perhaps you could PM me? Or I can provide an email address? If you are unable to help via email, then perhaps a little bit more guidance would be very helpful.
Either way, thanks so much.
Please Log in to join the conversation.
- Joffm
- Offline
- LimeSurvey Community Team
- Posts: 12940
- Thank you received: 3979
Anywhere where you want to display it.Where does this get written?
In a question text of a different question.
In a text display question.
In the end message
And - I think this is what you want to do - in the email notification.
Just try and see!
As I wrote
Further questions?
Send the lss export of your survey.
Joffm
BTW:
Import ans satudy the saample surveys provided here.
[url] manual.limesurvey.org/ExpressionScript_sample_surveys/en [/url]
The first example is useful for your question.
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Please Log in to join the conversation.
- BITCNI
- Topic Author
- Offline
- Premium Member
- Posts: 90
- Thank you received: 0
LSS file attached.
Greatly appreciate your help with this! If you'd like to message me, my email is bitcni@gmail.com
Please Log in to join the conversation.
- Joffm
- Offline
- LimeSurvey Community Team
- Posts: 12940
- Thank you received: 3979
sorry, but what can I answer, if you do not do what you are told?
I wrote
and you codethe easiest way to is to code the answer options according to the weight.
10: Yes
5: Not yet, but we are in the process of implementing it
0: No
B11: No
B12: Yes, option 1
B13: Yes, option 2
B14:Yes, option 3
How do you want to sum this?
And instead of "You reached {S1Q1} points", you have to write
You reached {if(S1Q1=="B11",0,if(S1Q1=="B12",2,if(S1Q1=="B13",5,10)))} points
And how do you want to handle the multipunch questions?
Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Please Log in to join the conversation.
- BITCNI
- Topic Author
- Offline
- Premium Member
- Posts: 90
- Thank you received: 0
The Survey is a little complicated, as you may have noticed. There is the option to skip some questions if you are a small business.
By multipunch questions, do you mean that if they answer Yes to something and another option appears, such as "Do you have X" and they say YES, then another question asks them how many, and they have to select one of those other options? I work in LS so infrequently that I'm unfamiliar with the terms used
Please Log in to join the conversation.
- BITCNI
- Topic Author
- Offline
- Premium Member
- Posts: 90
- Thank you received: 0
Please Log in to join the conversation.