Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

View filenameImage Added


Download link

Download the Excel Dashboard here: V1 CommCare Dashboard Covid19.xlsxheight400

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.

Ui expand
titleReport and indicator descriptions


Dashboard itemDescription

Image Added


Total number of confirmed COVID-19 cases.

Image Added


Total number of suspected COVID-19 cases.

Image Added


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

Image Added


Total number of deaths among confirmed COVID-19 cases.

Image Added





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

Image Added




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

Image Added



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

Image Added




Percentage of confirmed COVID-19 cases who were hospitalized.

Image Added

Percentage of confirmed COVID-19 cases whose Case Initial Reporting form (A1) was completed.

Image Added

Percentage of confirmed COVID-19 cases whose Case Follow-up Reporting form A2) was completed.


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

Ui expand
titleSteps to create dashboard integration (Standard+ Plan)

To Create Dashboard Integration (Standard+ Plan)

  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


Ui expand
titleSteps to create manual dashboard (Community plan)

To Create Manual Dashboard (Community Plan)

  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

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.