Case Management Question

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