And a Tweet Later – Querying Shadow Cabinet Expenses on Google Spreadsheets with the Google Query Language
6 minutes past 5 this evening:
(There was a problem with the publishing/privacy settings – maybe the tech team would like to post a comment saying what, exactly – that meant while the spreadsheet was viewable in preview form and as CSV, it was impossible to run Google visualisation API query language queries against it.)
Half an hour later:
And ten minutes after that:
So what? So this:
And with a little tweaking, we can get a summary of the expenses by Shadow Cabinet member – run a select A,C,sum(E) group by A,C query on the spreadsheet:
(If you prefer to see the full total by member, use this query: select A,sum(E) group by A)
Or if you prefer a bubble chart?
Or maybe a matrix chart?
(I think that Many Eyes WIkified updates its data pages from live data feeds, so hopefully the linked to visualisation should remain pretty much up to date? [All the visulisations can be reached from this Many Eyes Wikified page.])
Isn’t this fun?:-) So why don’t you have a go?????
PS for a more comprehensive review of what’s possible with the query language, I’ve posted a wide selection of examples here: Using Google Spreadsheets as a Database with the Google Visualisation API Query Language.