Count and sort in Google Sheets using QUERY()

When I’ve pulled some data into Google Sheets I often want a way to quickly chart the count of something, maybe it’s support tickets and I want to chart the incidence of particular tags or count tickets for each customer. In this situation I want a nice neat chart showing from ordered data.

Continue reading Count and sort in Google Sheets using QUERY()

The Government double charges us for data

I’ve just felt sufficiently exercised to write to my MP, about the UK government charging for information they’ve collected with our (the UK taxpayers) money. For example, I’m doing a location based events search for Arts & Kids. The data underpinning this has been collected by OS and the Royal Mail, using tax payers money, and yet the charity is having to pay for it in order to provide a free service to UK citizens.

Continue reading The Government double charges us for data