Michael Jackson | UK Peak charting album positions
Source – Offical charts.ocm
Well i’d been sitting on this viz for a while, and was reminded it was sitting in the ‘part done viz’ folder awaiting a final push to make it publishable.
I was spurred on to publish this viz in early Jan 2019, after seeing Neil Richards – Elvis and Beatles viz which was a dead ringer for the Albums viz id somewhat forgotten i’d created! I was both surprised and flattered to receive a few nice comments from some lovely peeps (namely Kev Flerlage and Neil), likening it to something Neil may have published. A privilege of course to come close to executing a viz to Neil’s standard, which always have the wow factor and curb appeal.
My intentions for this viz were to take a look at the albums of the ‘king of pop’, intrigued to understand which of his albums charted best in the UK and when. So I decided to split the charting albums into decades and present them in a fun way – something like a vinyl record. The smaller the ‘ring’ (or groove), the higher the peak charting position. Data taken from official charts.com also includes the label in which the album was published and felt it would be an interesting dimension to interact with in the visualisation.
Circles and shapes
A quick ‘how I constructed the viz’
So this viz (in the end) is just one worksheet using a duel axis (one circle and one shape type). I originally had two worksheets in play and floated them on top of each other in the final dashboard, but good friend, colleague and critique Lorna Eden told me to stop being lazy and do it more elegantly! So…. its in one worksheet now – thanks for the steer Eden.
To get the duel axis we have a couple of dummy pills ‘sum(0)’, and then it was a case of dropping all the fields required to build up the layers.
The ‘Shape’ type (circle) handles the ‘rings’- and chart position data, and the ‘circle’ type handles the vinyl disk.
The Key to getting the vinyl disk look is to create a couple of measures avg(15) and avg(20) to fix the circle sizes, the rest of the pills are pretty much labels etc.
with the exception of one sneeky ‘mofo’…..
One complication of wanting that ‘elegant solution’ Eden so determinedly insisted on, meant creating a additional data set to help handle the records publishing label and related highlighting!
Download the dashboard off Tableau public here for a delve into that.
Thanks for reading