8 Replies Latest reply on Sep 5, 2018 9:13 AM by Elizabeth Farrington

    Incident Rate

    Elizabeth Farrington

      Hello I am trying to create a map that shows the incident rate of violent *** crimes per 10,000 in the population.  I work for the Criminal Justice Institute hence the topic.

      First I created the calculated field of SUM([Rape]+[*** Offenses]+[Human Trafficking] ). Now I have a total of *** crimes for every reporting Indiana County.  I want to take (*** crimes/county population)*10,000 to give me the incident rate of *** crimes per 10,000 people.  Is there a formula I can use in calculated field to do this?  If not I have also have Tableau Prep is there a way to take the calculated field of *** crimes and perform that formula in there?