Dashboards & Visualizations

how to sort the date in chronological order by day-month-year?

vvemula
Path Finder

Hi Guys,

I need a help in sort the date,  

Month_Value
27-Aug-20
17-jul-20
4-sep-20
30-jul-20
16-jul-20

I have sort then in sorting order as mentioned in the below,

Month_Value
16-jul-20
17-jul-20
30-jul-20
27-Aug-20
4-sep-20.

Can someone please help me here. I have check some solutions and tried, but nothing seems to works. Thank you in advance

Labels (1)
0 Karma

niketn
Legend

@vvemula Actual answer will depend on your current SPL and how you are coming to the Time field, what is its use case? Why it can't be YYYY-mm-dd format.

One of the options would be to use fieldformat to format Time instead of eval. So that original time remains epoch.

| table _time
| fieldformat _time=strftime(_time,"%d-%b-%y")
| sort _time

 Following is a run anywhere example:

| makeresults
| fields - _time
| eval data="27-Aug-20,17-jul-20,4-sep-20,30-jul-20,16-jul-20"
| makemv data delim=","
| mvexpand data
| eval _time=strptime(data,"%d-%b-%y")
| table _time
| fieldformat _time=strftime(_time,"%d-%b-%y")
| sort _time
____________________________________________
| makeresults | eval message= "Happy Splunking!!!"

isoutamo
SplunkTrust
SplunkTrust
You could convert date to epoch in additional field, sort with it and then remove that field.
r. Ismo
0 Karma
Get Updates on the Splunk Community!

Observability Highlights | November 2022 Newsletter

 November 2022Observability CloudEnd Of Support Extension for SignalFx Smart AgentSplunk is extending the End ...

Avoid Certificate Expiry Issues in Splunk Enterprise with Certificate Assist

This blog post is part 2 of 4 of a series on Splunk Assist. Click the links below to see the other ...

Using Machine Learning for Hunting Security Threats

REGISTER NOW Seeing the exponential hike in global cyber threat spectrum, organizations are now striving more ...