topic Re: Display only the top 5 values in count column in Splunk Search https://community.splunk.com/t5/Splunk-Search/Display-only-the-top-5-values-in-count-column/m-p/518656#M145935 <LI-CODE lang="markup">| fields - Total</LI-CODE> Wed, 09 Sep 2020 11:47:08 GMT ITWhisperer 2020-09-09T11:47:08Z Display only the top 5 values in count column https://community.splunk.com/t5/Splunk-Search/Display-only-the-top-5-values-in-count-column/m-p/518575#M145891 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sphiwee_1-1599604516265.png" style="width: 400px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/10735iB33426C4EF172EFC/image-size/medium?v=v2&amp;px=400" role="button" title="sphiwee_1-1599604516265.png" alt="sphiwee_1-1599604516265.png" /></span></P><P>Id like to be able to display only the top Total values, struggling with this</P> Tue, 08 Sep 2020 22:36:23 GMT https://community.splunk.com/t5/Splunk-Search/Display-only-the-top-5-values-in-count-column/m-p/518575#M145891 sphiwee 2020-09-08T22:36:23Z Re: Display only the top 5 values in count column https://community.splunk.com/t5/Splunk-Search/Display-only-the-top-5-values-in-count-column/m-p/518576#M145892 <P>|&nbsp; head 5</P> Tue, 08 Sep 2020 22:39:52 GMT https://community.splunk.com/t5/Splunk-Search/Display-only-the-top-5-values-in-count-column/m-p/518576#M145892 ITWhisperer 2020-09-08T22:39:52Z Re: Display only the top 5 values in count column https://community.splunk.com/t5/Splunk-Search/Display-only-the-top-5-values-in-count-column/m-p/518581#M145908 <P>just adding "| head 5" will keep the top five values of whatever column the results are sorted on. In his screenshot that appears to be host.&nbsp;<BR />To keep the top 5 Total do, "|sort - Total |head 5"</P> Wed, 09 Sep 2020 00:55:40 GMT https://community.splunk.com/t5/Splunk-Search/Display-only-the-top-5-values-in-count-column/m-p/518581#M145908 anthonymelita 2020-09-09T00:55:40Z Re: Display only the top 5 values in count column https://community.splunk.com/t5/Splunk-Search/Display-only-the-top-5-values-in-count-column/m-p/518653#M145934 <P>Is it possible to hide the total column?</P> Wed, 09 Sep 2020 11:39:23 GMT https://community.splunk.com/t5/Splunk-Search/Display-only-the-top-5-values-in-count-column/m-p/518653#M145934 sphiwee 2020-09-09T11:39:23Z Re: Display only the top 5 values in count column https://community.splunk.com/t5/Splunk-Search/Display-only-the-top-5-values-in-count-column/m-p/518656#M145935 <LI-CODE lang="markup">| fields - Total</LI-CODE> Wed, 09 Sep 2020 11:47:08 GMT https://community.splunk.com/t5/Splunk-Search/Display-only-the-top-5-values-in-count-column/m-p/518656#M145935 ITWhisperer 2020-09-09T11:47:08Z