- Posts: 8
- Thank you received: 1
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Average score of a group of questions
- pachos
- Topic Author
- Offline
- New Member
Less
More
6 years 4 months ago #160260
by pachos
Average score of a group of questions was created by pachos
Hi everyone,
I have a survey with 6 groups of questions, and all the answers to these questions are on list radio from number 1 to 10.
I need that in the results of the survey, shows the average score of each group, and save it to the DB so I could print later the results.
For example:
(group) Social = 7
(group) Health = 8
(group) Financial = 5
Also I need to show an image next to the numeric result if the average score is between 3 scores.
For example:
If the average score is between 0 and 3, the result shows an A.png next to the numeric result
If the average score is between 4 and 6, the result shows an B.png next to the numeric result
If the average score is between 7 and 10 the result shows an C.png next to the numeric result
Thak you in advanced!
I have a survey with 6 groups of questions, and all the answers to these questions are on list radio from number 1 to 10.
I need that in the results of the survey, shows the average score of each group, and save it to the DB so I could print later the results.
For example:
(group) Social = 7
(group) Health = 8
(group) Financial = 5
Also I need to show an image next to the numeric result if the average score is between 3 scores.
For example:
If the average score is between 0 and 3, the result shows an A.png next to the numeric result
If the average score is between 4 and 6, the result shows an B.png next to the numeric result
If the average score is between 7 and 10 the result shows an C.png next to the numeric result
Thak you in advanced!
The topic has been locked.
- Joffm
- Away
- LimeSurvey Community Team
Less
More
- Posts: 12788
- Thank you received: 3940
6 years 4 months ago #160264
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Replied by Joffm on topic Average score of a group of questions
Hello, pachos,
there is no implemented function "average".
So you have to do it the usual way.
In an equation sum up the values {sum(Q1.NAOK,Q2.NAOK,...)]
and divide by the count of questions {count(Q1,Q2,...)} By the way, you know the number of questions in the group.
See manual.limesurvey.org/Expression_Manager#Access_to_Functions
This value is stored in the database.
And you'd like to display an image depending on this average.
Here the buzzword is "Tayloring".
manual.limesurvey.org/Expression_Manager#Tailoring_.2F_Piping
Something like: <img src={if(average<4,"A.png",if(average<7,"B.png","C.png"))}>
Best regards
Joffm
there is no implemented function "average".
So you have to do it the usual way.
In an equation sum up the values {sum(Q1.NAOK,Q2.NAOK,...)]
and divide by the count of questions {count(Q1,Q2,...)} By the way, you know the number of questions in the group.
See manual.limesurvey.org/Expression_Manager#Access_to_Functions
This value is stored in the database.
And you'd like to display an image depending on this average.
Here the buzzword is "Tayloring".
manual.limesurvey.org/Expression_Manager#Tailoring_.2F_Piping
Something like: <img src={if(average<4,"A.png",if(average<7,"B.png","C.png"))}>
Best regards
Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
The following user(s) said Thank You: tpartner
The topic has been locked.
- pachos
- Topic Author
- Offline
- New Member
Less
More
- Posts: 8
- Thank you received: 1
6 years 4 months ago - 6 years 4 months ago #160293
by pachos
Replied by pachos on topic Average score of a group of questions
Thank you very much Joffm.
Do I have to use an Equation question type? or can I Continue using List radio type?
So, these equations and tayloring, goes at the end of each group of questions?
And, I would be able to export to pdf the "average" results and the images??
Thanks in advanced!
Do I have to use an Equation question type? or can I Continue using List radio type?
So, these equations and tayloring, goes at the end of each group of questions?
And, I would be able to export to pdf the "average" results and the images??
Thanks in advanced!
Last edit: 6 years 4 months ago by pachos. Reason: I forgot to ask something else
The topic has been locked.
- Joffm
- Away
- LimeSurvey Community Team
Less
More
- Posts: 12788
- Thank you received: 3940
6 years 4 months ago - 6 years 4 months ago #160294
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Replied by Joffm on topic Average score of a group of questions
Hello, nachos,
I do not understand.
You have your radio lists and you calculate sum and average in an equation.
you can put one equation at the end of each group or the equations at the end of the survey, up to you.
And what is your pdf-report?
If you put your pictures into an question of type text display it will be in the report.
manual.limesurvey.org/Expression_Manager...e_using_placeholders
Just try.
In case, send your survey, just a sample with the problematic questions.
Best regards
Joffm
And please, do not cross-post.
I do not understand.
You have your radio lists and you calculate sum and average in an equation.
you can put one equation at the end of each group or the equations at the end of the survey, up to you.
And what is your pdf-report?
If you put your pictures into an question of type text display it will be in the report.
manual.limesurvey.org/Expression_Manager...e_using_placeholders
Just try.
In case, send your survey, just a sample with the problematic questions.
Best regards
Joffm
And please, do not cross-post.
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Last edit: 6 years 4 months ago by Joffm.
The topic has been locked.
- pachos
- Topic Author
- Offline
- New Member
Less
More
- Posts: 8
- Thank you received: 1
6 years 4 months ago #160301
by pachos
Replied by pachos on topic Average score of a group of questions
Thanks for your help and patience, but I still have some problems with the survey.
I have attached a survey sample. It contains only 2 groups of questions. The "average" score of each group doesn't appear in the statistics nor the end of the group when the survey is answered. I've put the equations at the end of each group.
Also, I don't know where to upload the images to be show with the results, according the "average" score in the results of each group. Need to be included in the report.
Thanks again Joffm!
I have attached a survey sample. It contains only 2 groups of questions. The "average" score of each group doesn't appear in the statistics nor the end of the group when the survey is answered. I've put the equations at the end of each group.
Also, I don't know where to upload the images to be show with the results, according the "average" score in the results of each group. Need to be included in the report.
Thanks again Joffm!
Attachments:
The topic has been locked.
- Joffm
- Away
- LimeSurvey Community Team
Less
More
- Posts: 12788
- Thank you received: 3940
6 years 4 months ago - 6 years 4 months ago #160303
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Replied by Joffm on topic Average score of a group of questions
Hello, nachos,
1. how do you calculate the mean of the following texts: A3, B7, C2, D1?
That's what you are trying.
Of course the codes have to be numerical. (1,2,3,4,5,...)
2. Wrong brackets in your equation. The "/" has to be inside the equation.
3. Why did you enter the assessment values? You do not use this in your survey.
4. The pictures can be anywhere in the Internet, as long as you enter the correct url.
If you upload them to your template you can use the placeholder {TEMPLATEURL} to enter the correct path.
I corrected the errors(codes only in grupo 2).
You can hide the boilerplate question; but only by adding the css class "hidden". I did that.
You should hide the equation questions as well.
Best regards
Joffm
1. how do you calculate the mean of the following texts: A3, B7, C2, D1?
That's what you are trying.
Of course the codes have to be numerical. (1,2,3,4,5,...)
2. Wrong brackets in your equation. The "/" has to be inside the equation.
3. Why did you enter the assessment values? You do not use this in your survey.
4. The pictures can be anywhere in the Internet, as long as you enter the correct url.
If you upload them to your template you can use the placeholder {TEMPLATEURL} to enter the correct path.
I corrected the errors(codes only in grupo 2).
You can hide the boilerplate question; but only by adding the css class "hidden". I did that.
You should hide the equation questions as well.
Best regards
Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Attachments:
Last edit: 6 years 4 months ago by Joffm.
The following user(s) said Thank You: pachos
The topic has been locked.
- Joffm
- Away
- LimeSurvey Community Team
Less
More
- Posts: 12788
- Thank you received: 3940
6 years 4 months ago - 6 years 4 months ago #160307
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Replied by Joffm on topic Average score of a group of questions
Hello, nachos,
maybe I misunderstood. You never mentioned assessments before.
So if you want to use assessments, it is not necessaray to calculate a mean to show the appropriate picture. You can calculate it to display the mean in your summary.
E.g. grupo 2:
All questions are mandatory.
If sum between 4 and 15 -> mean <4
If sum between 16 and 27 -> 4 <= mean <7
So you have to define assessment rules like:
grupo
grupo 2
minimum: 4
maximum: 15
title: [something you like]
message: Your message; here you can include the calculated mean {summo} and the [link to picture small mean] (just use the editor)
Best regards
Joffm
maybe I misunderstood. You never mentioned assessments before.
So if you want to use assessments, it is not necessaray to calculate a mean to show the appropriate picture. You can calculate it to display the mean in your summary.
E.g. grupo 2:
All questions are mandatory.
If sum between 4 and 15 -> mean <4
If sum between 16 and 27 -> 4 <= mean <7
So you have to define assessment rules like:
grupo
grupo 2
minimum: 4
maximum: 15
title: [something you like]
message: Your message; here you can include the calculated mean {summo} and the [link to picture small mean] (just use the editor)
Best regards
Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Attachments:
Last edit: 6 years 4 months ago by Joffm.
The topic has been locked.
- pachos
- Topic Author
- Offline
- New Member
Less
More
- Posts: 8
- Thank you received: 1
6 years 4 months ago #160310
by pachos
Replied by pachos on topic Average score of a group of questions
Thanks a lot Joffm!
I used assessments in the survey sample because I saw some examples in the forum using assessments, so it's not mandatory to use it in my survey.
So, if I used the survey that you've attached, would be able to show the result in a report as the image that you show in your last reply?
I used assessments in the survey sample because I saw some examples in the forum using assessments, so it's not mandatory to use it in my survey.
So, if I used the survey that you've attached, would be able to show the result in a report as the image that you show in your last reply?
The topic has been locked.
- pachos
- Topic Author
- Offline
- New Member
Less
More
- Posts: 8
- Thank you received: 1
6 years 4 months ago #160313
by pachos
Replied by pachos on topic Average score of a group of questions
I mean, the survey is not public nor anonymous. I'm going to send invitations (tokens), and when the participants finish the survey, I want to print/export (to PDF) the report of each participant as the image that you've attached. Example
- (Name of participant)
- title of Survey
- Name of group of questions 1
- "Average" Score :
- (with the image accordding the "average" score)
- Name of group of questions 2
- "Average" Score :
- (with the image accordding the "average" score)
and so on.....
I don't need to print/export all the questions and answers of each group.
- (Name of participant)
- title of Survey
- Name of group of questions 1
- "Average" Score :
- (with the image accordding the "average" score)
- Name of group of questions 2
- "Average" Score :
- (with the image accordding the "average" score)
and so on.....
I don't need to print/export all the questions and answers of each group.
The topic has been locked.
- LouisGac
- Visitor
6 years 4 months ago #160325
by LouisGac
Replied by LouisGac on topic Average score of a group of questions
also, in LS3, assesments page can be customized from templates :
github.com/LimeSurvey/LimeSurvey/blob/de...ews/assessments.twig
github.com/LimeSurvey/LimeSurvey/blob/de...ews/assessments.twig
The topic has been locked.
- Joffm
- Away
- LimeSurvey Community Team
Less
More
- Posts: 12788
- Thank you received: 3940
6 years 4 months ago #160336
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Replied by Joffm on topic Average score of a group of questions
Hi, pachos,
if you import and run the survey I attached, you will see the following.after "imprimir repuestas".
And you can print it.
Now the rest is your turn.
By the way: Did you set the tet color of the questions to "white"?
This is done by the template.
And in your report you do not see the text.
So, please remove.
Best regards
Joffm
if you import and run the survey I attached, you will see the following.after "imprimir repuestas".
And you can print it.
Now the rest is your turn.
By the way: Did you set the tet color of the questions to "white"?
This is done by the template.
And in your report you do not see the text.
So, please remove.
Best regards
Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Attachments:
The topic has been locked.
- pachos
- Topic Author
- Offline
- New Member
Less
More
- Posts: 8
- Thank you received: 1
6 years 4 months ago #160341
by pachos
Replied by pachos on topic Average score of a group of questions
Hi Joffm,
I've tested the survey and I see that you say. But this "button" is for the participants, right?
Is there any option to see this results in the statistics (backend), as the sample survey (imprimir respuestas)??
I've tested the survey and I see that you say. But this "button" is for the participants, right?
Is there any option to see this results in the statistics (backend), as the sample survey (imprimir respuestas)??
The topic has been locked.