Hello XLS family.
My question is simple, I want to know if it's possible to be able to calculate an individual response rate just before submission. The idea is, I want my data collectors to be able to see the response rate of each individual survey before they submit.
Looking forward to your response.
Welcome to the ODK forum, @Thadey! We're glad you're here. When you get a chance, please introduce yourself on this forum thread. I'd also encourage you to add a picture as your avatar because it helps build community!
Can you please explain more about what you are trying to do...
- Do you mean the number of forms submitted from the device?
- The percentage of the questions in the form that the person answered?
- Something else?
The percentage of the questions in the form the person answered or was answered.
Forgive me for taking this fun puzzle from you, @danbjoseph.
The best solution I can find is to build up a space-separated string of all the answers using
concat and the explicit question references and then calling
count-selected on that.
See an example form here.
Note for the XPath lovers among us. It should be possible to do something like
count(/data/questions/*[. != '']) but it looks like
* is not supported by ODK Collect.
Maybe you'll find a better way, @danbjoseph!