How to chart months on the X-axis in chronological order, not alphabetical?

[hkosuru]

Hi,

My database query returns the following columns
monthNum,month,year,value
01, Jan, 2014, 20
01, Jan, 2015, 30
02, Feb, 2014, 40
02, Feb, 2015, 34
...
When I plot the chart with this data

|sort -monthNum| chart max(value) by month,year

I get months in alphabetical order on the X-axis. "sort -monthNum" does not seem to do anything. I want to see Calendar order- Jan, Feb, Mar

I don't want to prepend numbers to months like 1-Jan,2-Feb,3-Mar...

Thanks!

[somesoni2 · Accepted solution]

How about this

your base db search... | eval month=monthNum."-".month | chart max(value) by month,year | rex field=month "(?<monthNum>\d+)-(?<month>.*)" |sort -monthNum | fields - monthNum

[hkosuru]

Thank you! I just had add "reverse" for ascending order: |sort -monthNum | reverse| fields - monthNum

[yuanliu]

Alternatively, you simply | sort monthNum (without -). That'll sort in ascending order.

[hkosuru]

Thanks, yuanliu!