Hi Riccardo, That is an interesting implementation that I had not considered and I'll have a think about that path too. I'm on the way out the door, but I'll have a look-see at your code when I return, much appreciated.
What I was attempting to do is do all this in one dashboard. I have a table with events that occur near towns. I have a table with towns. I am showing a map with the location that the events occur. I am also showing a table which lists the events. The controls allow you to filter by event type, town, etc. (You have already helped me make the table and map select work in another post - thanks!) I want to add a graph showing all towns and a count of the number of events happening nearby. If I use the main table, all I'll get is the towns where there are events currently happening, not the rest of the towns. In a relational database I'd join the two tables together, and get the town and the count, something like this: SELECT t.town, count(e.*) as near from towns t LEFT JOIN events e ON t.town=e.town GROUP BY t.town So, I'd get each town and a count (or NULL for those towns where there is no event) in a table which I can then graph. The API indicates that there is a join() method, but I have yet to determine how I'd go about doing that. How would I create another datasource (since this is asynchronous) and join that with the current set-up? I suspect that the intent is that this could work given the published methods without resorting to building a separate dashboard. I should also point out that the towns graph is only one of a few that I'd like to produce, so I have to keep that in mind when I'm building this. PS. I currently cannot publish this, as it's part of a government department project, but I do intend to make it available within the next month (since it is expected to be public in about three weeks). Onno -- 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.
