Please help us help you and fill where relevant:
Your LimeSurvey version: 5.6.9+230306
Own server or LimeSurvey hosting:Own server(Azure)
Survey theme/template:fruity
==================
I would like to calculate the response rate within a survey.
The "lime_survey_{sid}" data table holds the answers, but since the conditions for "answered" differ for each question type, it is impossible to calculate the response rate from this table.
Is there a way to calculate the response rate considering the following examples?

example)
[Question type - Multiple choice]: If any one is checked, there is an answer, if none is checked, there is no answer.
[Question type - List (Dropdown)]: Answer if dropdown is selected, no answer if not selected

Thanks!

You can do this in an equation question. Maybe something like this:


- www.limesurvey.org/manual/ExpressionScri...#Access_to_functions

I would like to dynamically obtain the question response rate depending on the question type.
I want to generate it using SQL, but which table should I refer to when creating it?

I would like to dynamically obtain the question response rate

That is "the actual response rate" of the entire survey so far?

Use the functions of the plugin "statFunctions"

Joffm
 

What exactly do you mean with "question response rate"?

Because response rate can be calculated in different ways. For me the response rate 1 is people invited vs. people finishing the survey. Response rate 2 would be people starting the survey (clicking the link) vs people who finish and so on.

Regarding the response rate,
Refers to one respondent's progress in the survey.
I would like to get the progress like the example below.
example)
100%: All items answered
20%: 2/10 questions answered
0%: Not answered


Is there a way to calculate progress using the "lime_survey_{sid}" table or other tables?
There is no problem with functions such as plug-ins.

Now I'm absolutely confused.
The respondent's progress?
So after each question you want to calculate this rate?
Do you want to display it to the respondent?

Or do you want to calculate something in your analysis of the survey?
In this case it's easy to do this in Excel or OpenOffice.

Please, explain better what is your goal.

Joffm 

So after each question you want to calculate this rate?

You're right.
After answering the questionnaire, you will be redirected to a self-made "respondent-only site".
I would like to display [number of answers/number of questions] as a percentage on that site.

But that's not a "progress", or?

Refers to one respondent's progress in the survey.

It's just the overall result of the respondent.

I would like to display [number of answers/number of questions] as a percentage on that site.

This you can do with a simple equation.
Well, you have to define the condition of "answered".
Like: Do you count each subquestion of an array separately or not, etc.?

Joffm
 

Well, you have to define the condition of "answered".
Like: Do you count each subquestion of an array separately or not, etc.?
 

Common to all question types, I would like to count it as one question without counting subquestions.
I would like to count it as "answered" under the following conditions.
・For [question types with subquestions] or [question types that allow multiple answers], I would like to count if at least one of them is answered.
・I would like to count single questions if they are answered.

As I said, put the count in an equation question in the last group. Then you have that count in the data for all completed surveys.

tpartner wrote:

As I said, put the count in an equation question in the last group. Then you have that count in the data for all completed surveys.
 

Thank you.
There is one issue.

In the following conditions, {sum(count(that.S1Q1), count(that.S1Q2))} will count the number of subquestions.
　・For [question types with subquestions] or [question types that allow multiple answers], I would like to count if at least one of them is answered.

Is there a way to count it as 1 if count(that.S1Q2) is greater than or equal to 1?