Hello, Trying to get visualizations.PieChart working, but its drawing a blank white box with a title even though there is data. Here is my code.
<div id="globalramdonut" class="globalramdonut"></div> google.charts.load('current', {'packages':['corechart','gauge','line','controls','geochart']}); google.charts.setOnLoadCallback(drawAllCharts); var ramdonutdata; function setramdonutdata(){ var query = "SELECT Location, SUM(RAMCapacityGB) AS 'RAM Capacity GB' FROM clusterstat WHERE Date = (SELECT MAX(Date) FROM clusterstat) GROUP BY Location ASC"; //encode the query so we can submit it via URL. var urlencoded = encodeURI(sql2json+query); // get the data returned from 'urlencoded' var jsonData = $.ajax({ url: urlencoded, dataType: "json", async: false }).responseText; console.log(urlencoded); // assign a google DataTable object ramdonutdata = new google.visualization.DataTable(jsonData); } function drawRamDonut(){ setramdonutdata(); var options = { title: 'RAM Capacity by Location', pieHole: 0.4, sliceVisibilityThreshold: 0 }; var chart = new google.visualization.PieChart(document.getElementById('globalramdonut')); chart.draw(ramdonutdata,options); } function drawAllCharts(){ drawRamDonut(); } Here is the data returned from my PHP script.... {"cols":[{"label":"Location","type":"string"},{"label":"RAM Capacity GB","type":"number"}],"rows":[{"c":[{"v":"Amsterdam"},{"v":"12286.34"}]},{"c":[{"v":"Argentina"},{"v":"383.97"}]},{"c":[{"v":"Belgium"},{"v":"8189.33"}]},{"c":[{"v":"Brazil"},{"v":"2047.59"}]},{"c":[{"v":"California"},{"v":"14523.22"}]},{"c":[{"v":"Guadalajara"},{"v":"767.90"}]},{"c":[{"v":"Hong Kong"},{"v":"4351.54"}]},{"c":[{"v":"Massachusetts"},{"v":"3647.56"}]},{"c":[{"v":"Ontario"},{"v":"383.97"}]},{"c":[{"v":"Oregon"},{"v":"174896.81"}]},{"c":[{"v":"Shanghai"},{"v":"1279.90"}]},{"c":[{"v":"South Korea"},{"v":"383.19"}]},{"c":[{"v":"Tennessee"},{"v":"3327.52"}]},{"c":[{"v":"Texas"},{"v":"1535.64"}]},{"c":[{"v":"Tokyo"},{"v":"719.64"}]},{"c":[{"v":"Virginia"},{"v":"44882.59"}]}]} Thanks for reading. -- 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 google-visualization-api+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. 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/36be15d7-fc4f-4768-af78-9caf97a3b22e%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.