AnsweredAssumed Answered

Counting text occurrences

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

Title

Counting text occurrences

Post

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!

Outcomes