the google visualization query language, in this respect, is very similar to SQL. I think if you want to pursue this, you should formulate a SQL query that does this and then see if it works as a google visualization query.
IMAO, however, even if such a query is possible in SQL (I don't know), it probably looks like spaghetti. SQL was not made for things like this. you are better off writing a javscript loop on the client, or, if that's too slow, writing a loop in your server and sending the data back to the client in some standard way, like an xml http request. that's my two cents. On Fri, Feb 19, 2010 at 10:35 PM, Narin <[email protected]> wrote: > Hello, > > I have 2 rows that are percentages that I'd like to compare. I'd like > to filter results where there is a difference larger than 3% between > the first and second row. What would be the best approach to do > this? Can this be done in a single query? > > Any help is greatly appreciated. Really enjoying the responsiveness > and knowledge of this group. Thanks in advance! > > -- > 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]<google-visualization-api%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/google-visualization-api?hl=en. > > -- 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.
