Hi, I joined this group just to ask if it is posible to query a datatable. It seems that the answer is no.
I'd like to know if, in future releases, this will be posible or maybe the whole idea of querying directly a datatable is wrong from an architectural point of view. I don't like having to requery a servlet (which works as datasource) an transfer +50kb each time. Sometimes is +300kb. In my case, I need to aggregate the same information I'm using in a PieChart to build another Visualization. Cheers, Alejandro On Jul 17, 5:55 pm, chrissky <[email protected]> wrote: > 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 > herehttp://blog.shufflepoint.com/2009/07/feeding-the-google-annotated-tim... > > 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 -~----------~----~----~----~------~----~------~--~---
