A time series graph

More
1 month 1 week ago #200305 by junejaalok
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
Attachments:

Please Log in to join the conversation.

LimeSurvey Partners
More
1 month 1 week ago #200317 by DenisChenu
Replied by DenisChenu on topic A time series graph
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

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.

Please Log in to join the conversation.

More
1 month 1 week ago #200319 by Joffm
Replied by Joffm on topic A time series graph
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


Volunteers are not paid.
Not because they are worthless, but because they are priceless
Attachments:

Please Log in to join the conversation.

More
1 month 1 week ago #200333 by junejaalok
Replied by junejaalok on topic A time series graph
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

Please Log in to join the conversation.

More
1 month 1 week ago #200334 by junejaalok
Replied by junejaalok on topic A time series graph
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

Please Log in to join the conversation.

More
1 month 1 week ago #200335 by Joffm
Replied by Joffm on topic A time series graph
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


Volunteers are not paid.
Not because they are worthless, but because they are priceless

Please Log in to join the conversation.

More
1 month 1 week ago #200364 by DenisChenu
Replied by DenisChenu on topic A time series graph
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 :)

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.

Please Log in to join the conversation.

More
1 month 1 week ago #200378 by holch
Replied by holch on topic A time series graph
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.

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The following user(s) said Thank You: DenisChenu

Please Log in to join the conversation.

More
1 month 1 week ago #200396 by junejaalok
Replied by junejaalok on topic A time series graph
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

Please Log in to join the conversation.

More
1 month 1 week ago #200406 by Joffm
Replied by Joffm on topic A time series graph
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


Volunteers are not paid.
Not because they are worthless, but because they are priceless

Please Log in to join the conversation.

More
1 month 1 week ago #200424 by junejaalok
Replied by junejaalok on topic A time series graph
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

Please Log in to join the conversation.

More
1 month 1 week ago #200425 by junejaalok
Replied by junejaalok on topic A time series graph
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

Please Log in to join the conversation.

More
1 month 1 week ago #200440 by holch
Replied by holch on topic A time series graph

I am wondering if count of YES or NO are summarized for each question or group in some table.


No. Limesurvey just records the responses one by one. What you are looking for is already an analisis. Limesurvey has its own simple reporting, but this is rather for getting a quick idea of what is going on during fieldwork than a full fledged analysis tool.

There are other tools for data analysis out there. Limesurvey is a data collection tool, not necessarily a data analysis tool (even if you can do some very simple analysis).

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The following user(s) said Thank You: DenisChenu, junejaalok

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now