[visualization-api] Re: How to show a country name instead of country code on a GeoMap?

2013-04-17 Thread Manu Zhang
I was thinking what's the difference between the two. It's quite clear now and GeoCharts have more nice options. Thanks On Wednesday, April 17, 2013 1:00:21 PM UTC+8, asgallant wrote: The GeoMaps are an old visualization and may not conform to some of the modern standards for the charts.

Re: [visualization-api] Re: Google Charts with PHP and MySQL

2013-04-17 Thread Chrystopher Medina
my friend how can i close the database here in this script . ?php if ($_POST['user']!= '' $_POST['pwd']!= ''){ $username = root; $password = chrystopher; $databasename = si_caoi; try { $db = new PDO(mysql:dbname=$databasename,$username,$password); } catch (PDOException $e) {

Re: [visualization-api] Re: Table and map in same dashboard

2013-04-17 Thread sikkertrafik2011
Thank you asgallant. When I would like to import larger data sets from my spreadsheet into the table and map, it throw an error: One or more participants failed to draw()× And on the map it says: Some of the data rows were truncated× How can I find out what the limits on map are? It looks

Re: [visualization-api] Re: Google Charts with PHP and MySQL

2013-04-17 Thread Chrystopher Medina
i just wanna close the connexion to the database 2013/4/17 Chrystopher Medina xhav...@gmail.com my friend how can i close the database here in this script . ?php if ($_POST['user']!= '' $_POST['pwd']!= ''){ $username = root; $password = chrystopher; $databasename = si_caoi; try {

[visualization-api] Possible Bug with Curved Line Charts?

2013-04-17 Thread Chris Stamoulis
Hey there, When the lines are drawn, they seem to have issues going off the chart (over 100% and under 0%) Check out this code to reproduce. Is there a way around it? function drawVisualization() { var data = google.visualization.arrayToDataTable([ ['Team', 'Team1', 'Team2', 'Team3'], ['Apr

Re: [visualization-api] Add total row to Table in last position.

2013-04-17 Thread Francisco Gonzalez
I used a div and with css leave below the table El domingo, 19 de diciembre de 2010 11:37:00 UTC-3, ChartMan escribió: There is no built in support for that but you can use the following: Prepare the aggregation you want for the column (you can use the following API -

Re: [visualization-api] Re: Table and map in same dashboard

2013-04-17 Thread asgallant
The note in the Data Formathttps://developers.google.com/chart/interactive/docs/gallery/map#Data_Formatsection of the Map documentation says that Maps accept a maximum of 400 rows of data. On Wednesday, April 17, 2013 5:44:14 AM UTC-4, Sikker Trafik wrote: Thank you asgallant. When I

[visualization-api] Help with pie chart - duplicates appearing

2013-04-17 Thread jtesolin
I am working off of the Google api example for a pie chart replacing the data.addRows/google.visualization.arrayToDataTable with the below, however, for some reason, the last row other is showing up twice: data.addRows([ ['Microsoft Outlook', 2651], ['Windows Live Desktop', 657], ['iOS

Re: [visualization-api] Help with pie chart - duplicates appearing

2013-04-17 Thread Sergey Grabkovsky
The PieChart adds its own 'Other' category that is a collection of all the slices that were deemed too small to show up on their own. You can remedy this by changing the sliceVisibilityThreshold option. - Sergey On Wed, Apr 17, 2013 at 10:55 AM, jteso...@gmail.com wrote: I am working off of

Re: [visualization-api] Re: Google Charts with PHP and MySQL

2013-04-17 Thread asgallant
With PDO's, setting the PDO variable ($db in your script) to null closes the connection. Most sources I have read also say to set all prepared statement variables ($query in your script) to null as well, but I'm not certain that this is strictly necessary. You are setting both of them to

Re: [visualization-api] Help with pie chart - duplicates appearing

2013-04-17 Thread jtesolin
Ah ha! That fixed it. Thanks. I should have looked into the options before thinking it was a coding error on my part. Thanks. On Wednesday, April 17, 2013 10:57:32 AM UTC-4, Sergey wrote: The PieChart adds its own 'Other' category that is a collection of all the slices that were deemed too

[visualization-api] Re: Possible Bug with Curved Line Charts?

2013-04-17 Thread asgallant
This is a result of the function used to produce the curve (the API seems to use a Bézier

Re: [visualization-api] Possible Bug with Curved Line Charts?

2013-04-17 Thread Daniel LaLiberte
You've got some extra code at the bottom, but fixing that, the reason the line (smoothed using curveType: function) goes above the gridlines is that this is the expected behavior of this smoothing. It doesn't actually draw outside of the chart, but given your gridlines.count and viewWindow min

[visualization-api] How to set X axis source column for LineChart loaded from spreadsheets?

2013-04-17 Thread Sergey Kipot
Hi Everyone, I'm new to Google Charts API and trying to play with it in code playground. Using default piece of code that shows how to load data from spreadsheets I've made one small modification to visualize different columns

[visualization-api] Re: How to set X axis source column for LineChart loaded from spreadsheets?

2013-04-17 Thread Sergey Kipot
I've found solution in older topic https://groups.google.com/d/topic/google-visualization-api/dbYfjWSrDEY/discussion Google Code Playground uses linechart. Switching example to corechart has fixed the issue and case is closed. -- You received this message because you are subscribed to the

[visualization-api] Re: How to set X axis source column for LineChart loaded from spreadsheets?

2013-04-17 Thread asgallant
Yes, the playground code should be updated to use the corechart package instead of the deprecated linechart package. On Wednesday, April 17, 2013 1:46:28 PM UTC-4, Sergey Kipot wrote: I've found solution in older topic

Re: [visualization-api] Re: Google Charts with PHP and MySQL

2013-04-17 Thread Chrystopher Medina
Ok my friend thanks . And could you help me to learn more about pdos . Because y was reading the pdos document in the web site from php. But I if I could give me some links. To read more about this. Thanks El 17/04/2013 09:59, asgallant drew_gall...@abtassoc.com escribió: With PDO's, setting

Re: [visualization-api] Re: Google Charts with PHP and MySQL

2013-04-17 Thread asgallant
Try these: http://net.tutsplus.com/tutorials/php/php-database-access-are-you-doing-it-correctly/ http://wiki.hashphp.org/PDO_Tutorial_for_MySQL_Developers http://www.netmagazine.com/tutorials/using-php-data-objects On Wednesday, April 17, 2013 4:02:03 PM UTC-4, Chrystopher Medina wrote: Ok my

[visualization-api] Simple Line Graph with 2 series - data from php - almost there

2013-04-17 Thread new_prog
Hi all, Am stuck on trying to display two series on a line chart through google charts api. I am getting my data from a database using sql and this is all working fine. I have adapted the code from: PHP MYSQL Google Chart JSON Complete

[visualization-api] BarChart does not display: e[0].K is undefined error message

2013-04-17 Thread Patrick Waldo
Hi, A bit of backround. I work with Plone 4.2.4 (CMS) and Python and wanted to integrate Google Charts with an Oracle back end. Plone already has a very nice package called EEA.Daviz http://plone.org/products/eea.daviz. However, it was way more than I needed and I thought I could do it on

[visualization-api] Re: Simple Line Graph with 2 series - data from php - almost there

2013-04-17 Thread asgallant
Ok, the first problem is that you are creating a DataTable with 3 columns here: $table['cols'] = array( array('label' = 'Date', 'type' = 'string'), array('label' = 'Percentage Change', 'type' = 'number'), array('label' = 'Percentage Change 1', 'type' = 'number') ); But only

[visualization-api] Re: BarChart does not display: e[0].K is undefined error message

2013-04-17 Thread asgallant
Open the page that doesn't work in a browser, view the source, and paste it here. I'll take a look and see what might be causing you problems there. On Wednesday, April 17, 2013 4:27:14 PM UTC-4, Patrick Waldo wrote: Hi, A bit of backround. I work with Plone 4.2.4 (CMS) and Python and

[visualization-api] Re: BarChart does not display: e[0].K is undefined error message

2013-04-17 Thread Patrick Waldo
Great! Any help would be much appreciated. This is the source from Firefox as it was rendered by Pone: !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd; html xmlns=http://www.w3.org/1999/xhtml; lang=en-us head

[visualization-api] Re: BarChart does not display: e[0].K is undefined error message

2013-04-17 Thread asgallant
I can tell right away that you will have major problems due to the links pointing to localhost:8080 - that will only work if you are accessing the page from the same system as the server. Is this the version that works on your local system or is the server deployment? When I run that script,

[visualization-api] Re: BarChart does not display: e[0].K is undefined error message

2013-04-17 Thread asgallant
Also, is there a public-facing test server I can try this on? That might help me debug it. On Wednesday, April 17, 2013 6:33:17 PM UTC-4, asgallant wrote: I can tell right away that you will have major problems due to the links pointing to localhost:8080 - that will only work if you are

[visualization-api] Re: Construction of a Table with Hyperlinks

2013-04-17 Thread Chris Fortunato
I guess I'm really trying to do this without writing any script only because I just don't have any experience or knowledge with that stuff. And you're right, when I convert to a table all that shows is the text. On Friday, November 30, 2012 1:20:22 AM UTC-5, asgallant wrote: Yes, you can have

[visualization-api] Re: Construction of a Table with Hyperlinks

2013-04-17 Thread asgallant
There is no way to get it to display URLs as links without doing some scripting. I can help you with that, though, if you share what you have for code so far. On Wednesday, April 17, 2013 8:56:51 PM UTC-4, Chris Fortunato wrote: I guess I'm really trying to do this without writing any script