Splunk Search

How to get top 10 stats with pivot command without using sort?

Simon
Contributor

Hi all,

How can I get a top 10 statistic with pivot? Currently I'm doing something like

| pivot MyModel MyObject count(MyObject) AS count SPLITROW myseries | sort 10 - count 

I'd like to avoid the sort somehow.

Thanks,
Simon

Tags (2)

dfigurello
Communicator

Hi Simon,

Try this search:

| pivot MyModel MyObject count(MyObject) AS count SPLITROW myseries | sort - count | head 10

tks!

bhawkins1
Communicator

I downvoted this post because doesn't answer the question at all.

0 Karma

Simon
Contributor

This is the same as my search does.
I asked if there's a way to get the top10 statistics directly with the pivot command.

0 Karma

spammenot66
Contributor

@simon what in the world are you trying to get at? Both solution seems to work when handling pivot

0 Karma
Get Updates on the Splunk Community!

Security Professional: Sharpen Your Defenses with These .conf25 Sessions

Sooooooooooo, guess what. .conf25 is almost here, and if you're on the Security Learning Path, this is your ...

First Steps with Splunk SOAR

Our first step was to gather a list of the playbooks we wanted and to sort them by priority.  Once this list ...

How To Build a Self-Service Observability Practice with Splunk Observability Cloud

If you’ve read our previous post on self-service observability, you already know what it is and why it ...