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]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
