Counting number of questions answered

Discussions about CSEntry
bidhu
Posts: 25
Joined: April 15th, 2013, 12:43 pm

Counting number of questions answered

Postby bidhu » November 14th, 2017, 12:48 pm

Hi,

I want to see how many questions are asked by investigators in each section of a questionnaire. For that I need to count the number of questions with not applicable values. I tried counting it using countNonSpecial function. But, it is not providing me the right value. Can anyone suggest if there is a simpler way of counting the number of questions that has been answered in one record?

htuser
Posts: 249
Joined: December 19th, 2011, 6:26 pm
Location: HAITI

Re: Counting number of questions answered

Postby htuser » November 15th, 2017, 2:36 pm

Hi Bidhu,
It's possible by using the new sqlquery function and paradata. Since paradata isn't yet supported in help and 7.1 version is in alpha. You've to wait.
Maybe someone have another way and can help us.
Best regards,

josh
Posts: 1227
Joined: May 5th, 2014, 12:49 pm
Location: Washington DC

Re: Counting number of questions answered

Postby josh » November 15th, 2017, 6:15 pm

I would just create a counter variable that I initialize to zero at the start of the record and increment in each postproc when the question is answered. A lot of copy and pasting but it would work.

bidhu
Posts: 25
Joined: April 15th, 2013, 12:43 pm

Re: Counting number of questions answered

Postby bidhu » November 15th, 2017, 11:14 pm

Thank you, Josh. I thought of the second way. But, I was looking for a simpler solution. Also, I wanted to implement it as part of the Monitoring program to monitor progress in survey using the HTML program. As of now, I am using the countvalid function and doing some adjustment to it for each section.


Return to “Entry”