Solved the problem just had to change the dateFormat. On May 2, 11:56 am, Monty <[email protected]> wrote: > I have an array of date also i got it in json array but i want to > display both a date and time in x a axis i have modified code but do i > need to concate date and time array in javascript.below is my code. > > google.load('visualization', '1', {'packages': > ['annotatedtimeline']}); > google.setOnLoadCallback(drawChart); > > var P1data = new Array; > var P2data = new Array; > var P3data = new Array; > var P4data = new Array; > var RecordTime = new Array; > var RecordDate = new Array; > > P1data = encoded_P1data; > P2data = encoded_P2data; > P3data = encoded_P3data; > P4data = encoded_P4data; > RecordTime = encoded_xdata; > RecordDate =encoded_xDatedata; > > function drawChart() { > var data = new google.visualization.DataTable(); > > //data.addColumn('date', 'RecordDate');(confused over here ) > data.addColumn('datetime', 'RecordTime'); > data.addColumn('number', 'P1'); > data.addColumn('number', 'P2'); > data.addColumn('number', 'P3'); > data.addColumn('number', 'P4'); > > /* create for loops to add as many columns as necessary */ > > // changed because you didn't give me a jsonarray variable > //var len = jsonarray.length; > var len = RecordTime.length; > > data.addRows(len); > for (i = 0; i < len; i++) { > // we need to convert times to Date objects > var timesplit = RecordTime[i].split(':'); > var datesplit =RecordDate[i].split('-'); > data.setValue(i, 0, new Date(datesplit[2], datesplit[1], > datesplit[0], timesplit[0], timesplit[1], timesplit[2])); /* x-axis */ > data.setValue(i, 1, parseInt(P1data[i])); /* Y-axis category > #1*/ > data.setValue(i, 2, parseInt(P2data[i])); /* Y-axis category > #2*/ > data.setValue(i, 3, parseInt(P3data[i])); /* Y-axis category > #1*/ > data.setValue(i, 4, parseInt(P4data[i])); /* Y-axis category > #2*/ > } > /*********************************end of > loops***************************************/ > > // changed chart to AnnotatedTimeline > var chart = new > google.visualization.AnnotatedTimeLine(document.getElementById('chart_div') ); > chart.allowRedraw = true; > chart.draw(data, { > displayAnnotations: false, > // format time to show only hours:minutes:seconds > dateFormat: 'dd-MM-YYYY HH:mm:ss' > }); > > } > > On Apr 30, 9:18 pm, asgallant <[email protected]> wrote: > > > > > > > > > Date objects can accept time: > > > new Date(year, month, day, hours, minutes, seconds, milliseconds) > > > On Saturday, April 28, 2012 7:50:27 AM UTC-4, Monty wrote: > > > > Just wanted to ask u if i want to pass time along with date how can i > > > do so can u please do the necessary changes in code if possible. > > > > On Apr 25, 7:15 pm, asgallant <[email protected]> wrote: > > > > Ok, there are a number of issues here: > > > > > 1) type 'int' isn't valid for the DataTable columns, use 'number' > > > instead. > > > > 2) you need to parse your times into a javascript Date object. You can > > > > tell the chart to display only HH:mm:ss. > > > > 3) since your data is all strings, you need to pass it through > > > parseInt() > > > > to turn them into numbers for the chart. > > > > 4) you loaded the 'annotatedtimeline' package, but try to create a > > > > ColumnChart, which will fail. Since your post title mentions > > > > AnnotatedTimeline, I assume that is what you actually want. > > > > > I did up a fixed version you can see here:http://jsfiddle.net/ahekL/1/ > > > > > On Wednesday, April 25, 2012 1:59:26 AM UTC-4, Monty wrote: > > > > > > php array output is as follow: > > > > > Array ( [0] => 1111 [1] => 1234 [2] => 1111 [3] => 1111 [4] => 1234 > > > > > [5] => 1111 [6] => 1111 [7] => 1234 [8] => 1111 [9] => 1111 ) > > > > > Array ( [0] => 2222 [1] => 2345 [2] => 2222 [3] => 2222 [4] => 2345 > > > > > [5] => 2222 [6] => 2222 [7] => 2345 [8] => 2222 [9] => 2222 ) > > > > > Array ( [0] => 3333 [1] => 3456 [2] => 3333 [3] => 3333 [4] => 3456 > > > > > [5] => 3333 [6] => 3333 [7] => 3456 [8] => 3333 [9] => 3333 ) > > > > > Array ( [0] => 4444 [1] => 4567 [2] => 4444 [3] => 4444 [4] => 4567 > > > > > [5] => 4444 [6] => 4444 [7] => 4567 [8] => 4444 [9] => 4444 ) > > > > > Array ( [0] => 10:20:00 [1] => 10:20:00 [2] => 10:20:00 [3] => > > > > > 10:20:00 [4] => 10:20:00 [5] => 10:20:00 [6] => 10:20:00 [7] => > > > > > 10:20:00 [8] => 10:20:00 [9] => 10:20:00 ) > > > > > > output of json_encodeon arrays : > > > > > var encoded_P1data > > > > =["1111","1234","1111","1111","1234","1111","1111","1234","1111","1111"]; > > > > > var encoded_P2data = > > > > ["2222","2345","2222","2222","2345","2222","2222","2345","2222","2222"]; > > > > > var encoded_P3data = > > > > ["3333","3456","3333","3333","3456","3333","3333","3456","3333","3333"]; > > > > > var encoded_P4data = > > > > ["4444","4567","4444","4444","4567","4444","4444","4567","4444","4444"]; > > > > > var encoded_xdata = > > > > ["10:20:00","10:20:00","10:20:00","10:20:00","10:20:00","10:20:00","10:20:0 > > > 0","10:20:00","10:20:00","10:20:00"];
-- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
