Thanks, No, I think I'll just wait :-)
Yours sincerely Rókur On Aug 20, 12:47 pm, VizWiz <[email protected]> wrote: > Hi, > > I don't think you can do it using only the query language. We are planning > to add both join and group-by on the client side api somewhere in the near > future, which will solve your problem. > > In the mean time, an ugly work around could be to send the query twice, once > with grouping and once without grouping, and copy the date from the > un-grouped table. I am not sure that this is the best solution for you, > however. > > I hope this helps. > > Cheers, > VizWiz > > On Wed, Aug 19, 2009 at 12:06 PM, rokur <[email protected]>wrote: > > > > > Hi, > > > I've managed to extract individual high scores from a spreadsheet with > > Date (A), Name (B) and Score (C), using this query: > > >http://spreadsheets.google.com/tq?tqx=out:html&tq=selectB,max(C) > > group by B order by max(C) desc label max(C) "High > > Score"&key=tjrDO76DjoJ-NDIiPJaD84g > > > But how can I now add the date (column A) to this result set, as > > additional info, rather than part of the query? > > > If I just add A to the select string ("select A,B,max(C)"), I'm forced > > to add A to the group by also, and then get to many groupings. > > > I guess I need some nested select or join, but cannot figure out to do > > this with this Query Language. > > > Yours sincerely > > > Rókur --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
