Welcome to the LimeSurvey Community Forum

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

Show survey data total

flasher44
Topic Author
Offline
Senior Member

More

5 years 7 months ago #174443 by flasher44

Replied by flasher44 on topic Show survey data total

Here what I did, I just replace the question CODE, and it return … NOTHING

Where is the problem ?

Code:

{#
    LimeSurvey
    Copyright (C) 2007-2017 The LimeSurvey Project Team / Louis Gac
    All rights reserved.
    License: GNU/GPL License v2 or later, see LICENSE.php
    LimeSurvey is free software. This version may have been modified pursuant
    to the GNU General Public License, and as distributed it includes or
    is derivative of works licensed under the GNU General Public License or
    other free or open source software licenses.
    See COPYRIGHT.php for copyright notices and details.
 
    (¯`·._.·(¯`·._.· Submit Content  ·._.·´¯)·._.·´¯)
 
    This page is displayed after user submits the survey.
    It could be, visually, very different (no header, etc).
 
    It shows the end text, assessments, print answer, and statistics.
 
    Data are in: aSurveyInfo.aCompleted and aSurveyInfo.aAssessments.
    To show this data, turn debug mode on and copy the following line to the end of the <body> element in this file:
    {{ dump(aSurveyInfo.aCompleted ) }}
 
    NOTE: This content is included inside mainrow.twig
    NOTE: see layout_global.twig for more infos
#}

