wrb

The erro Javascript. Almost there, but miss rendereizar the chart. Below return code. Any suggestions? 9/2/2014 1.340 9/6/2014 1.450 9/8/2014 1.540 9/17/2014 1.750 9/24/2014 1.960 10/2/2014 2.140 10/3/2014 2.220 10/10/2014 2.410 10/17/2014 2.560 10/24/2014 2.780 <script type="text/javascript" src="https://www.google.com/jsapi"></script> <script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script> <script> function ToJavaScriptDate(value) { var pattern = /Date(([^)]+))/; var results = pattern.exec(value); var dt = new Date(parseFloat(results[1])); return (dt.getMonth() + 1) + "/" + dt.getDate() + "/" + dt.getFullYear(); } </script> <!-- Script--> <script type="text/javascript"> google.load('visualization', '1.1', { 'packages': ['corechart'] }); google.setOnLoadCallback(drawChart); function drawChart() { $.get('/Programa_Nutricao/Avaliacao/EvolucaoPeso', {}, function (data) { var tdata = new google.visualization.DataTable(); tdata.addColumn('date', 'data_semanal'); tdata.addColumn('number', 'peso_kg'); for (var i = 0; i < data.length; i++) { if (data.data_semanal != null) tdata.addRow(ToJavaScriptDate[data.data_semanal],data.peso_kg); console.log(ToJavaScriptDate(data.data_semanal),data.peso_kg); } var options = { vAxis: { title: "PESO", minValue: 1, maxValue: 6 }, hAxis: { title: "DATA", textStyle: { fontSize: 10 }}, legend: { position: "none" } }; var chart = new google.visualization.LineChart(document.getElementById('EvolucaoPeso')); chart.draw(tdata, options); }); } </script>

The database is SQLServer. The data_semanal field is date and the peso_kg is int. The error appears on the console CHROME browser. The problem is in Json.NET format, but do not know how to implement this conversion.

Changed the return, but with error: "Uncaught Error: Type mismatch. Value 3/8/2014 does not match type date in column index 0" <script> function ToJavaScriptDate(value) { var pattern = /Date(([^)]+))/; var results = pattern.exec(value); var dt = new Date(parseFloat(results[1])); return (dt.getDate() + 1) + "/" + dt.getMonth() + "/" + dt.getFullYear(); } </script> <!-- Script--> <script type="text/javascript"> google.load('visualization', '1.1', { 'packages': ['corechart'] }); google.setOnLoadCallback(drawChart); function drawChart() { $.get('/Programa_Nutricao/Avaliacao/EvolucaoPeso', {}, function (data) { var tdata = new google.visualization.DataTable(); tdata.addColumn('date', 'data_semanal'); tdata.addColumn('number', 'peso_kg'); for (var i = 0; i < data.length; i++) { if (data.data_semanal != null) tdata.addRow([ToJavaScriptDate(data.data_semanal), data.peso_kg]); } var options = { vAxis: { title: "PESO", minValue: 1 }, hAxis: { title: "DATA", textStyle: { fontSize: 10 }}, legend: { position: "none" } }; var chart = new google.visualization.LineChart(document.getElementById('EvolucaoPeso')); chart.draw(tdata, options); }); } </script>

Would have an example? I'm not succeeding.

Sorry, but I do not understand how.

How to fix this return / Date ()? Uncaught Error: Type mismatch. Value /Date(1409626800000)/ does not match type date in column index 0 <script type="text/javascript"> google.load('visualization', '1', { 'packages': ['corechart'] }); google.setOnLoadCallback(drawChart); function drawChart() { $.get('/Programa_Nutricao/Avaliacao/EvolucaoPeso', {}, function (data) { var tdata = new google.visualization.DataTable(); tdata.addColumn('date', 'data_semanal'); tdata.addColumn('number', 'peso_kg'); for (var i = 0; i < data.length; i++) { if (data.data_semanal != null) tdata.addRow([data.data_semanal, data.peso_kg]); } function ToJavaScriptDate(value) { var pattern = /Date(([^)]+))/; var results = pattern.exec(value); var dt = new Date(parseFloat(results[1])); return (dt.getMonth() + 1) + "/" + dt.getDate() + "/" + dt.getFullYear(); } console.log(data); var options = { vAxis: { title: "PESO", minValue: 1 }, hAxis: { title: "DATA", textStyle: { fontSize: 10 } }, legend: { position: "none" }, async: true }; var chart = new google.visualization.LineChart(document.getElementById('EvolucaoPeso')); chart.draw(tdata, options); }); } </script>

