> > I have a similar problem. I am tracking items(column B) and each item has > multiple locations with a date(A), lat(E), long(F), and description(G) of > that location. I would like to query the latest location for each item. > I can query the latest date with 'SELECT B, MAX(A) GROUP BY B', but I don't get the location information with that. When I try 'SELECT B,E,F MAX(A) GROUP BY B' I get an error telling me I need to either remove E and F from Select, or add them to the Group by. But when I add them to the Group By, I get multiple locations for each item, so it defeats my query.
Any suggestions on how to retain all my location columns, but only show the most recent location for each item? > > > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To view this discussion on the web visit https://groups.google.com/d/msg/google-visualization-api/-/QG-hdUMjYcoJ. 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.
