[visualization-api] Google Chart Coding showing blank Page--Below is coding

2014-06-17 Thread sameer ahmad
I am trying to make a line graph using google chart from sql database, but the coding just shows a blank page. I need a graph which shows date and price from my database.Below is the coding: html head !--Load the AJAX API-- script type=text/javascript

[visualization-api] Re: show empty cell instead of zero value

2014-06-17 Thread bob3321
Perfect! Thank you On Monday, June 16, 2014 7:53:12 PM UTC+2, Andrew Gallant wrote: The formatters won't do this for you, but you can format your data yourself: for (var i = 0; i grouped_data.getNumberOfRows(); i++) { for (var j = 1; j grouped_data.getNumberOfColumns(); j++) {

[visualization-api] Re: form select multiple parameters connection DB

2014-06-17 Thread Vincenzo Diligente Tizzani
'#' this is the problem now I add this and all ok, thank you very much for your support and thanks for your answers Il giorno martedì 17 giugno 2014 02:39:14 UTC+2, Andrew Gallant ha scritto: The only problem I see is that the jQuery selectors are missing a leading '#' (which I forgot to

[visualization-api] IE(11) rendering the wrong result (vs Chrome) ... Column Chart with Trendlines

2014-06-17 Thread Michael Falkson
Please view the following URL in IE and then in Chrome or Firefox. As you can see IE is rendering the chart with only one column while Chrome a Year's worth. Safari also renders it incorrectly. Any assistance would be most appreciated. Test URL: https://clients.etisales.com/pls/tats/testid

[visualization-api] Re: Query Language not working with new Sheets

2014-06-17 Thread 'Sergey Grabkovsky' via Google Visualization API
Here is an example query: https://docs.google.com/a/google.com/spreadsheets/d/1EbXvQW2IQ3QCoeXj-1tt0Ed_VwULk-YJZ7373MBG8PQ/gviz/tq?tq=SELECT%20A,B,E%20WHERE%20E%3E4 The query is SELECT A, B, E WHERE E 4 On Mon Jun 16 2014 at 6:09:37 PM, Jian Sun jian...@motorola.com wrote: Hi, Sergey, Could

[visualization-api] IE(11) rendering the wrong result (vs Chrome) ... Column Chart with Trendlines

2014-06-17 Thread 'Sergey Grabkovsky' via Google Visualization API
Hi Michael, this is due to how each browser handles the Date constructor. I would recommend that you only use the documented behavior outlined here: https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Date For the most consistent behavior, create your dates by

Re: [visualization-api] IE(11) rendering the wrong result (vs Chrome) ... Column Chart with Trendlines

2014-06-17 Thread Michael Falkson
Thanks Sergei. Appreciate your keen eye. Works fine now. Thanks Mike On Tuesday, June 17, 2014 9:53:15 AM UTC-4, Sergey wrote: Hi Michael, this is due to how each browser handles the Date constructor. I would recommend that you only use the documented behavior outlined here:

[visualization-api] Line chart not showing up in wordpress site.

2014-06-17 Thread sameer ahmad
I created a seperate document for line graph, and it worked perfectly. But now when i embedded this similar peice of code in my website homepage template of wordpress, it is not showing anything. please help me out. -- You received this message because you are subscribed to the Google Groups

[visualization-api] Re: Geochart Marker HTML Tooltips

2014-06-17 Thread Sergey
I am happy to tell you that this is fixed now in 1.1. On Wednesday, June 11, 2014 9:04:40 AM UTC-4, IK wrote: Hi, I am trying to get HTML tooltips working on markers in SELECTION mode but it is showing text. Here is a fiddle of what i am talking about http://fiddle.jshell.net/2N2Xr/1/

[visualization-api] How to format the .CSV data to use Google Annotation chart??

2014-06-17 Thread Milan Shrestha
I am working on WEB based data logger and receiving data in .CSV format. My data looks like this: Date,Time,Direction,Temperature,Wind Speed,Max. Speed,Dev1,a,b,c 17-06-14,15:47:28,67.5,30.50,0.70,3.02,0.91,0.20,0.20,0.00 17-06-14,15:48:28,67.5,30.50,2.98,4.43,0.65,0.20,0.20,0.00

[visualization-api] Re: Query Language not working with new Sheets

2014-06-17 Thread Jian Sun
Hi, Sergey, When I click your example query link, I saw the following in the browser window. I was expecting to see a HTML page like we saw with the old spreadsheet version(for example

[visualization-api] Re: Query Language not working with new Sheets

2014-06-17 Thread Jian Sun
Hi, Sergey, When I click your example query link, I saw the following in the browser window. I was expecting to see a HTML page like we saw with the old spreadsheet version(for example

[visualization-api] Re: Query Language not working with new Sheets

2014-06-17 Thread 'Sergey Grabkovsky' via Google Visualization API
Hi, this is a known issue with the new sheets. There is an external issue relating to this that you can star https://code.google.com/p/google-visualization-api-issues/issues/detail?id=1596 to be kept up to date. The Docs team is aware of this and is working on a fix. In the meantime, you can use

[visualization-api] Google visualization api histogram

2014-06-17 Thread Sebastian Munro
Hello, I am trying to output a histogram with some data I have parsed. I am trying to use the visualization api in perl, but I can't seem to find anywhere that will help me start and I have no idea what to do (in terms of modules to import etc.). If someone has an example, it would be much

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

2014-06-17 Thread Andrew Gallant
Your PHP $dataArray assignments are out of order; you need to add each row after you make the queries. Since you are reusing the $row variable, you have to run a query and add that data before you run the next query. I attached a copy of the php file to my previous post that you can work

[visualization-api] Re: Google Chart Coding showing blank Page--Below is coding

2014-06-17 Thread Andrew Gallant
You have a syntax error after the closing brace for the drawChart function: the ? needs to be removed. On Tuesday, June 17, 2014 3:04:50 AM UTC-4, sameer ahmad wrote: I am trying to make a line graph using google chart from sql database, but the coding just shows a blank page. I need a graph

[visualization-api] Re: Line chart not showing up in wordpress site.

2014-06-17 Thread Andrew Gallant
Open the page in Chrome and check the developer's console. Are there any errors reported? If not, view the page source and paste it here; I'll take a look to see if I can figure out what is going on. On Tuesday, June 17, 2014 10:46:50 AM UTC-4, sameer ahmad wrote: I created a seperate

[visualization-api] Re: How to format the .CSV data to use Google Annotation chart??

2014-06-17 Thread Andrew Gallant
You can use a DataView to convert the strings to date, datetime, and/or timeofday data types depending on what you need. In your case, since you have dates and times, I recommend using a datetime data type: var view = new google.visualization.DataView(data); // create a formatter to format the

[visualization-api] Re: Google visualization api histogram

2014-06-17 Thread Andrew Gallant
There is nothing special you need in perl to use the Google Visualization API - it is entirely based in javascript on the client side. On Tuesday, June 17, 2014 2:19:42 PM UTC-4, Sebastian Munro wrote: Hello, I am trying to output a histogram with some data I have parsed. I am trying to use

Re: [visualization-api] Alternative To Deprecated Google Chart Tools API

2014-06-17 Thread 'Jon Orwant' via Google Visualization API
For the benefit of others and to avoid confusion: Google maintains a server-side API called the Chart Tools API, and a client-side API called the Google Visualization API or Google Charts API. This forum is almost exclusively about the *client-side* API. Years ago we announced the year 2015