Google visualization data grouping on String column

Question

DB Table Structure

data_MONTHMONTHTEST = new google.visualization.DataTable();

data_MONTHMONTHTEST.addColumn('number','id');//0
data_MONTHMONTHTEST.addColumn('string','month');//1
data_MONTHMONTHTEST.addColumn('number','revenue');//2

var aggView_MONTHMONTHTEST_month =google.visualization.data.group(data_MONTHMONTHTEST, [1],[{'column':2, 'aggregation':google.visualization.data.sum, 'type': 'number',label:'revenue'}]);


barChart_MONTHMONTHTEST_month = new google.visualization.ChartWrapper(
{
    'chartType':'BarChart',
    'containerId': 'chart_div_bar_MONTHMONTHTEST0',
    'options': barOptions_MONTHMONTHTEST_month ,
     dataTable:  aggView_MONTHMONTHTEST_month 
});             

When Am drawing the chart month column values are not getting preserved. Rather it is drwing the chart based on alphabet order.

I've tried sort:disabled as part of options list,but no luck.

Can someone suggest how to preserve months order.

Thanks in Advance..!!

Answer 1

We can disable the sort using column index following: After a day research I found an option to disable the column sorting

var aggView_MONTHMONTHTEST_month =    google.visualization.data.group(data_MONTHMONTHTEST123, [1],[{'column':2, 'aggregation':google.visualization.data.sum, 'type': 'number',label:'revenue'}]);                   

aggView_MONTHMONTHTEST_month.sort({column: 1, sort: 'disable'});