Monday, June 3, 2024
 Popular · Latest · Hot · Upcoming
174
rated 0 times [  180] [ 6]  / answers: 1 / hits: 16971  / 11 Years ago, wed, october 16, 2013, 12:00:00

I have a php script that generates the google chart data and returns it in json encoded format. It's loaded into google chart using jQuery $.get() method. When I pass the return data to the google arrayToDataTable function like this:



var googleChartData = google.visualization.arrayToDataTable(chartData);


I get this error:



enter



So, what I did was I dumped the value of my variable chartData and I got the following:



enter



So, what I did was, copy this data from console window into the arrayToDataTable function manually like this:



var googleChartData = google.visualization.arrayToDataTable([[Date Range,0001/102/0 Available,0001/102/0 Unavailable,0001/102/1 Available,0001/102/1 Unavailable],[02/10/2013,0,1,110,11],[03/10/2013,0,1,189,11],[04/10/2013,0,1,189,11],[06/10/2013,0,1,189,10],[07/10/2013,0,1,187,10],[08/10/2013,186,11,0,1],[09/10/2013,186,11,0,1],[10/10/2013,0,1,186,11],[11/10/2013,0,1,204,11],[13/10/2013,0,1,204,11]]);


Now the chart renders (as expected, because the returned data from my php script is correct):



enter



This is a bit bizarre; does any one know why the chart doesn't work when it's loaded from the variable?


More From » php

 Answers
22

I've solved it by changing arrayToDataTable line like this:



var googleChartData = google.visualization.arrayToDataTable($.parseJSON(chartData));


Thanks to this post: https://stackoverflow.com/a/9420583/2332336


[#74954] Tuesday, October 15, 2013, 11 Years  [reply] [flag answer]
Only authorized users can answer the question. Please sign in first, or register a free account.
jonathoncamrynv

Total Points: 339
Total Questions: 98
Total Answers: 98

Location: Saint Vincent and the Grenadines
Member since Thu, Oct 15, 2020
4 Years ago
;