One of CommCare's many
built-in integration options is
the the Excel Dashboard integration, which allows programmatic teams to automatically feed their CommCare data into excel with a few easy steps. As part of the WHO FFX template package, we created a template Excel Dashboard to be downloaded and used by any organizations deploying the WHO FFX app.
Image Removed
Download the Excel Dashboard here: Final V1 CommCare Dashboard Covid19.xlsx
Image Added
Image Added
Report and indicator descriptions
...
If you are on a Standard CommCare subscription or higher, you can download this dashboard and set it up to automatically sync the FFX app data from your project space via CommCare's Excel dashboard integration. If you're on a Community plan, you can still use this dashboard and paste in your data from your CommCare case export.
Find the instructions for your configuration steps below. Remember to reference the case type and properties documentation on the COVID-19 Template App: WHO FFX Protocol page as you dig into your data.
| Ui expand |
|---|
| title | Steps to create manual dashboard |
|---|
|
To create a manual dashboardGo to Data > View All Click "Export Case Data" Click Export (case type = covid_19_case) Select a Date Range for the data you want to export Click "Prepare Export" Click "Download" Open the Excel file and select the data in the first tab and copy it into the Raw Data sheet so the data is updated
|
...
| Ui expand |
|---|
| title | Steps to create dashboard integration (requires a paid plan) |
|---|
|
To create a dashboard integrationPlease note that this requires a paid plan to CommCare. If you are not currently on a paid plan, please apply for a pro bono subscription here.
Got to Data > View All Click "Excel Dashboard Integration" (Only available for Standard subscription plan and higher) Choose Model type = case App type = Applications Application = name of your app (WHO First Few X (FFX) Cases Case type = covid_19_case Click "Add Dashboard Feed" Click "Create" Click "Update Data" Refresh the page (Ctrl + F5) and copy the Dashboard Feed Link
|
...
