Thank you Onno for the update on your work and the link to your final project! Nice work. The dashboard I'm building is just for internal use by our staff. I have about a dozen spreadsheets I'm trying to pull together so I may just have to be satisfied with what I can quickly get running. I have one more idea to get something working that I'll try, unless someone else has come up with a solution to this problem....
On Monday, February 27, 2012 4:33:23 PM UTC-6, Onno Benschop wrote: > > 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 view this discussion on the web visit https://groups.google.com/d/msg/google-visualization-api/-/wZg7cynwPL0J. 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.
