- Posts: 6
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Generate statistics from matrix question group with equation
- CarinaHinterberger
- Topic Author
- Offline
- New Member
Your LimeSurvey version: Cloud Version 6.4.10
Own server or LimeSurvey hosting:
Survey theme/template: Fruity
==================
Hello, first time posting and pretty new to Lime Survey, so please let me know if I am missing something.
I am trying to generate a statistical output after every question group I have. Most of my question groups consist of Matrix type questions where the participants can answer "Yes", "No" and "n / a". I want to have a pie chart, showing the ratio of Yes compared to the other two options. I only want to see results from one participant at the time, so I don't need the data to accumulate from different responses.
So far I tried to create a new question Equation type at the end of each question group and collect the data there. I would do it like this: {sumifop("Yes",G05Q01_SQ001_0,G05Q01_SQ001_1,G05Q01_SQ002_0,G05Q01_SQ002_1,G05Q01_SQ003_0,G05Q01_SQ003_1,G05Q01_SQ004_0,G05Q01_SQ004_1,G05Q01_SQ005_0,G05Q01_SQ005_1)}
Is this already collecting the data in the background? And how can I display it in a pie chart - so I see each group result by itself?
I would really appreciate any pointer in the right direction!
Please Log in to join the conversation.
- Joffm
- Offline
- LimeSurvey Community Team
- Posts: 12940
- Thank you received: 3979
your username makes me think you are able to read German.
Have a look at my "Tutorial 3: Gimmicks", Chapter 3.
You find it in the German section on one of the first ten pages.
Here the shown example in this tutorial.
Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Please Log in to join the conversation.
- CarinaHinterberger
- Topic Author
- Offline
- New Member
- Posts: 6
- Thank you received: 0
statCountIf(G05Q01_SQ001_0, G05Q01_SQ001_1, G05Q01_SQ002_0, G05Q01_SQ002_1, G05Q01_SQ003_0, G05Q01_SQ003_1, G05Q01_SQ004_0, G05Q01_SQ004_1, G05Q01_SQ005_0, G05Q01_SQ005_1, "Ja")
So I suppose I am not to use the function like this and I need to find a different approach.
I don't quite understand yet, how I am supposed to generate a number from the function, or where I have to put the code in order to make it work. I don't think the answer option is where I want to put the stat function (like I detailed above), but how else can I make it relevant for a statistical output?
Please Log in to join the conversation.
- Mazi
- Offline
- Official LimeSurvey Partner
Check manual.limesurvey.org/StatFunctions for more details.
@Joffm: Is there a page with link to all of your wonderful tutorials?
Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support: survey-consulting.com
Contact: marcel.minke(at)survey-consulting.com
Please Log in to join the conversation.
- holch
- Offline
- LimeSurvey Community Team
- Posts: 11660
- Thank you received: 2742
I incorporated the plugin you use (statFunctions),
For what you are trying to do, the plugin is totally useless. The plugin allows you to access answers from other respondents and present accumulated results over all respondents.
I only want to see results from one participant at the time, so I don't need the data to accumulate from different responses.
However, you only want to show the results for the current respondent.
so first of all, you will create equation type questions and make your calculations. Once you made your calculations and everything works, you can do the next step and show it in a graph.
From what I understood, this graph is not for you, but rather to show to the respondent within the survey, correct?
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Please Log in to join the conversation.
- holch
- Offline
- LimeSurvey Community Team
- Posts: 11660
- Thank you received: 2742
@Joffm: Is there a page with link to all of your wonderful tutorials?
No, you have to search in the German forum for them. Unfortunately Joffm didn't want me to create a sticky post including the links...
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Please Log in to join the conversation.
- Joffm
- Offline
- LimeSurvey Community Team
- Posts: 12940
- Thank you received: 3979
In the meantime I changed my mind.
So I'll create a new topic with only a short description and the links to the pdfs.
Joffm
Btw:
The syntax of "sumifop" is wrong.
Either you use
sumifop("==","1",Q1,Q2,...).
You missed the operator.
Or
sumif("1",Q1,Q2,...)
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Please Log in to join the conversation.
- CarinaHinterberger
- Topic Author
- Offline
- New Member
- Posts: 6
- Thank you received: 0
The graph is not for the respondent and should not be accessible to them, it should be easily accessible in the background, preferably within the statistics section of Lime Survey so I don't have to export the data.... So I want Lime to calculate the ratio of Yes to No and n/a answers for each question group and then I want to access this calculation again and plot a pie chart displaying Yes vs. No.
The point is to see in the background how many of the certificates listed in the survey(each line in the matrix equals one certificate) are applicable to the respondent. I want to generate this for every question group and the end goal is to display a report sheet, which shows only the accumulated pie chart for each group as a quick overview.
Please Log in to join the conversation.
- Joffm
- Offline
- LimeSurvey Community Team
- Posts: 12940
- Thank you received: 3979
so you confused us.
In your first post you wrote
But obviously you only want to calculate some values.I am trying to generate a statistical output after every question group I have
Then it is sufficient to create some (hidden) questions (e.g. of type list(radio)) and preset the values by your calculation equation.
Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Please Log in to join the conversation.
- CarinaHinterberger
- Topic Author
- Offline
- New Member
- Posts: 6
- Thank you received: 0
I am still not understanding, how I can do what you propose? It sounds logical, but I don't know how to connect the two things. Do I need to assign the Yes-answers a variable to re-use it afterwards? Or how can I refer to it again afterwards, since I cannot display a Equation type question in the statistics. I am also not finding this connection between calculating and making it available in the stats in the manual - it' sso detailed, but I am somehow missing the connection..
Please Log in to join the conversation.
- holch
- Offline
- LimeSurvey Community Team
- Posts: 11660
- Thank you received: 2742
The statistics is always based on all respondents, not a single respondent.
So you will have to approach this differently I think.
Let's sum up your situation, if we get this right.
1. It is not a survey, but some kind of test / evaluation and the overall results for all respondents are not relevant to you. The single results of each respondent is what you are trying to get to. So this means the statistics are basically useless.
2. You have a number of question groups and for each question group you'll calculate some kind of result.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Please Log in to join the conversation.
- CarinaHinterberger
- Topic Author
- Offline
- New Member
- Posts: 6
- Thank you received: 0
But because you say the statistics are useless then: Can I not just filter for a specific aspect (I ask the name in the beginning), and then only display the answers that person gave?
Please Log in to join the conversation.