Back to limesurvey.org

Welcome to the LimeSurvey Community Forum

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

Show survey data total

More
8 years 1 month ago #174617 by flasher44
Replied by flasher44 on topic Show survey data total
Here is a copy of the orginal survey with the same problem…


The topic has been locked.
More
8 years 1 month ago - 8 years 1 month ago #174630 by tpartner
Replied by tpartner on topic Show survey data total
According to that logic file, the identifier for the first x-axis sub-question (first column) of Bird 1 would be 459729X34X336BI1_SQ001.

Bird 2 would be 459729X34X336BI2_SQ001.

...
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Last edit: 8 years 1 month ago by tpartner.
The topic has been locked.
More
8 years 1 month ago - 8 years 1 month ago #174639 by DenisChenu
Replied by DenisChenu on topic Show survey data total
Or
Code:
{SPECIES_BI2_SQ001.sgqa}
:) then it's OK when you copy the survey …

: SGQA in lowercase see www.limesurvey.org/manual/Expression_Man...#Access_to_Variables at end of table.
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member. - Professional support - Plugins, theme and development .
I don't answer to private message.
Last edit: 8 years 1 month ago by DenisChenu.
The topic has been locked.
More
8 years 1 month ago #174641 by tpartner
Replied by tpartner on topic Show survey data total
Sure, but this is being done in a Twig file so probably:

Code:
processString('{SPECIES_BI2_SQ001.sgqa}')
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The following user(s) said Thank You: DenisChenu
The topic has been locked.
More
8 years 1 month ago #174642 by DenisChenu
Replied by DenisChenu on topic Show survey data total

tpartner wrote: Sure, but this is being done in a Twig file so probably:

You're right …
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member. - Professional support - Plugins, theme and development .
I don't answer to private message.
The topic has been locked.
More
8 years 1 month ago - 8 years 1 month ago #174648 by tpartner
Replied by tpartner on topic Show survey data total
@flasher44, so, if following your screenshot of the logic file, my original code should be something like this:

Code:
<div> {% set bird1SGQA = processString('{SPECIES_BI1_SQ001.sgqa}') %} {% set aResponses = getAllTokenAnswers(aSurveyInfo.sid) %} {% set responseSum = 0 %} {% set responseCount = 0 %} {% set responseToken = '' %} {% for response in aResponses %} {% if (response[bird1SGQA] != '') %} {% set responseSum = responseSum + response[bird1SGQA]|number_format %} {% set responseCount = responseCount + 1 %} {% endif %} {% if (loop.index == 1) %} {% set responseToken = response['token'] %} {% endif %} {% endfor %} {% if (responseCount > 0) %} There are {{ responseCount }} valid responses for Q1 with token value {{ responseToken }}. <br /> The sum of all valid responses is {{ responseSum }}. <br /> The average of all valid responses is {{ (responseSum/responseCount) }}. {% endif %} </div>

NOTE: all instances of sgqa should be in lower-case - see image below. (the forum is transforming the case in the code above)

Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Last edit: 8 years 1 month ago by tpartner.
The following user(s) said Thank You: DenisChenu
The topic has been locked.
More
8 years 1 month ago #174662 by flasher44
Replied by flasher44 on topic Show survey data total
Thank you both, your example is working perfectly on my test survey but when I try to adapt it to my real survey, nothing work …

here is the screenshot my real survey, maybe you could tell me why it's not working.


The topic has been locked.
More
8 years 1 month ago #174665 by DenisChenu
Replied by DenisChenu on topic Show survey data total
Especes_1_1 : www.limesurvey.org/manual/Expression_Man...code_Variable_Naming

But it's always a bad solution to have sub question X and Y with only number
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member. - Professional support - Plugins, theme and development .
I don't answer to private message.
The topic has been locked.
More
8 years 1 month ago - 8 years 1 month ago #174667 by tpartner
Replied by tpartner on topic Show survey data total
Going by that screenshot, your variable definition for species 1 would be:



Species 2 would be:



And so on...

To avoid confusion, it is a good idea to assign the x-axis sub-question codes X001, X002,... And the y-axis codes Y001, Y002...
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Last edit: 8 years 1 month ago by tpartner.
The topic has been locked.
More
8 years 1 month ago #174689 by flasher44
Replied by flasher44 on topic Show survey data total
It does not work … Is it because I have only numbers as x and y axis ?
The topic has been locked.
More
8 years 1 month ago #174691 by flasher44
Replied by flasher44 on topic Show survey data total
IT WORKS !!!!

Thank you so much for your help guys !!!
The topic has been locked.
More
8 years 1 month ago - 8 years 1 month ago #174706 by tpartner
Replied by tpartner on topic Show survey data total
Phew! :)
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Last edit: 8 years 1 month ago by tpartner.
The topic has been locked.
More
8 years 1 month ago #174739 by jelo
Replied by jelo on topic Show survey data total

flasher44 wrote: IT WORKS !!!!
Thank you so much for your help guys !!!

And what did you change? After trying everything ;-)
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.
More
8 years 1 month ago #174756 by flasher44
Replied by flasher44 on topic Show survey data total
The print option display … LOL
The topic has been locked.
More
8 years 1 month ago #174757 by flasher44
Replied by flasher44 on topic Show survey data total
I'm trying to personalize your script, and I would like to get the display of firstname, lastname and survey name, here what I did, none value are returned for names ...
Code:
<div> {% set bird1SGQA = processString('{SPECIES_BI1_SQ001.SGQA}') %} {% set aResponses = getAllTokenAnswers(aSurveyInfo.sid) %} {% set responseSum = 0 %} {% set responseCount = 0 %} {% set responseToken = '' %} {% set responseFirstname = '' %} {% set responseLastname = '' %} {% for response in aResponses %} {% if (response[bird1SGQA] != '') %} {% set responseSum = responseSum + response[bird1SGQA]|number_format %} {% set responseCount = responseCount + 1 %} {% endif %} {% if (loop.index == 1) %} {% set responseToken = response['token'] %} {% endif %} {% if (loop.index == 1) %} {% set responseToken = response[firstname] %} {% endif %} {% if (loop.index == 1) %} {% set responseToken = response[lastname] %} {% endif %} {% endfor %} {% if (responseCount > 0) %} There are {{ responseCount }} valid responses for Q1, {{ lastname }} {{ firstname }}with token value {{ responseToken }}. <br /> The sum of all valid responses is {{ responseSum }}. <br /> The average of all valid responses is {{ (responseSum/responseCount) }}. {% endif %} </div>
The topic has been locked.
Moderators: tpartner, holch

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans
Get started

Legal

About Us

Open Source