https://community.splunk.com/t5/Splunk-Search/How-to-get-top-10-stats-with-pivot-command-without-using-sort/m-p/188370#M54260 <P>Hi Simon, </P> <P>Try this search:</P> <P>| pivot MyModel MyObject count(MyObject) AS count SPLITROW myseries | sort - count | head 10 </P> <P>tks!</P> Wed, 20 Aug 2014 13:53:04 GMT dfigurello 2014-08-20T13:53:04Z https://community.splunk.com/t5/Splunk-Search/How-to-get-top-10-stats-with-pivot-command-without-using-sort/m-p/188369#M54259 <P>Hi all,</P> <P>How can I get a top 10 statistic with pivot? Currently I'm doing something like</P> <PRE><CODE>| pivot MyModel MyObject count(MyObject) AS count SPLITROW myseries | sort 10 - count </CODE></PRE> <P>I'd like to avoid the sort somehow.</P> <P>Thanks,<BR /> Simon</P> Wed, 20 Aug 2014 13:03:41 GMT https://community.splunk.com/t5/Splunk-Search/How-to-get-top-10-stats-with-pivot-command-without-using-sort/m-p/188369#M54259 Simon 2014-08-20T13:03:41Z https://community.splunk.com/t5/Splunk-Search/How-to-get-top-10-stats-with-pivot-command-without-using-sort/m-p/188370#M54260 <P>Hi Simon, </P> <P>Try this search:</P> <P>| pivot MyModel MyObject count(MyObject) AS count SPLITROW myseries | sort - count | head 10 </P> <P>tks!</P> Wed, 20 Aug 2014 13:53:04 GMT https://community.splunk.com/t5/Splunk-Search/How-to-get-top-10-stats-with-pivot-command-without-using-sort/m-p/188370#M54260 dfigurello 2014-08-20T13:53:04Z https://community.splunk.com/t5/Splunk-Search/How-to-get-top-10-stats-with-pivot-command-without-using-sort/m-p/188371#M54261 <P>This is the same as my search does. <BR /> I asked if there's a way to get the top10 statistics directly with the pivot command.</P> Wed, 20 Aug 2014 14:06:31 GMT https://community.splunk.com/t5/Splunk-Search/How-to-get-top-10-stats-with-pivot-command-without-using-sort/m-p/188371#M54261 Simon 2014-08-20T14:06:31Z https://community.splunk.com/t5/Splunk-Search/How-to-get-top-10-stats-with-pivot-command-without-using-sort/m-p/188372#M54262 <P>@simon what in the world are you trying to get at? Both solution seems to work when handling pivot </P> Wed, 16 Mar 2016 01:41:06 GMT https://community.splunk.com/t5/Splunk-Search/How-to-get-top-10-stats-with-pivot-command-without-using-sort/m-p/188372#M54262 spammenot66 2016-03-16T01:41:06Z https://community.splunk.com/t5/Splunk-Search/How-to-get-top-10-stats-with-pivot-command-without-using-sort/m-p/188373#M54263 <P>I downvoted this post because doesn't answer the question at all.</P> Tue, 08 Nov 2016 16:18:49 GMT https://community.splunk.com/t5/Splunk-Search/How-to-get-top-10-stats-with-pivot-command-without-using-sort/m-p/188373#M54263 bhawkins1 2016-11-08T16:18:49Z