Individual response rate calculation

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.
Thank You!

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!

1 Like