How to convert json string to google.visualization.DataTable?

Question

I get json string from response. How can I create a data table from this?

eg.

var jasonString = ".........."; var data = new google.visualization.DataTable(jasonString); 

Answer 1

You can use the arrayToDataTable function

 var jsonString = ".........."; // json string of array var array = JSON.parse(jsonString); var dataTableData = google.visualization.arrayToDataTable(array); // use dataTableData to build dataTable 

Answer 2

According to this page , it says you can simply postpone the JSON response right in google.visualization.DataTable

 var data = new google.visualization.DataTable(jsonData); 

Answer 3

You can do:

 google.charts.load('current', { 'packages': ['line'] }); google.charts.setOnLoadCallback(drawChart); function drawChart() { var json = $.ajax({ url: "GetFaturamentoMes", dataType: "json", success: function (jsonData) { var data = new google.visualization.DataTable(); data.addColumn('number', 'Mês'); data.addColumn('number', 'Faturamento Por Mês'); for (var i = 0; i < jsonData.length; i++) { mes = jsonData[i].Mes; total = jsonData[i].Total; data.addRow([mes, total]); } var options = { chart: { title: 'Gráfico de Faturamento Mensal', subtitle: 'Moeda (R$)' }, width: 600, height: 300, axes: { x: { 10: { side: 'top' } } } }; var chart = new google.charts.Line(document.getElementById('line_top_x')); chart.draw(data, google.charts.Line.convertOptions(options)); } }); }