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

The total crime layer table should be as shown below,

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

• Click OK and a % Narcotics field is populated in the attribute data as shown below