AnsweredAssumed Answered

Counting text occurrences

Question asked by Jeff123 on Apr 4, 2010
Latest reply on Apr 5, 2010 by mrvodka


Counting text occurrences


I am trying to figure out how to find out the number of text occurrences throughout a single field in all present records.  


For example, I have a field with a drop down list of each of the 50 states.  How would I create a field to determine that, for example, there are 3 Californian records, 4 Alabama records, etc.


The reason for this is to hopefully be able to get a pie chart showing the percentage of each state.  I am having a terrible time trying to get it working though.


Thanks in advanced for any help!