Getting Data In
Highlighted

How do you count the number of unique values in a field to return in a new table?

Communicator

Hi,

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?
example.csv

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".

Thank you.

0 Karma
Highlighted

Re: How do you count the number of unique values in a field to return in a new table?

Motivator

Give this a try your_base_search | top limit=0 field_a | fields field_a count

top command, can be used to display the most common values of a field, along with their count and percentage.
fields command, keeps fields which you specify, in the output.

View solution in original post

Highlighted

Re: How do you count the number of unique values in a field to return in a new table?

Communicator

I completely forgot about top. This works, thanks!

0 Karma
Highlighted

Re: How do you count the number of unique values in a field to return in a new table?

Engager

This can be achieved by using a simple stats count by command

your base search | stats count by field_a
0 Karma