Yes, you should be able to hook up data from SQLserver to the chart. You have to have a script on your webserver that can query the database and output the data in the required format. There are libraries available to help you do that in Java<https://developers.google.com/chart/interactive/docs/dev/dsl_intro>, Python<https://developers.google.com/chart/interactive/docs/dev/gviz_api_lib>, PHP <http://code.google.com/p/mc-goog-visualization/wiki/UserDocumentation>, and .Net<http://code.google.com/p/bortosky-google-visualization/wiki/ReadMe>; depending on what scripting language you prefer on your server.
On Thursday, January 17, 2013 9:11:38 AM UTC-5, Bhoomi Gajjar wrote: > > Hi, > > Thank you very much for your help. I am wondering is it possible to bind > data from sql server to this motionchart, If you can provide me some > examples for the same. > > Thanks, > Bhoomi > > On Wednesday, 16 January 2013 23:11:02 UTC+5:30, asgallant wrote: >> >> The motionchart's don't have a select event to fire, so you have to tease >> out the information you want from the statechange event. Here's an example >> based on your code: http://jsfiddle.net/asgallant/DunKF/ >> >> On Wednesday, January 16, 2013 5:06:00 AM UTC-5, Bhoomi Gajjar wrote: >>> >>> Hi, >>> >>> I am new to Google APIs. I would like to get details of selected objects >>> on motionchart. I tried getstate() method. but I am not able to get any >>> data. below is my code >>> >>> <html> >>> <head> >>> <script type="text/javascript" src="http://www.google.com/jsapi >>> "></script> >>> <script type="text/javascript"> >>> google.load('visualization', '1', { 'packages': ['motionchart'] >>> }); >>> google.setOnLoadCallback(drawChart); >>> // The select handler. Call the chart's getSelection() method >>> >>> >>> function onstatechange() { >>> alert("chart state changed"); >>> >>> }; >>> >>> >>> function drawChart() { >>> var data = new google.visualization.DataTable(); >>> data.addColumn('string', 'Fruit'); >>> data.addColumn('date', 'Date'); >>> data.addColumn('number', 'Sales'); >>> data.addColumn('number', 'Expenses'); >>> data.addColumn('string', 'Location'); >>> data.addRows([ >>> ['Apples', new Date(1988, 0, 1), 1000, 300, 'East'], >>> ['Oranges', new Date(1988, 0, 1), 1150, 200, 'West'], >>> ['Bananas', new Date(1988, 0, 1), 300, 250, 'West'], >>> ['Apples', new Date(1989, 6, 1), 1200, 400, 'East'], >>> ['Oranges', new Date(1989, 6, 1), 750, 150, 'West'], >>> ['Bananas', new Date(1989, 6, 1), 788, 617, 'West'] >>> ]); >>> var chart = new >>> google.visualization.MotionChart(document.getElementById('chart_div')); >>> // google.visualization.events.addListener(chart, >>> 'statechange', onstatechange()); >>> chart.draw(data, { width: 600, height: 300 }); >>> // alert(chart.getState()); >>> >>> google.visualization.events.addListener(chart, 'select', >>> function () { >>> var row = chart.getSelection()[0].row; >>> var state = data.getValue(row, 0); >>> var rows = tableData.getFilteredRows([{column: 0, value: state}]); >>> tableView.setRows(rows); >>> table.draw(tableView, options); >>> }); >>> >>> } >>> >>> </script> >>> </head> >>> >>> <body> >>> <div id="chart_div" style="width: 600px; height: 300px;"></div> >>> </body> >>> </html> >>> >>> Thanks, >>> Bhoomi Gajjar >>> >> -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To view this discussion on the web visit https://groups.google.com/d/msg/google-visualization-api/-/sJYFDrVXGn8J. 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.
