This application is showing absolute value (from the very beginning) of cases per million (CPM). It would be better and more clear for a user, if it was showing current cases of infected people per milion in a country.
Actual result
- values in table column 5 (
application CPM
) calculated by 'Total Cases / country population'
Expected result
- values in table column 6 (
real CPM
) calculated by 'Active Cases / country population'
| Coutry | Population | Total Cases | Active Cases | application CPM | real CPM |
| --- | ---: | ---: | ---: | ---: | ---: |
| India | 1 352,6 mln | 31 332 159 | 408 950 | 22 471 | 302 |
| USA | 331,4 mln | 35 283 075 | 5 158 542 | 105 937 | 15 565 |
| Brazil | 210,1 mln | 19 632 443 | 752 561 | 91 673 | 3 581 |
| Poland | 38,2 mln | 2 882 066 | 153 604 | 76 240 | 4 021 |
| Czech Republic | 1 672 340 | 10,7 mln | 3 372 | 155 856 | 315 |
| Denmark | 5,8 mln | 310 127 | 11 868 | 53 343 | 2 046 |
(table data from 24.7. 2021)
Population numbers are taken from Wikipedia. Active cases and application CPM numbers is what the application is showing. And last column real CPM
is what it should be showing. As you can see, the numbers are diametrically different.
You are calculating CPM by dividing Total Cases
by country population, but you should divide Active Cases
instead so the information is more relevant. Or just put there another variable with this value.