This example has
var query = new google.visualization.Query(
'http://spreadsheets.google.com/tq?key=dGpwODBQaEpITnRVcjJlYllNNkRSVXc6MQ&pub=1'
);
But where can I get this key for my document? Do I also have to set its
permissions to public?
On Thursday, December 1, 2011 8:52:39 AM UTC+2, TheNez wrote:
>
> you can use the query language to obtain that.
>
> use the playground sample to test it:
> http://code.google.com/apis/ajax/playground/?type=visualization#using_the_query_language
>
> 1. change the spreadsheet link to yours
> 2. in the setQuery function change the query to this:
> query.setQuery("SELECT C,D WHERE C >= date '2011-11-01' and C <= date
> '2011-11-30' ORDER BY C");
> where C is the date column and D is the data column.
> pay attention to the 'date' type declaration in the query.
>
> for more details on the query language go to this link:
> http://code.google.com/apis/chart/interactive/docs/querylanguage.html
>
> Good luck,
>
>
>
--
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.
