How do I search through a field like
field_a for its unique values and then return the counts of each value in a new table?
field_a purple purple purple gold gold black
How do I return a table that looks like this:
newField count purple 3 gold 2 black 1
In reality I have hundreds of values so the query needs to be able to find all unique values, not just "purple", "gold", and "black".
This can be achieved by using a simple stats count by command
your base search | stats count by field_a