Remote data with dashboard

152 views
Skip to first unread message

Ron O Webshed

unread,
Sep 14, 2011, 1:17:32 PM9/14/11
to Google Visualization API
We tryed to build a dashboard with your new
google.visualization.Dashboard & ChartWrapper
and with remote data (we use google spreadsheets).

I'm sure its possible , but we couldnt do it. can you post a short
example please ?

If you can post this example :
http://code.google.com/apis/ajax/playground/?type=visualization#full_dashboard

but with remote data in the short way by dataSourceUrl in the
chartWrapper:
dataSourceUrl: 'http://spreadsheets.google.com/tq?
key=abcd&range=B1:D11&pub=1',


Thanks !

P.S.
We just love the new chart tools- great potential and very easy to
use! and the playground is very helpfull !

asgallant

unread,
Sep 14, 2011, 2:25:21 PM9/14/11
to google-visua...@googlegroups.com
I'm not quite sure what you mean.  The playground sample you linked to does that already.

Riccardo Govoni

unread,
Sep 14, 2011, 2:43:28 PM9/14/11
to google-visua...@googlegroups.com
Have a look at the example in this old thread:

Basically you want to issue a google.visualization.Query and feed the datatable returned by the query into the Dashboard.draw() method.

Is this what you're looking for?
-- R.

Ron O Webshed

unread,
Sep 15, 2011, 12:29:21 AM9/15/11
to google-visua...@googlegroups.com
Thank you Ricardo - that's exactly what I was looking for ! 

thanks again :) 

P.S. 
I thought that it will be possible to fetch the data using 'dataSourceUrl' like here:

var wrapper new google.visualization.ChartWrapper({
    dataSourceUrl'http://spreadsheets.google.com/tq?key=xxx&range=B1:D11&pub=1',
  

I hoped that there is a way to do that also in the dashboard but i guess its not possible,
so your example is the easiest way to do that, 
thanks again !
Reply all
Reply to author
Forward
0 new messages