{# include the form opening tag #}
<!-- main form -->
{{ include('./subviews/header/start_form.twig') }}
 
    {# This will display the script and the hidden inputs needed for Expression Manager #}
    {{ aSurveyInfo.EM.ScriptsAndHiddenInputs  }}
 
    <div class="{{ aSurveyInfo.class.submitwrapper }}" {{ aSurveyInfo.attr.submitwrapper }}>
        <div class='{{ aSurveyInfo.class.submitwrappertext }}' {{ aSurveyInfo.attr.submitwrappertext }}>
            {% if (aSurveyInfo.aCompleted.showDefault == true) %}
                <p {{ aSurveyInfo.attr.submitwrappertextpa }}>{{ gT("Thank you!") }}</p>
                <p {{ aSurveyInfo.attr.submitwrappertextpb }}>{{ gT("Your survey responses have been recorded.") }}</p>
            {% else %}
                {{ aSurveyInfo.aCompleted.sEndText }}
            {% endif %}
 
            {# Assessments #}
            {% if (aSurveyInfo.aAssessments.show) %}
                {{ include('./subviews/messages/assessments.twig') }}
            {% endif %}
 
            {#  Link to Print Answer Preview #}
            {% if (aSurveyInfo.aCompleted.aPrintAnswers.show == true) %}
                <!--  Link to Print Answer Preview -->
                <div class="{{ aSurveyInfo.class.submitwrapperdiva }}" {{ aSurveyInfo.attr.submitwrapperdiv }}>
                    <a href="{{ aSurveyInfo.aCompleted.aPrintAnswers.sUrl }}" class="{{ aSurveyInfo.class.submitwrapperdivaa }}" {{ aSurveyInfo.attr.submitwrapperdivaa }}>
                        {{ gT("Print your answers.") }}
                    </a>
                </div>
            {% endif %}
 
            <div> 
    {% set aResponses = getAllTokenAnswers(aSurveyInfo.sid) %}
    {% set responseSum = 0 %}
    {% set responseCount = 0 %}
    {% set responseToken = '' %}
 
    {% for response in aResponses %}
        {% if (response['BIRD'] != '') %}
            {% set responseSum = responseSum + response['BIRD']|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>
 
            {# Link to Public statistics #}
            {% if (aSurveyInfo.aCompleted.aPublicStatistics.show == true) %}
                <!-- Link to Public statistics -->
                <div class="{{ aSurveyInfo.class.submitwrapperdivb }}" {{ aSurveyInfo.attr.submitwrapperdivb }}>
                    <a href="{{ aSurveyInfo.aCompleted.aPublicStatistics.sUrl }}" class="{{ aSurveyInfo.class.submitwrapperdivba }}" {{ aSurveyInfo.attr.submitwrapperdivba }}>
                        {{ gT("View the statistics for this survey.") }}
                    </a>
                </div>
            {% endif %}
 
            {# Before LS3 Master, this should be replace by a Twig block logic #}
            {{ aSurveyInfo.aCompleted.sPluginHTML }}
 
            {# NOTE: not very clear what the old replacement keyword {URL} was doing  #}
            {% if (aSurveyInfo.aCompleted.sSurveylsUrl) %}
                <a href="{{ aSurveyInfo.aCompleted.sSurveylsUrl }}">{{ aSurveyInfo.aCompleted.sSurveylsUrlDescription }}</a>
            {% endif %}
        </div>
    </div>
</form> <!-- main form -->

The topic has been locked.

LouisGac
Visitor

5 years 7 months ago #174444 by LouisGac

Replied by LouisGac on topic Show survey data total

I've just released, did you update?

The topic has been locked.

flasher44
Topic Author
Offline
Senior Member

More

5 years 7 months ago #174454 by flasher44

Replied by flasher44 on topic Show survey data total

Yes I updated, I don't have the error message anymore, but the script is not doing anything …

Could you tell me what I'm supposed to change in the original script to get it working ?

The topic has been locked.

flasher44
Topic Author
Offline
Senior Member

More

5 years 7 months ago #174463 by flasher44

Replied by flasher44 on topic Show survey data total

What do represent these numbers ? Token, question name ?

Do I have to edit it ?

Thanks for the help, I 'm not a programmer at all ...

Attachments:

...-09-192_LI.jpg

The topic has been locked.

tpartner
Offline
LimeSurvey Community Team

More

5 years 7 months ago #174476 by tpartner

Replied by tpartner on topic Show survey data total

As I said in my earlier post:

Q1 has, for example, an SGQA identifier of "111111X22X33".

See the manual here - manual.limesurvey.org/SGQA_identifier/en...gle_Choice_Questions

Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

The topic has been locked.

flasher44
Topic Author
Offline
Senior Member

More

5 years 7 months ago #174530 by flasher44

Replied by flasher44 on topic Show survey data total

OK I finaly get ti working, but it's not doing exactly what I want, because in my first post, I wanted to get the total number of bird and frog seen for the day, and the grand total of animals seen, from the begining.

The topic has been locked.

flasher44
Topic Author
Offline
Senior Member

More

5 years 7 months ago #174536 by flasher44

Replied by flasher44 on topic Show survey data total

I cannot get the syntax correct in order to reference the first sub-question of a list-item question with two subquestions answers.
surveyID = 162958
GroupID = 31
QuestionID = 309
Subquestion answer #1: Especes_1
Subquestion answer #2: Especes_2

Then I use this SQA value to identify my question : 162958X31X309Especes_1

But it does not work …

Any idea why ?

The topic has been locked.

tpartner
Offline
LimeSurvey Community Team

More

5 years 7 months ago #174549 by tpartner

Replied by tpartner on topic Show survey data total

I don't understand what a "list-item" question is. If it's a list-radio it has answers, not sub-questions.

The identifier that you are looking for is the column name in the database. If you do not have access to the database, activate the survey and then export some responses using the "Question codes" option. You will see these column headers in the Excel file.

Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

The topic has been locked.

flasher44
Topic Author
Offline
Senior Member

More

5 years 7 months ago #174572 by flasher44

Replied by flasher44 on topic Show survey data total

tpartner wrote: I don't understand what a "list-item" question is.

I mean the question type with ID309 is : array (number)

And what I call "list item" of the sub question are number to choose between 0 to 20

It's not a radio button type at all, all answers are NUMBERS.

OK so I did you what you said, I exported the answers to excel, and in the column header was written as question code : Especes[1_1].

I tried the new SQA value 162958X31X309Especes[1_1] , but it does not work.

The topic has been locked.

DenisChenu
Offline
LimeSurvey Community Team

More

5 years 7 months ago #174582 by DenisChenu

Replied by DenisChenu on topic Show survey data total

Screenshot of Question logic file

Else : manual : manual.limesurvey.org/Expression_Manager#Access_to_Variables

Something like QCODE_Especes_1 or QCODE_1_Especes

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 topic has been locked.

flasher44
Topic Author
Offline
Senior Member

More

5 years 7 months ago #174605 by flasher44

Replied by flasher44 on topic Show survey data total

none are working ...

The topic has been locked.

DenisChenu
Offline
LimeSurvey Community Team

More

5 years 7 months ago #174615 by DenisChenu

Replied by DenisChenu on topic Show survey data total

Send a screenshot of Question logic file …

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 topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans

Get started

Welcome to the LimeSurvey Community Forum

Show survey data total

Lime-years ahead

Legal

About Us

Open Source