https://community.splunk.com/t5/Splunk-Search/sort-csv-by-current-dates/m-p/369308#M108799 <P>The sorting that you've before chart will be ineffective as chart would do it's own sorting of output which is always in ascending order, for both rows and columns. There can be different workaround that you can try, one is prefix a sequence number in date column so that when chart sorts it, it's in the order you need. </P> <P>Other workaround works if the month values that you're searching on are relative to current time OR relative to time range of the search. Is that the case?</P> Fri, 27 Apr 2018 15:17:25 GMT somesoni2 2018-04-27T15:17:25Z https://community.splunk.com/t5/Splunk-Search/sort-csv-by-current-dates/m-p/369305#M108796 <P>I want to sort out a csv but it not working </P> <P>tried<BR /> ......| fields Date,count | stats by Date,count | eval Date=strptime(Date, "%d/%m/%Y") | sort Date | eval Date=strftime(Date, "%m/%Y") | chart as total over t1 by Date </P> <P>I keep getting <BR /> 01/2018<BR /> 02/2018<BR /> 03/2018</P> <P>This is the result i am expecting <BR /> 03/2018<BR /> 02/2018<BR /> 01/2018</P> Fri, 27 Apr 2018 14:28:13 GMT https://community.splunk.com/t5/Splunk-Search/sort-csv-by-current-dates/m-p/369305#M108796 Bentash 2018-04-27T14:28:13Z https://community.splunk.com/t5/Splunk-Search/sort-csv-by-current-dates/m-p/369306#M108797 <P>Try <CODE>sort - Date</CODE></P> Fri, 27 Apr 2018 14:32:20 GMT https://community.splunk.com/t5/Splunk-Search/sort-csv-by-current-dates/m-p/369306#M108797 damien_chillet 2018-04-27T14:32:20Z https://community.splunk.com/t5/Splunk-Search/sort-csv-by-current-dates/m-p/369307#M108798 <P>To change the sort order, use <CODE>| sort -Date</CODE> to make it sort in descending order.</P> <P>PS: you might want to put the sort before replacing the Date value with a string, as sorting strings may not always result in a correct sorting of dates. Or use <CODE>fieldformat</CODE> instead of eval, such that under the hood, it keeps the numerical timestamp value and only renders it as a string.</P> Fri, 27 Apr 2018 14:33:13 GMT https://community.splunk.com/t5/Splunk-Search/sort-csv-by-current-dates/m-p/369307#M108798 FrankVl 2018-04-27T14:33:13Z https://community.splunk.com/t5/Splunk-Search/sort-csv-by-current-dates/m-p/369308#M108799 <P>The sorting that you've before chart will be ineffective as chart would do it's own sorting of output which is always in ascending order, for both rows and columns. There can be different workaround that you can try, one is prefix a sequence number in date column so that when chart sorts it, it's in the order you need. </P> <P>Other workaround works if the month values that you're searching on are relative to current time OR relative to time range of the search. Is that the case?</P> Fri, 27 Apr 2018 15:17:25 GMT https://community.splunk.com/t5/Splunk-Search/sort-csv-by-current-dates/m-p/369308#M108799 somesoni2 2018-04-27T15:17:25Z