Welcome to the LimeSurvey Community Forum

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

Aggregated array data in statistics / exported data CSV

  • brettvonholdt
  • brettvonholdt's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 month 1 week ago #258807 by brettvonholdt
Your LimeSurvey version: 5.4.7
Own server or LimeSurvey hosting: Own server

==================

Hi Team,

I've had a request from a user to include some extra data in the statistics or exported CSV data files.
Essentially we want to provide a way for an array question to have an overall result that includes all the subquestion results added together for that answer.

Example:
We have an array question, with 6 sub questions and 5 answers.
Each sub question outputs it's own result set, as normal. Answers are example: Strongly Agree, Agree, Disagree, Strongly Disagree, Not applicable to me.

They want to also output an aggregate result for the array question, where each of the subquestion answers are tallied into a total for that array question.
This gives us a 'sentiment' for the answer from the respondent.

Currently we are doing this in Excel, but as each array question is different (different subquestions) it's proving time consuming for the team.

I've read through the documentation, and have used LimeSurvey for 10+ years, so i'm confident that it doesn't do this out of the box, just wanted to double check if anyone has had a similar requirement, and if there was a solution.

Thanks

Please Log in to join the conversation.

  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
1 month 6 days ago #258831 by tpartner
Add equation type questions to calculate the array "totals". These will be exported with the data.

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: brettvonholdt

Please Log in to join the conversation.

  • tammo
  • tammo's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
1 month 6 days ago #258846 by tammo
Do you mean something like this: www.respondage.nl/scoring_an_array/

Greetings!


Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
The following user(s) said Thank You: brettvonholdt

Please Log in to join the conversation.

  • brettvonholdt
  • brettvonholdt's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 month 6 days ago #258857 by brettvonholdt
Thanks Tony,
I think this is what i'm looking for!
Much appreciated.

Please Log in to join the conversation.

  • brettvonholdt
  • brettvonholdt's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 month 6 days ago #258858 by brettvonholdt
Thanks for the example survey Tammo,  I've downloaded it and will try to implement for our use case.
Much appreciated.

Please Log in to join the conversation.

Lime-years ahead

Online-surveys for every purse and purpose