Welcome, Guest
Username: Password: Remember me

TOPIC: Sum of all assessment values

Sum of all assessment values 3 months 1 week ago #103128

  • camargo
  • camargo's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
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: 3 months 1 week ago by camargo. Reason: Found some answers and fixed the question
The administrator has disabled public write access.

Sum of all assessment values 3 months 1 week ago #103132

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 5845
  • Thank you received: 715
  • Karma: 222
The administrator has disabled public write access.
The following user(s) said Thank You: camargo

Sum of all assessment values 3 months 1 week ago #103135

  • camargo
  • camargo's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
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 administrator has disabled public write access.

Sum of all assessment values 3 months 1 week ago #103138

  • Ben_V
  • Ben_V's Avatar
  • OFFLINE
  • Platinum Lime
  • Posts: 933
  • Thank you received: 193
  • Karma: 62
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:
<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

goo.gl/Bw5iM => Recherche GG dans le forum français (remplacer "exemple" dans la barre de recherche)
goo.gl/WX8PH => GG search for english forum (Replace "example" in the search bar)
goo.gl/IxiGu => Búsqueda en el foro en español (Cambiar "ejemplo" en la barra de...
Last Edit: 3 months 1 week ago by Ben_V.
The administrator has disabled public write access.
The following user(s) said Thank You: camargo

Sum of all assessment values 3 months 1 week ago #103210

  • Ben_V
  • Ben_V's Avatar
  • OFFLINE
  • Platinum Lime
  • Posts: 933
  • Thank you received: 193
  • Karma: 62
You may follow this similar discussion :)
Benoît

goo.gl/Bw5iM => Recherche GG dans le forum français (remplacer "exemple" dans la barre de recherche)
goo.gl/WX8PH => GG search for english forum (Replace "example" in the search bar)
goo.gl/IxiGu => Búsqueda en el foro en español (Cambiar "ejemplo" en la barra de...
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.152 seconds
Donation Image