Use String.replace to generate a data value from a string Trying the code below, but without success: "Uncaught ReferenceError: stringDataValue is not defined" for (var i = 0; i < data.length; i++) { if (data.data_semanal != null) tdata.addRow([new Date(parseInt(stringDataValue.replace("/Date(", "").replace(")/", ""), 10)).data.data_semanal, data.peso_kg]); } How should I be dealing with dates so they are returned in the format I require? Or how do I handle this format above in script?

Trying the code below, but without success. " Uncaught Error: Type mismatch. Value 1.340 does not match type number in column index 1" <script type="text/javascript"> google.load('visualization', '1', { 'packages': ['corechart'] }); google.setOnLoadCallback(drawChart); function drawChart() { $.get('/Programa_Nutricao/Avaliacao/EvolucaoPeso', {}, function (data) { var tdata = new google.visualization.DataTable(); tdata.addColumn('string', 'data_semanal'); tdata.addColumn('number', 'peso_kg'); console.log(data); for (var i = 0; i < data.length; i++) { if (data.data_semanal != null) tdata.addRow([data.data_semanal, data.peso_kg]); } var view = new google.visualization.DataView(tdata); view.setColumns([{ type: 'date', calc: function (dt, row) { var stringDateValue = dt.getValue(row, 0); var number = parseInt(/Date((d+))/.exec(stringDateValue)[1]); return new Date(number); } }, 1]) var options = { //title: "EVOLUÇÃO DE PESO EM KG POR DATA", vAxis: { title: "PESO", minValue: 1 }, hAxis: { title: "DATA", textStyle: { fontSize: 10 } }, legend: { position: "none" }, async: true }; var chart = new google.visualization.LineChart(document.getElementById('EvolucaoPeso')); chart.draw(view, options); }); } </script>

Hello, Does anyone have any suggestions for error correction? FROM: 0: Object data_semanal: "/Date(1409626800000)/" peso_kg: "1.340 " TO: 0: Object data_semanal: "1409626800000" peso_kg: "1.340 Controller: public ActionResult EvolucaoPeso() { var dia = db.spPesoEvolucao().ToArray(); var a = dia.Select(x => new { x.data_semanal, x.peso_kg }); return Json(a, JsonRequestBehavior.AllowGet); } Index: <script type="text/javascript" src="https://www.google.com/jsapi"></script> <script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script> <!-- Script--> <script type="text/javascript"> google.load('visualization', '1', { 'packages': ['corechart'] }); google.setOnLoadCallback(drawChart); function drawChart() { $.get('/Programa_Nutricao/Avaliacao/EvolucaoPeso', {}, function (data) { var tdata = new google.visualization.DataTable(); tdata.addColumn('date', 'data_semanal'); tdata.addColumn('number', 'peso_kg'); console.log(data); for (var i = 0; i < data.length; i++) { if (data.data_semanal != null) tdata.addRow([data.data_semanal, data.peso_kg]); } var options = { //title: "EVOLUÇÃO DE PESO EM KG POR DATA", vAxis: { title: "PESO", minValue: 1 }, hAxis: { title: "DATA", textStyle: { fontSize: 10 } }, legend: { position: "none" }, async: true }; var chart = new google.visualization.LineChart(document.getElementById('EvolucaoPeso')); chart.draw(tdata, options); }); } </script> <body> <!-- Título da página --> <div id="EvolucaoPeso" style="width: 900px; height: 500px;"></div> </body>