Brian, I never got it to work, but my handy work can be seen here - in the end I combined the data from multiple spreadsheets into one, then ran the dashboard across that, ugly but functional:
http://dashboard.worldsolarchallenge.org/ (Check the Dashboard, the other pages are derivative stats - and the data is now static.) Tip for young players, Google Spreadsheets will die if you throw 4 million people at a page like this. The caching is all-but non-existent. In the end, I needed to double-cache, a linux web-server got the data from Google, then my display spreadsheet got it from there. If you expect to run this out for a large audience you need to look for an alternative data-source. Fusion Tables was suggested by Google, but during the Google Developer Day in Sydney I was told any data published in that is *public*. Google App Engine is a potential alternative that I never investigated for this solution. I never said thanks to the people here - we had an event on at the time, so herewith. Thank you to the combined and individual efforts people in this forum supplied to get my solution working. O On 28 February 2012 00:33, Brian Smith <[email protected]> wrote: > I'm sorry, I wasn't clear that I was trying to post a reply under Riccardo > Govoni's post! Thanks for your reply and offer of help asgallant. What I'm > trying to do is make a control that will apply a filter to two (or more) > dashboards. I tried using the method that Riccardo posted above, but it > doesn't seem to work as written because of the fact that I am querying a > datasource (google spreadsheets) rather than declaring a data variable > inside of the dashboard1 function. > > On Monday, February 27, 2012 10:14:04 AM UTC-6, asgallant wrote: >> >> Keep in mind that the arrays are of column *indices*, not labels. If >> 'school name' is the first column in the first table and the second column >> in the second table, then the keysArray would look like this: >> >> var keysArray = [ >> [0, 1] >> ]; >> >> If that doesn't solve the problem for you, post your code or a link to >> your code and I'll take a look. >> > -- > You received this message because you are subscribed to the Google Groups > "Google Visualization API" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/google-visualization-api/-/Dv57vTDoN44J. > > To post to this group, send email to > [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/google-visualization-api?hl=en. > -- Onno Benschop ()/)/)() ..ASCII for Onno.. |>>? ..EBCDIC for Onno.. --- -. -. --- ..Morse for Onno.. ITmaze - ABN: 56 178 057 063 - ph: 04 1219 8888 - [email protected] -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
