Chapter 6 Expand Your Dashboard
6.1 Cancer mortality data
If you have cancer mortality data, CaRDO will add a mortality statistics page to your dashboard. The data requirements and processes for loading cancer mortality data are identical to those we’ve described for cancer incidence data.
You must have a single column for each variable and outcome you wish to report, and each row in your dataset should correspond to a unique combination of each variable.
Cancer-type values must be coded as you wish them to be displayed.
Cancer deaths must be aggregated by 5-year age groups, with age groups coded numerically from 1 – 18. The interface will ask you to load in a cancer incidence and mortality file separately. However, whether you store mortality data in a separate data file, or as an additional column in your incidence data file (and load the file twice) does not matter.
6.2 Age-standardised rates - population data
If you wish to report age-standardised cancer rates, you must provide a population file that corresponds to the area your cancer data covers—for example, a specific country, state or province, city, or health region. Population data should be organised by 5-year age groups, year, and sex, and otherwise be structured the same as your incidence data. See the example to the right (variable names do not matter).
| Year | Sex | Age.group | Population |
|---|---|---|---|
| 2013 | 2 | 1 | 6332 |
| 2014 | 1 | 1 | 7541 |
| 2015 | 2 | 6 | 8544 |
| 2016 | 2 | 14 | 12632 |
| 2017 | 1 | 11 | 9198 |
6.3 Other data details to note
CaRDO will calculate age-standardised rates using a standard population that you will specify from a list of options. The default standard population is the World Standard Population.
As with incidence and mortality, it is not necessary that your population file contains population data for persons.
Rates will be suppressed where low count data has been suppressed.
You’re now ready to launch CaRDO and begin building your own dashboard using the following command.
- For guidance navigating the CaRDO user interface, return to launch CaRDO and follow the steps.
When you’ve finished building your CaRDO dashboard, learn how to publish it online here.