Counting number of responses from a form

User Support Form Building
, , ,
1

Hello, I’d like to do something similar but not sure how. I have a series of questions that can be aswered 0, 60, 100 for examples. I’d like to know how many questions were anwered 0, how many were answered 60 and how many were answered 100. Is that feasible directly in the kobo form?

Thank you!

Best

Diane

2

Hello,

Anyone would have an idea for counting how many questions were answered 0, how many were answered 60, how many were answered 100 etc?

Thank you

3

@dianedetoeuf, in a survey project or in a single survey form (that was filled up)?

4

On a single survey form that was filled up.
When they were collecting on paper they were then using the Countif function on excel to calculate how many answers were 0, how many were 60 etc. I’m trying to do the same on the Kobo form… But so far all the count functions seem to have been used only to calculate the number of answers selected in 1 questions, not the number of answers responding to a specific criteria over multiple questions (those questions are select_ones). Does that make sense?

5

@dianedetoeuf, are you talking of something that should count the response as shown in the image below:

In the survey tab of your XLSForm:

Image 1
Image 11433×405 39.3 KB

In the choices tab of your XLSForm:

Image 2

Data entry screen as seen in Enketo:

Image 3
Image 3405×907 45.5 KB

Reference XLSForm:

Counting Response.xlsx (10.8 KB)

6

Its a bit more difficult than that because my select_ones have more than 2 choices, and I also need to use results from previous calculated questions. Here is the form so you can have a look, the calculations I want to do are lines 88, 89 and 90.

Fishery_assessment_20211208.xlsx (61.9 KB)

7

OK @dianedetoeuf, could you list out a dummy question maybe 2-3, and also their possible choices. Then please provide the scenario of your calculation on how you wish to see. Maybe the community should be able to help you out.

8

Sure, here is a simplified example with what the results should look like:

image
image945×423 71.9 KB

And the simplified form is attached. Would be extremely grateful if this can be solved by the community !!
scoring_test.xlsx (20.9 KB)

Thanks

1 Like
9

This is very clear now.

10

@dianedetoeuf, please correct me if I am wrong. Should it be in the way as shown below:

Image 1
Image 11310×661 52.1 KB

11

Hi Kal,

Actually on Example result 2, because S1 and S2 scores are both 0 then the number of scores between 0 and 60 is 2, so LowRiskScore is 2.
On example 3, the 3 scores are 0, so the LowRiskScore is 3.
Does that make sense?

12

@dianedetoeuf, maybe this should solve your issue:

In the survey tab of your XLSForm:

Image 1
Image 11681×232 33.6 KB

In the choices tab of your XLSForm:

image
image1380×390 38.4 KB

Reference XLSForm:

scoring_test.xlsx (20.1 KB)

13

Will try that, thank you so much @Kal_Lam!

1 Like