https://community.splunk.com/t5/Splunk-Search/How-to-tell-the-sort-command-to-sort-by-numerical-order-instead/m-p/67303#M16828 <P>Hi , </P> <P>Hope you have got answer by now for this issue <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> </P> <P>I came across this same issue today and got solution for it , Hence posting so that it can help others similar issue . </P> <P>This sort is not going to work if you use stats , timechart , <BR /> use chart instead , Both fields and sort will work seamlessly.</P> <P>Thanks,<BR /> Razal </P> Wed, 12 Mar 2014 04:59:51 GMT russel_mohammed 2014-03-12T04:59:51Z https://community.splunk.com/t5/Splunk-Search/How-to-tell-the-sort-command-to-sort-by-numerical-order-instead/m-p/67300#M16825 <P>I want the series to sort as 1,2,3,10,11,12 not 1,10,11,12,2,3. The sort functions do not seem to have any effect when used in this context:</P> <P>... | sort -num(myfield)</P> <P>I don't see any examples of using the sort functions in the documentation or other questions. <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P> <P>I have also tried:</P> <P>... | sort by num(myfield)<BR /><BR /> ... | sort num(myfield)</P> <P>Halp!</P> Tue, 30 Aug 2011 22:09:19 GMT https://community.splunk.com/t5/Splunk-Search/How-to-tell-the-sort-command-to-sort-by-numerical-order-instead/m-p/67300#M16825 hulahoop 2011-08-30T22:09:19Z https://community.splunk.com/t5/Splunk-Search/How-to-tell-the-sort-command-to-sort-by-numerical-order-instead/m-p/67301#M16826 <P>i'm not sure why this isn't working for you. it seems to be fine for me...</P> <PRE><CODE>... | sort +|- num(&lt;numeric field&gt;) </CODE></PRE> <P>did you have a particular search/example that wasn't working? i can help you with that and perhaps add that as an example to the topic. thanks.</P> Tue, 30 Aug 2011 23:29:31 GMT https://community.splunk.com/t5/Splunk-Search/How-to-tell-the-sort-command-to-sort-by-numerical-order-instead/m-p/67301#M16826 sophy 2011-08-30T23:29:31Z https://community.splunk.com/t5/Splunk-Search/How-to-tell-the-sort-command-to-sort-by-numerical-order-instead/m-p/67302#M16827 <P>You can also use the fields command to specify the fields.</P> <P>| fields "column1" col2 col3 col4</P> Wed, 27 Jun 2012 07:23:18 GMT https://community.splunk.com/t5/Splunk-Search/How-to-tell-the-sort-command-to-sort-by-numerical-order-instead/m-p/67302#M16827 brettcave 2012-06-27T07:23:18Z https://community.splunk.com/t5/Splunk-Search/How-to-tell-the-sort-command-to-sort-by-numerical-order-instead/m-p/67303#M16828 <P>Hi , </P> <P>Hope you have got answer by now for this issue <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> </P> <P>I came across this same issue today and got solution for it , Hence posting so that it can help others similar issue . </P> <P>This sort is not going to work if you use stats , timechart , <BR /> use chart instead , Both fields and sort will work seamlessly.</P> <P>Thanks,<BR /> Razal </P> Wed, 12 Mar 2014 04:59:51 GMT https://community.splunk.com/t5/Splunk-Search/How-to-tell-the-sort-command-to-sort-by-numerical-order-instead/m-p/67303#M16828 russel_mohammed 2014-03-12T04:59:51Z https://community.splunk.com/t5/Splunk-Search/How-to-tell-the-sort-command-to-sort-by-numerical-order-instead/m-p/67304#M16829 <P>I was able to use the convert num(string) which converts the given value to a number and then use the sort command on this </P> <BLOCKQUOTE> <P><CODE>somesearch that generates the stats name ,myEventCount |convert num(myEventCount) as nummyEventCount|sort -nummyEventCount|table name nummyEventCount</CODE></P> </BLOCKQUOTE> Sun, 08 May 2016 05:36:55 GMT https://community.splunk.com/t5/Splunk-Search/How-to-tell-the-sort-command-to-sort-by-numerical-order-instead/m-p/67304#M16829 sunilsk1 2016-05-08T05:36:55Z