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=select B,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 -~----------~----~----~----~------~----~------~--~---
