Hi,

I am wondering if the following scenario is possible in limesurvey.

I want to track how the response count is changing over time, when the same question with either YES or NO is asked at different times.

For example: A participant can choose YES or NO to answer a question. I ask the question in a team of 10 people today and 4 says YES and 6 says NO. The same question asked after 1 week, 8 says YES and 2 says NO. I want to the time series graph of reflect the change in the behavior.

I made an example in excel. The file is attached. Please have a look of it.

Based on the search that I made and with the functionality available in limesurvey, It seems that it is not possible in limesurvey.

Has someone tried some plugin that facilitates the graphs with several analysis schemes?

OR

Has someone tried pulling the data in third party software R or python or using API.

Best regards,
Alok

You can add an equation question type with {date("Y-m-d")}

After : you can use it in R or other specific system to do what yu want.

LimeSUrvey itself is not done for analysis

Hi,
you are right.
It's not possible in LS.
The statistics here are only to get a rough overview during the survey.

You ask about other solutions.
Yes, we always create something like dashboards to show the life results of a survey.

I personally use php with a graph library like highchart or zingchart.


Joffm

Hi Denis,
Thanks for the tip. I am very new to LS and therefore, need some assistance.

Can you please elaborate on how to have YES / NO question type in combination with your suggestion. I created a equation type question but how do I have that question where participant can answer either YES or NO.
Best regards,
Alok

Hi Joffm,
That is exactly what I am looking for. I have few questions.
1. Where is these dashboards shown.
2. I have never worked with php and therefore, never used any of these graph libraries. I am wondering how is learning curve, in case I need such a nice graphs that you have shown. Since they are very informative, I am ready to invest the time and get the chance to learn something great. Do you have some examples to start with.


Best regards,
Alok

Hi,
1. Nowhere. I created it.
It's bootstrap & highchart.

2. The docs and examples of highchart and zingchart are really good.
And as it is pure jquery you will be able to use it with python as well.

Joffm

I think R + shiny was a good candidate to make really improved dashboards

About Yes/No etc … i just put the way to get data inside survey, but not the dashboard part.

@ Joffm explanation are valid

The problem with shiny is that it gets really expensive when you want the commercial version. If I recall right the non-commercial version was lacking some important features, like user management, etc.

Hi Joffm,
How the date stamp is registered. I am wondering how I get hold of the dates on which the survey was made complete as that is integral part of the whole time series.
Best regards,
Alok

Hi,

either you take it from the answer table (survey not anonymized, datestamp=YES)

or as @Denis: You can add an equation question type with {date("Y-m-d")}

Joffm

Hi Denis,
I just realized one problem with Date concept. The use case, If the participants submit the survey on different dates. It would be better if the equation column can count what is the count in number the participant pressed it submit button rather than on which date.

So I conduct the survey today and few participants submit it today and few tomorrow, so for every participant it should be count 1 irrespective of which date they submit the survey. Next week when I conduct the same survey, the count should increment to 2 when they submit the survey irrespective of which date they submit it.

Do you know how can I achieve this. Is is possible in "equation type" question.

The other option could be that when I re-active the survey by deleting the expiry date, I should have a value in the field which reflects date or count for which this survey is conducted. So in case some users submit it today or tomorrow or they do not submit at all, it does not matter as the value of that column will be same for that period of time before the survey expires again.

Best regards,
Alok

Hi Joffm,
I am trying to understand the DB schemas of LS and you have good understanding of schemas. I am wondering if count of YES or NO are summarized for each question or group in some table.

Best regards,
Alok