These are problematic within the ODK Aggregate user interface. The
underlying data structures within ODK Aggregate split these out into
separate values, but we did not implement filters for those values.
Other users hopefully have good suggestions on this.
If your organization is a member of the REDCap consortium, and your form
does not contain any media files, you might try the REDCap publisher. When
published, the select-multiple questions are filterable as separate values
within REDCap.
For non-technical people, you will likely need to work with the data in a
spreadsheet. Either via publishing to Google Spreadsheets, Exporting as a
CSV, or using ODK Briefcase to pull and export the data to CSV. Then create
formulas to filter (pivot tables) or extract the values.
If you are technically inclined, and have the $$s, you could host your own
MySQL or PostgreSQL server, and use a 3rd party app (e.g., Tableau) to
directly access and visualize the data in your tables. But this is beyond
most users' capabilities.
···
On Thu, Apr 4, 2013 at 11:17 AM, wrote:
Hi,
I wondered if anyone had any tips on analysing data gathered using a
'select multiple' question, with data processed by ODK aggregate
At the moment, for each set of responses it produces a string separated by
spaces in each cell, for example:
1 2
3
1 3 4
2 4
But the problem is, this makes things tricky for data analysis. Sometimes,
I am interested just in everyone who answered '2' - but it isn't possible
to filter the results to see just the people who answered '2' - because
some people answered '1 2', some '2 4' etc.
I wondered what your tips were on dealing with this kind of data?
Thanks!
TG
--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com
Some of the limitations of ODK - What I have learned from our side, is the
need to REALLY sit and work through the schema of the form before it going
live....and even when it is ready to go live, send up a test form, have a
few users check it and then get back with comments....in most cases those
come up and you are able to eliminate or try another mode of
collection......
In Mitch's response he mentioned CSV.....I for one at point in time, export
same to CSV bring it into excel and work with Excel's filtering systems to
create a table/spreadsheet with the data I need that i can manipulate.
Best of luck.
Don't forget to say if you found other ways and means of getting this
sorted.
···
On Thu, Apr 4, 2013 at 3:20 PM, Mitch Sundt wrote:
These are problematic within the ODK Aggregate user interface. The
underlying data structures within ODK Aggregate split these out into
separate values, but we did not implement filters for those values.
Other users hopefully have good suggestions on this.
If your organization is a member of the REDCap consortium, and your form
does not contain any media files, you might try the REDCap publisher. When
published, the select-multiple questions are filterable as separate values
within REDCap.
For non-technical people, you will likely need to work with the data in a
spreadsheet. Either via publishing to Google Spreadsheets, Exporting as a
CSV, or using ODK Briefcase to pull and export the data to CSV. Then create
formulas to filter (pivot tables) or extract the values.
If you are technically inclined, and have the $$s, you could host your own
MySQL or PostgreSQL server, and use a 3rd party app (e.g., Tableau) to
directly access and visualize the data in your tables. But this is beyond
most users' capabilities.
On Thu, Apr 4, 2013 at 11:17 AM, theagoodsell@gmail.com wrote:
Hi,
I wondered if anyone had any tips on analysing data gathered using a
'select multiple' question, with data processed by ODK aggregate
At the moment, for each set of responses it produces a string separated
by spaces in each cell, for example:
1 2
3
1 3 4
2 4
But the problem is, this makes things tricky for data analysis.
Sometimes, I am interested just in everyone who answered '2' - but it isn't
possible to filter the results to see just the people who answered '2' -
because some people answered '1 2', some '2 4' etc.
I wondered what your tips were on dealing with this kind of data?
Thanks!
TG
--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com
--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
--
"Like a camera I use the negative to develop..uDig"
"Success is the ability to go from one failure to another with no loss of
enthusiasm"
---------------------------------------------------------------------------------------------------------->
Roxroy K. Bollers
OutSourceRox*
*Geographic Information Systems, IT Professional & Wed Developer
tel. 592.685.2737
.........................................................
Follow Us On
Facebook http://www.facebook.com/OutSourceRox
Google+ https://plus.google.com/114064153117817313312
Web http://twitinternational.com/outsourcerox.htm
Twitter: @drbollers http://www.twitter.com/drbollers
Portfolio:
Tropical Timber http://www.tropicaltimber.com
Adventure Guianas http://www.adventureguianas.com/
Surama Eco-Lodge http://www.suramaecolodge.com/
Forest Connect Guyana http://iwokrama.org/forestconnect/index.htm