i returning data chart using json. i've managed format date x-axiz of line chart, using;
var options = { haxis: { format: ' dd mmm yy' }, }
but need doing same table chart 1 of columns should of date format.
at moment displaying "/date(1372761341103)/" how format option? understand it, "options" variable setting not available table chart. also, when add columns, setting 'date' column's data type 'date' doesn't work...no chart returned.
this code currently:
function drawchart3() { $.get('/mymall/getadrundata', {}, function (data) { /* add data */ var tdata = new google.visualization.datatable() tdata.addcolumn('number', 'id'); tdata.addcolumn('string','date'); tdata.addcolumn('number', 'opens'); (var = 0; < data.length; i++) { tdata.addrow([data[i].id, data[i].date, data[i].opens]); } /* draw chart */ var chart = new google.visualization.table(document.getelementbyid('chart_adrun')); //var formatter = new google.visualization.colorformat(); //var monthyearformatter = new google.visualization.dateformat({ pattern: "mmm yyyy" }); monthyearformatter.format(tdata, 0); formatter.addrange(-1, 1, 'white', 'orange'); formatter.addrange(0, 2, 'red', '#33ff33'); formatter.addrange(1, 10, 'red', 'pink'); formatter.format(tdata, 1); // apply formatter second column chart.draw(tdata, { allowhtml: true, showrownumber: false }); } ) }
i solved way...
(var = 0; < data.length; i++) { var date = new date(parseint(data[i].date.substr(6))); tdata.addrow([data[i].id, date, data[i].opens]); }
Comments
Post a Comment