2 Replies Latest reply on Nov 30, 2016 12:50 PM by Justen Burrhus

    [State]/Total([State])=Percentage >> Trying to get percent of states contribution using Count([Var is String])

    Justen Burrhus

      I have created a map that shows the count of state occurrence. I have also converted this count of a [String Variable] into a [Numerical Variable] aggregate using the formula pictured below.

      Screen Shot 2016-11-30 at 2.17.39 PM.png

      I need to take the count in each state and divide it by the total count for the USA.

       

      The data set contains a [country] and [state] variable so I have filtered out any country that isn't the USA.

       

      In excel terms I want *[Specific State]/Total([State]))*100=[Percentage of total state count]

      - State total is not a discrete count