Welcome to the LimeSurvey Community Forum

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

Sum of all assessment values

  • camargo
  • camargo's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
10 years 2 months ago - 10 years 2 months ago #103128 by camargo
Sum of all assessment values was created by camargo
I would like to know if it's possible to sum all of the question's assessment values.

The form has 62 questions, so the sum() function with every name will be quite large.

I currently have this in mind:
sum(GR610727.valueNAOK, GR610728.valueNAOK, ..., GR610787.valueNAOK, GR610788.valueNAOK)

Is there a better way?

Thanks
Last edit: 10 years 2 months ago by camargo. Reason: Found some answers and fixed the question
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
10 years 2 months ago #103132 by DenisChenu
Replied by DenisChenu on topic Sum of all assessment values

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The following user(s) said Thank You: camargo
The topic has been locked.
  • camargo
  • camargo's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
10 years 2 months ago #103135 by camargo
Replied by camargo on topic Sum of all assessment values
Thanks, but what about the sum of every value?

I really need to put every single question id inside the SUM function or there is another way?
The topic has been locked.
More
10 years 2 months ago - 10 years 2 months ago #103138 by Ben_V
Replied by Ben_V on topic Sum of all assessment values
Hi,

at the end of your survey:
1) create a new group with a numerical question ("score")
2) paste the following snippet in the source of this question:
Code:
<script type="text/javascript">
jQuery(document).ready(function() {
$('body').hide();
$(".numeric:eq(0) input.text").val("{ASSESSMENT_CURRENT_TOTAL}"); //!\ ASSESSMENT_CURRENT_TOTAL all  uppercase
document.limesurvey.submit();
});
</script>

conditions:
a) Disable the internal XSS filter at the admin section (global settings -> security )
b) Set your survey presentation "group by group" or "question by question"
c) Respect all settings required for assessment use as described in the manual

Benoît

EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
Last edit: 10 years 2 months ago by Ben_V.
The following user(s) said Thank You: camargo
The topic has been locked.
More
10 years 2 months ago #103210 by Ben_V
Replied by Ben_V on topic Sum of all assessment values
You may follow this similar discussion :)

Benoît

EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose