One of CommCare's many built-in integration options is 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.


Report and indicator descriptions

This dashboard is a sample of what kind of information you can extract from your FFX template app. See the indicator and report descriptions below, and get inspired to grow and customize your dashboard to best meet your teams needs.

Report and indicator descriptions
Dashboard itemDescriptionIndicator description


Total number of confirmed COVID-19 cases.


Count of of covid_19_case cases with patient_case_status = "confirmed"


Total number of suspected COVID-19 cases.


Count of covid_19_case cases with patient_case_status = "suspected"


Total number of confirmed COVID-19 cases who have recovered.


Count of covid_19_case cases with outcome_status = "recovered"


Total number of deaths among confirmed COVID-19 cases.

Count of of covid_19_case cases with patient_case_status = "confirmed" and current_status OR outcome_status = "dead"





Total number of suspected and confirmed COVID-19 cases over time (cumulative).





Cumulative total of covid_19_case cases by date_of_first_symptom_onset, grouped by patient_case_status (confirmed/suspected).




Daily number of suspected and confirmed COVID-19 cases over time.




Individual count of covid_19_case cases by date_of_first_symptom_onset, grouped by patient_case_status (confirmed/suspected).



Total number of confirmed COVID-19 cases who were hospitalized.



Count of covid_19_case cases with patient_case_status = "confirmed" and patient_was_ever_hospitalized = "yes"



Percentage of confirmed COVID-19 cases who were hospitalized.



Values of the patient_was_ever_hospitalized property among covid_19_case cases with patient_case_status = "confirmed"

Percentage of confirmed COVID-19 cases whose Case Initial Reporting form (A1) was completed.Count of of covid_19_case cases with form_completion_date_a2 > 13 days from form_completion_date_a1/ count of covid_19_case cases whose form_completion_date_a1 >= 14 days ago

Percentage of confirmed COVID-19 cases whose Case Follow-up Reporting form A2) was completed.Count of of contact cases with form_completion_date_b2 > 13 days from form_completion_date_b1/ # of contact cases whose form_completion_date_b1 >= 14 days ago

Set up your dashboard

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.


Steps to create manual dashboard

To create a manual dashboard

  1. Go to Data > View All

  2. Click "Export Case Data"

  3. Click Export (case type = covid_19_case)

  4. Select a Date Range for the data you want to export

  5. Click "Prepare Export"

  6. Click "Download" 

  7. 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


Steps to create dashboard integration (requires a paid plan)

To create a dashboard integration

Please 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.

  1. Got to Data > View All

  2. Click "Excel Dashboard Integration" (Only available for Standard subscription plan and higher)

  3. Choose Model type = case

  4. App type = Applications

  5. Application = name of your app (WHO First Few X (FFX) Cases

  6. Case type = covid_19_case

  7. Click "Add Dashboard Feed"

  8. Click "Create"

  9. Click "Update Data" 

  10. Refresh the page (Ctrl + F5) and copy the Dashboard Feed Link

  • No labels