Sort order

[kicchu465]

Hi all,

i  want to sort the  bar chart  order by yearmonth

2011-mar

2012-apr

2013-may

2014-jun

i want above order   ,but now its giving mix order

how can i achieve this?

[sunny_talwar]

Fix this in the script by helpful read your yearmonth field as a date field which has an underlying numeric value. Once you do this, you will be able to sort it numerically

LOAD Date(MonthStart(yearmonth, 'YYYY-MMM')), 'YYYY-MMM') as yearmonth