Create an Animated Choropleth Map

The next step is to normalize the data by calculating the percentage of the population without access to improved water sources.

1. In the attribute table of the number-without-improved-water layer go to the Field Calculator by clicking .

2. Create a new field with Percentage as Output field name and Decimal number (real) as Output field type. Create the following expression:

(  "wat_imp_number_without"  /  "Population (historical estimates)"  )  * 100

3. Click OK to close the dialog and check the result.

Next we'll make a final correction in the attribute table.