Table Join Narcotics Count To The Total Crime Count Layer
The goal of this action is to have a single layer that shows total crime count and narcotics count in the attribute data.
- Right click on the total crime layer >>> properties>>>join
- Click on the green cross icon
and select as shown below
![Table join 1](images/tj_of_narcotics_count.PNG)
The total crime layer table should be as shown below,
![Table join attribute table](images/tj_attribute_data.PNG)
Calculate % Narcotics
To get the % narcotics for each district let’s use the formula below,
Narcotics count / Total crime count * 100
- Right click on total crime layer >>> open attribute table
- Click on edit mode button followed by the open field calculator button
- Enter % Narcotics in the output field name
- Click on fields and values >>> double click Narcotics_count >>> click on forward slash >>> double click on count >>> click on the asterisk button >>> enter 100
![Calculator dialogue box](images/field_calculator_dialogue_box.PNG)
- Click OK and a % Narcotics field is populated in the attribute data as shown below
![Percentage Narcotics](images/pct_narcotics_attribute_table.PNG)