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 -~----------~----~----~----~------~----~------~--~---
