Hi. I'm not sure I understand what the problem is. In the first query you suggested here, you get in return two columns - the date (A) and the maximum temperature. Why do you need to add yet another A to the query?
Viz Kid On Wed, Feb 10, 2010 at 7:30 PM, take.it.easy <[email protected]> wrote: > I have a datetime and a temperature column in a google spreadsheet. > I'm trying to query to find the high temperatures by date and display > the time of day that the high temperature occurred, then visualize the > result. > > A=datetime > B=temperature > > My query is: > > SELECT toDate(A), max(B) group by toDate(A) > > ...that works fine. But if I try to query with: > > SELECT toDate(A), A, max(B) group by toDate(A) > > ...to include the A (so I can display the time that the high temp. > occurred), I get the following error: > > "Error in query: Invalid query Column [A] should be added to GROUP BY, > removed from SELECT, or aggregated in SELECT." > > So how do I include the time? > > -- > 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.
