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!
... View more