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 great thing about Twitter is the ability to ask all my talented friends for solutions to immediate problems, in the same way as I might turn around in an office and ask questions of my nearby colleagues. All well and good, but the question and the answer aren’t collated which is mildly frustrating and not Google friendly. Here’s a recent useful exchange:
Me:Â Is it possible in Photoshop to collapse all layer palette groups in one single judo UI operation?
McJim:Â Command + click on little triangle thingy
…closely followed by…
Strawbleu:Â Liking the term ‘Judo UI Operation’
Thought some of that might be useful to someone, as I did Google for it but couldn’t find an answer. Thanks to McJim for the answer.
When you’re lying across the front seats at the top of the bus, it’s really easy to miss your stop. #
I really feel the different languages one hears in this country are beautiful. Beautiful and embarassing, as I don’t speak them. Damn. #
Now I have to buy a Megarider, all bus routes are open to me. I’ve just got overexcited and boarded an 84. I think we’re going via Wigan. #
I wish there was a way of sharing links on Opera Mini. I do a suprising amount of my reading on Mini these days. #
Very warm welcome to the North @cubicgarden (Ian Forrester), I’m a southerner too and they treat me passingly well, so don’t worry too much. ;) #
Disappointed not to have made it over the Pennines for GeekUp Leeds, although plenty of good work has got done. Off for fish & chips now. #
Frank Turner himself was great, albeit overwhelmed by the ambient noise at points. He’s a very unassuming man on stage. #
Next act is immediately appealing. Vituperative cockney musichall pi-ann-er playing lady. Loving it. #