Archive

Show All the Results within the Field

New Member

I want to show all the results within the field itself as I do not want it just show the top 10 limits from the list. I would like to see the result that lowest number of results. Is there a command out there that can show you unlimited results?

0 Karma

Builder

The values and list functions of the stats command in a search might be what you're looking for based on your question, but I agree with the person above that we likely need a bit more information to adequately answer your question. If you want to try running a search, something like this might be it:

your initial search...
| stats values(field) as uniqueValuesFromField, list(field) as listOfValuesFromField by whateverGroupByYouWantOrNone

another interpretation of your question: you want to see the result with the lowest count:

your initial search...
| stats count by field

Let me know if either of these help!

EDIT -- Using stats with the min function seemed to work here

0 Karma

Path Finder

Keldrig2, What search are you running?

And are you wanting to see the values from the field based on the interesting fields or are you okay with looking at all the results in a table format?

0 Karma

New Member

I am searching for a eventtype in looking for the lowest values. I do want to see the field based from the interesting fields.

0 Karma

Builder

Try using the min function in a stats command then?

0 Karma

New Member

Yes, that help me out.

0 Karma