This feature (Report Builder) is only available to CommCare users with on a Pro Plan or higher. This will provide access to 5 reports. To add more reports, please contact firstname.lastname@example.org, and we'll loop in our sales team to discuss your reporting needs further.
The report builder is a tool for CommCareHQ users to build basic web-based reports based on the data collected in their project's applications. Unlike CommCare's Worker Monitoring Reports, the reports built with this tool are specifically tailored to data collected in your project and can be configured by anyone with access to the reports section of CommCareHQ.
There are three types:
|List||This is a table with a basic list of data (either a list of forms or cases)|
This is a report that contains summarized data based on a chosen case property or form question (i.e. data aggregated by mobile worker or by region).
You can add a bar or pie chart to this report.
This will allow you to display a list of cases or forms and plot their location on a map.
Go to the Reports tab in CommCareHQ and choose + Create new report (if you do not see this option, make sure that your subscription is active in the Project Space Settings)
Choose your report's name and data source. The name can be anything you want - but should be descriptive since this is the name that will show up on CommCareHQ on the list of reports. Each report is based on either a case or a form data source. Select the general type of data you want to use (form or case) and then drill down to the exact case type or specific form that you want to use as the basis for your report.
You can now configure your report and get a live preview of your report! The relevant configurations areas are highlighted below:
Set a name and description for the report by clicking the Edit pencil next to each text field.
Choose the type of report you'd like (a list of records, a summary or a map).
Add indicators to your report by choosing a case property or form question and then clicking on the blue + button. Drag and drop properties to re-order them.
If you have a summary report, you will also see a "Format" column. The options here are:
This section will let you add filters that can be used when viewing the report. Choose "+ Add User Filter" and then choose the column you want to filter on. The format column will control how the filter appears - Choice filters will let you choose one of the possible values of the property, Date filters will let you choose a date range.
Default filters are always applied to the report (so that users don't need to manually apply the filters). For example, you may add a default filter so that only open cases are shown in the report. The Date format will let you automatically filter the report to default date ranges (i.e. the previous month or the last 7 days).
If you are building a Summary report, you can also add a chart. The chart types are "Bar" and "Pie". Bar charts will show one bar per each column that is summed or averaged. Pie charts will show the breakdown of the first column that is summed or averaged.
If you are building a Map report, you also need to choose a location field. This is the field that contains the GPS location that you want to plot (the GPS location can be captured manually in a form or through Automatic GPS Capture.)
Click "View Report" to actually view and use the report.
You can always edit the report by clicking on the blue edit button on the top right of the report.