For data analysis/visualization purposes, I want to have the all data
associated with a single case to be consolidated to one row in the exported
spreadsheet. Currently, each distinct registration and followup for a given
case is it a separate row. For example:
Case
Visit
Health Indicator 1
Health Indicator 2
Health Indicator 3
1
1
Good
Fair
Good
1
2
Fair
Fair
Poor
1
3
Fair
Good
Fair
2
1
Good
Good
Fair
3
1
Poor
Fair
Fair
3
2
Good
Fair
Good
I'm wondering if it is possible to export the data to a spreadsheet which
has one row per case and lists the various health indicators per visit in
the columns. Would using Case Management allow for this, or is this
something that I will just have to format in Excel, post export?
Hi Ryan,
I think the case export functionality is probably you're best bet - with
perhaps some further configuration using a custom excel dashboard.
Here is the wikipage on case exports
https://confluence.dimagi.com/display/commcarepublic/Case+History+Exportand
here is a wiki reference on custom excel dashboards.
https://confluence.dimagi.com/display/commcarepublic/Tutorial:+Create+an+Excel+Dashboard?src=search
-Claire
ยทยทยท
On Mon, Jul 18, 2016 at 10:01 AM, Ryan Seguin wrote:
For data analysis/visualization purposes, I want to have the all data
associated with a single case to be consolidated to one row in the exported
spreadsheet. Currently, each distinct registration and followup for a given
case is it a separate row. For example:
Case
Visit
Health Indicator 1
Health Indicator 2
Health Indicator 3
1
1
Good
Fair
Good
1
2
Fair
Fair
Poor
1
3
Fair
Good
Fair
2
1
Good
Good
Fair
3
1
Poor
Fair
Fair
3
2
Good
Fair
Good
I'm wondering if it is possible to export the data to a spreadsheet which
has one row per case and lists the various health indicators per visit in
the columns. Would using Case Management allow for this, or is this
something that I will just have to format in Excel, post export?
--
You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
Claire E. Cravero
Senior Field Manager https://www.linkedin.com/in/claire-cravero-74268559
Dimagi, Inc | 585 Massachusetts Ave | Suite 3 | Cambridge, MA 02139
web: http://www.dimagi.com/ | m: 857-317-1225