Hi asgallant... i was wondering if you could help me, i have the grapgh working fine showing one bar per x axis data, what i need now is to use a bar chart to show two or more bars per each x axis data, not stacked but side by side like when you group, see (https://developers.google.com/chart/interactive/docs/gallery/barchart?hl=es ) ... can i do it following this same example? if so , how do i retrieve and add the other data to the code?
On Wednesday, December 12, 2012 3:51:13 PM UTC-6, Ian Haylock wrote: > > it worked !!!!!!! cant say thank you enough..... i wish there were more > people like you. > > On Wednesday, December 12, 2012 3:39:22 PM UTC-6, asgallant wrote: > > You have a couple of unnecessary lines in your javascript: > > alert(typeof(jsonData)); > console.log(jsonData); > > The first is what pops up that message. The second is dumping the > contents of the json to the developers console - this will cause the script > to bomb in older versions of IE, as they don't have a console object. > Delete or comment these two lines and you should be fine. > > On Wednesday, December 12, 2012 4:24:30 PM UTC-5, Ian Haylock wrote: > > > <https://lh4.googleusercontent.com/-sbGpcUatdqI/UMj1-PVHiqI/AAAAAAAAALM/1muCotW-3_0/s1600/string.png> > json generated: > > {"cols":[{"label":"planta","type":"string"},{"label":"capacidad en > MW","type":"number"}],"rows":[{"c":[{"v":"Francisco > Morazan"},{"v":300}]},{"c":[{"v":"Lufussa > III"},{"v":267.4}]},{"c":[{"v":"Enersa"},{"v":259}]},{"c":[{"v":"EEHSA - > Mesoamerica"},{"v":102}]},{"c":[{"v":"Elcosa"},{"v":80}]},{"c":[{"v":"Lufussa > II"},{"v":80}]},{"c":[{"v":"Rio Lindo"},{"v":80}]},{"c":[{"v":"Emce > Choloma"},{"v":55}]},{"c":[{"v":"Lufussa I"},{"v":40}]},{"c":[{"v":"Enersa > (excedente de 30 > MW)"},{"v":30}]},{"c":[{"v":"Nacaome"},{"v":30}]},{"c":[{"v":"Ca\u00f1averal"},{"v":29}]},{"c":[{"v":"La > > Ceiba"},{"v":26}]},{"c":[{"v":"La Grecia - > Celsur"},{"v":25.5}]},{"c":[{"v":"Cahsa - Azucarera > Hondure\u00f1a"},{"v":25}]},{"c":[{"v":"El > Nispero"},{"v":22.5}]},{"c":[{"v":"Envasa"},{"v":21}]},{"c":[{"v":"Elcatex"},{"v":21}]},{"c":[{"v":"Chumbagua"},{"v":20}]},{"c":[{"v":"Nacional > > de Ingenieros"},{"v":20}]},{"c":[{"v":"La Puerta MEX - > Hitachi"},{"v":18}]},{"c":[{"v":"Celsur"},{"v":18}]},{"c":[{"v":"La Puerta > ENEE- General Electric"},{"v":15}]},{"c":[{"v":"CISA - La > Esperanza"},{"v":12.7}]},{"c":[{"v":"Cuyamapa"},{"v":12.2}]},{"c":[{"v":"Ampac > > (American Pacific)"},{"v":10.1}]},{"c":[{"v":"Azunosa ( IHSA > )"},{"v":10}]},{"c":[{"v":"Geen Valley - Park > Dale"},{"v":10}]},{"c":[{"v":"AYSA"},{"v":8}]},{"c":[{"v":"Cuyamel"},{"v":8}]},{"c":[{"v":"Tres > > Valles"},{"v":7.8}]},{"c":[{"v":"El > Cisne"},{"v":7}]},{"c":[{"v":"Cortecito"},{"v":6}]},{"c":[{"v":"La > Gloria"},{"v":5.3}]},{"c":[{"v":"Santa Fe"},{"v":5}]},{"c":[{"v":"Rio > Blanco"},{"v":5}]},{"c":[{"v":"Coronado"},{"v":4.5}]},{"c":[{"v":"Babilonia"},{"v":4.3}]},{"c":[{"v":"San > > Carlos"},{"v":4}]},{"c":[{"v":"Cececapa"},{"v":3.5}]},{"c":[{"v":"El > Coyolar"},{"v":1.7}]},{"c":[{"v":"Mangungo > I"},{"v":1.5}]},{"c":[{"v":"Santa Maria del > Real"},{"v":1.2}]},{"c":[{"v":"Eda"},{"v":1.2}]},{"c":[{"v":"Aceydesa"},{"v":1.1}]},{"c":[{"v":"Yodeco"},{"v":1}]},{"c":[{"v":"Zacapa"},{"v":0.8}]},{"c":[{"v":"Yojoa"},{"v":0.6}]},{"c":[{"v":"Aguan"},{"v":0.5}]},{"c":[{"v":"Lean"},{"v":0.5}]},{"c":[{"v":"La > > Nieve"},{"v":0.5}]}]} > > javascript: > > <html> > <head> > <meta charset="utf-8"> > <script type="text/javascript" src="https://www.google.com/jsapi > "></script> > <script type="text/javascript" src=" > http://ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js";></script> > <script type="text/javascript"> > google.load("visualization", "1", {packages:["corechart"]}); > google.setOnLoadCallback(drawChart); > > function drawChart() { > var jsonData =$.ajax({ > url: "plantas_capacidad_chart_info.php", > dataType:"json", > async: false > }).responseText; > > alert(typeof(jsonData)); > console.log(jsonData); > > var data = new > google.visualization.DataTable(JSON.parse(jsonData)); > var options = {'title':'Capacidad Instalada de Plantas', > 'width':800, > 'height':600, > 'hAxis.showTextEvery':2, > 'backgroundColor': '', > 'bar.groupWidth' : '90%' > }; > > var chart = new > google.visualization.ColumnChart(document.getElementById('chart_div')); > chart.draw(data,options); > } > </script> > </head> > <body> > <div id="chart_div" ></div> > </body> > </html> > > > > > image ----string: > > On Wednesday, December 12, 2012 2:30:17 PM UTC-6, asgallant wrote: > > I've never seen any " (string) " message. Can you post a screenshot, your > javascript code, and a sample of the json returned by your query? > > On Wednesday, December 12, 2012 12:55:49 PM UTC-5, Ian Haylock wrote: > > query solved !!!!!!!! thank you. > now my only problem is that before the browsers shows the graphs i keep > getting the " (string) " message and have to click on it to see the graph > ... any ideas ??? i have changed the types, added options, etc and still > nothing > > On Wednesday, December 12, 2012 11:38:06 AM UTC-6, asgallant wrote: > > This isn't causing your problem, but since your "capacidadMW" is a decimal > type, and not an integer, you should probably change (int) > $r['capacidadMW']); to (float) $r['capacidadMW']); > > That aside, I don't see anything in your code that would truncate the > results. Try running this and see what number is displayed: > > <?php > > include('connect-db.php'); > > $sth = mysql_query("SELECT planta, capacidadMW FROM planta"); > echo mysql_num_rows($sth); > ?> > > If that shows 55 records, then there is a problem in the PHP; if it shows > less than 55, then there is a problem with your connection to the database. > > On Wednesday, December 12, 2012 12:17:24 PM UTC-5, Ian Haylock wrote: > > just to let u know, the "planta" record in my table is type Varchar(45) > and the "capacidadMW" is type decimal (9,2) > > On Wednesday, December 12, 2012 11:03:40 AM UTC-6, Ian Haylock wrote: > > thanks for the reply .. > > the query im using in phpmyadmin showing 55 records: SELECT planta, > capacidadMW FROM planta; > > the code using to encode using JSon (result is only 14 records): > > <?php > > include('connect-db.php'); > > $sth = mysql_query("SELECT planta, capacidadMW FROM planta"); > $rows = array(); > $flag = true; > > $table = array(); > $table['cols'] = array( > > array('label' => 'planta', 'type' => 'string'), > array('label' => 'capacidad en MW', 'type' => 'number') > ); > > $rows = array(); > while($r = mysql_fetch_assoc($sth)) { > $temp = array(); > $temp[] = array('v' => (string)$r['planta']); > $temp[] = array('v' => (int) $r['capacidadMW']); > $rows[] = array('c' => $temp); > } > > $table['rows'] = $rows; > > $jsonTable = json_encode($table); > > echo $jsonTable; > ?> > > > On Wednesday, December 12, 2012 10:55:45 AM UTC-6, asgallant wrote: > > At a guess, I would say you have an error in the SQL in PHP. If you post > your PHP code, I'll take a look at it. > > On Wednesday, December 12, 2012 11:41:25 AM UTC-5, Ian Haylock wrote: > > Hi asgallant, thank you very much for th taking the time to help others. i > have a question if you dont mind, i followed Diana´s sample and got it to > work, well sort of, i used my onw db and managed to show the graph and > everithing, the only thing is that my mysql query running in phpmyadmin > shows 55 records and my json result shows only 14 records, how is that > possible ??? > > On Wednesday, December 12, 201 > > ... -- 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 http://groups.google.com/group/google-visualization-api?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
