Hi Scarlett, I can give you a bit of guidance on your idea - since I just did something very similar for a blog article. "Feeding the Google Annotated Timeline gadget from a GAQL query" You can read it here http://blog.shufflepoint.com/2009/07/feeding-the-google-annotated-timeline-gadget-from-a-gaql-query.html
Basically, I requery the datasource when the user changes the date range across some thresholds. If you upload your CSV to a google spreadsheet, then you could use the approach I presented in my article. I haven't seen info on the RC 1.1 - do you have a link? Chris Harrington, ShufflePoint, Inc. On Jul 16, 5:28 pm, Scarlett <[email protected]> wrote: > I'm still trying to find a solution for handling large sets of data > with the annotated timeline. > > Issue: > Plotting a large number of data point takes a long time ... and it > doesn't look good if there is variability. > > Idea: > Load data at the appropriate resolution (~between 50 and 200 data > points?) based on getVisibleChartRange(). Something similar to how the > time axis labels are adjusted at different resolutions. When chart > range is <30 days plot in hours, 30-365 days plot in days, 1-5 years > plot in months ... > > Wrinkle: > Even with this method the loading of the non-visible data slows the > whole chart down. My idea is to use the Query language (~SQL) to > "filter" the non visible data to a lower resolution and keep the > visible range at the higher resolution. I can do this in Oracle SQL by > SELECT column_name GROUP BY to_char(date_column_name, 'YYYY-MM') ... > where this creates monthly data set. I hope this can be done in the > Query language so there are three DataTables that are joined back > together: (1) one for the low resolution prior to the > VisibleChartRange, (2) one higher resolution during the > VisibleChartRange, and (3) one lower resolution after the > VisibleChartRange. > > Problem: > 1. I'm a hack when it comes to programming. > 2. I can't see any examples of how to use the Query language on a > DataTable (which I have loaded from a csv file.) not a Google > spreadsheet. Anyone have an example? Or can I use the Query language > against the csv file right away? > 3. I think with the release candidate 1.1 there are more methods > available for the Annotated timeline, but I can find any documentation > on what they might be. Where might I get more info on the development > version? > > Cheers, > Scarlett --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
