Export multiple choices as children variables with boolean values

What is the problem? Please be detailed.
In ODK Aggregator, when we have multiple choice variable, it only shows "parent variable" which contains all values that we ticked in ODK Collect. But, not showing its "child variables" which contain boolean variable whether those value were ticked or not (1 or 0).

What ODK tool and version are you using? And on what device and operating system version?
ODK Aggregate v1.4.15 on Ubuntu 15 Server
ODK Collect on Android

What steps can we take to reproduce the problem?
Is it possible to have those "child variables" shown also in ODK Aggregate?

What you have you tried to fix the problem?
After exporting into .csv, I follow instruction from (I believe) this forum or google groups, to use Data -> Text to Columns. Would be nice if ODK Aggregate have also this 'feature', like KoBoToolbox had.

Anything else we should know or have? If you have a test form or screenshots or logs, attach here.
Here I captured the comparison between ODK Aggregate and KoBoToolbox
mc_combined

Thank you!

Thanks so much for your detailed feedback! This is more of a feature request for Aggregate, so I've moved it to that category.

There are R Packages that handle this but agree this would be very useful feature.

1 Like