Are you saying you have data like this:
[Record ID#], [equity focus areas]
1, "race ; gender ; national origin ; SES"
2, "race ; gender"
3, "gender"
4, "race ; gender ; national origin ; religion"
5, "religion"
And want to count up all the instances of each value across all records and produce a pie chart based on this
aggregated data:
Value | Count
=================+=======
race | 3
gender | 4
national origin | 2
religion | 2
SES | 1
I can't and understand what the goal is but I am 100% confident it can be done using
one native
Rich Text Formula Field!