Muchas gracias Carlos
en realidad estoy un poco mas atras, yo geenero un json de la db con esta
estructura
[{"sede":"AREQUIPA","sema":"1","tfre":"0","tapli":"0"},{"sede":"CAJAMARCA","sema":"1","tfre":"0","tapli":"0"},{"sede":"CALLAO","sema":"1","tfre":"0","tapli":"0"},{"sede":"CHICLAYO","sema":"1","tfre":"0","tapli":"0"},{"sede":"CORONEL
PORTILLO-PUCALLPA","sema":"1","tfre":"0","tapli":"0"}]
y quiero mostrar un grafico de columnas agrupadas y no se como hacer para
pasar el json al chart
saludos
El jueves, 16 de agosto de 2018, 11:27:29 (UTC-5), carlos nicho escribió:
>
> aca tienes un ejemplo como tienes que ponerlo te recomiendo hacer un
> parseFloat a los datos que son number y poner unas comillas ""
> cuando el dato sea un string.
>
> for(var m=0; m < tama; m++){
> data.addRows([
> [""+fecha[m], parseFloat(datos1[m]), parseFloat(adatos1[m])],
> ]);
> }
>
> El domingo, 12 de agosto de 2018, 22:37:21 (UTC-5), schuiky escribió:
>>
>> Buenas noches, estoy tratando de mostrar un grafico de barras, con el
>> siguiente codigo
>>
>> <html>
>> <head>
>> <script type="text/javascript" src="
>> https://www.gstatic.com/charts/loader.js";></script>
>> <script type="text/javascript" src="
>> https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js
>> "></script>
>> <script type="text/javascript">
>> google.charts.load('current', {'packages':['corechart']});
>> google.charts.setOnLoadCallback(drawChart);
>> function drawChart() {
>> var jsonData = $.ajax({
>> url: "prueba.php",
>> dataType: "json"
>> }).responseText;
>> var data = new google.visualization.DataTable();
>> data.addColumn('string', 'sede');
>> data.addColumn('number', 'sema');
>> data.addColumn('number', 'tfre');
>> data.addColumn('number', 'tapli');
>> for (var i = 0; i < jsonData.length; i++) {
>> var sede = jsonData[i].['sede'];
>> var sema = jsonData[i].['sema'];
>> var tfre = jsonData[i].['tfre'];
>> var tapli = jsonData[i].['tapli'];
>> data.addRow([sede, sema, tfre, tapli]); <!-- Codificamos
>> las tres variables en una fila-->
>> };
>> var chart = new
>> google.visualization.ColumnChart(document.getElementById('chart_div'));
>> chart.draw(data, {width: 400, height: 240});
>> }
>> </script>
>> </head>
>> <body>
>> <div id="chart_div"></div>
>> </body>
>> </html>
>>
>> el archivo prueba.php genera este json
>>
>> [{"sede":"AREQUIPA","sema":"1","tfre":"0","tapli":"0"},{"sede":"CAJAMARCA","sema":"1","tfre":"0","tapli":"0"},{"sede":"CALLAO","sema":"1","tfre":"0","tapli":"0"},{"sede":"CHICLAYO","sema":"1","tfre":"0","tapli":"0"},{"sede":"CORONEL
>> PORTILLO-PUCALLPA","sema":"1","tfre":"0","tapli":"0"}]
>>
>>
>> Alguien que me ayude con esto por favor
>>
>>
>>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-visualization-api/8d2c842d-d92a-4a80-9454-0e3963318c37%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
