I'm trying to configure a report builder table to display non-numeric values for case properties. For every case property I add to the table, the only "format" I see displayed is sum, average, and count per choice. Is it possible to have the report builder table display non-numeric format data for case properties?
How to adjust the format of data displayed in the CommCare report builder table
commcare
Related Topic
- Module filter with multiple expressions
- Why are there mobile workers missing from the CommCare application status report
- How to compute the time spent in a form
- How to find the closest match in a CommCare Lookup Table
- Can a mobile user update a location’s (custom) fields
- How to see what case/report/user data a CommCare user has access to on mobile
- Display condition error in repeat group controlled by user-input question
Best Answer
If you want to simply display the case properties, you must create a list report, which is not aggregated.
If you are creating an aggregated report (data table type or worker report type), you must chose a way that the values will be aggregated. Since "sum" and "average" are undefined for strings (non-numeric data), you should choose count-per-choice, which will display one column per value, and a count of how many times that value appeared in the corresponding cell.
Suppose your cases looked like this:
If your report was aggregated by district, and you included test_result in your report with a "count per choice" format, then you would get a report that looks like this: