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!
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
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
Thank you! I just had add "reverse" for ascending order: |sort -monthNum | reverse| fields - monthNum
Alternatively, you simply | sort monthNum
(without -). That'll sort in ascending order.
Thanks, yuanliu!