How to Compare to the Average with a Bar Chart

Context is important in data visualization. For every chart you create, consider asking yourself "compared to what?" 

In this tip, I show you how to add context to a simple bar chart by showing whether a value is above or below the average.

#MakeoverMonday 2021 Week 35 - Male Circumcision Around the World

In this week's Watch Me Viz, I started by showing the original visualization, demonstrated how to make a non-geographical field geographical, and then I spent lots of time working through set action drill down.

I showed how to do drill down to two and three levels of dimensions in a hierarchy. Lastly, while building the dashboard, I also showed how to move fields you select in an action to the top of the view with a sorting calculation.

Enjoy!

How to Automatically Exclude a Partial Week

In this video, I show you how to use level of detail expressions to only return sales through the latest completed week. This method will work as weeks complete; you will not need to edit any of the calculations to ensure weeks that close in the future get included in the chart.

#MakeoverMonday 2021 Week 34 - Entry-Level Jobs on LinkedIn Requiring 3+ Years Of Experience

Eva sent me an interesting, and ironic data set for this week. It's based on a studying done on LinkedIn of jobs that advertise as "entry-level" yet require 3+ years of experience. I'm still having trouble wrapping my head around that.

#MakeoverMonday 2021 Week 33 - UCAS Daily Placements

UCAS is a service that helps people find open placements universities in the UK (and hopefully place them). I found this particular data set quite confusing until I looked at this viz from UCAS. I then understood that we were basically looking at the number of applications from UCAS based on the time that has elapsed since exam results days. That probably took me a couple hours to wrap my head around.

#MakeoverMonday 2021 Week 32 - Mortality Rates in England and Wales

I couldn't find too much to do with this week's data set, so I ended up with some simple BANs and line charts that take the original and reorganize them a bit to make them more clear.

Resources:

1. Data set - https://data.world/makeovermonday/2021w32
2. Chart Guide - https://chart.guide/
3. Final Viz - https://bit.ly/mm2021w32

#MakeoverMonday Week 31 - Bicycle Collisions in London

This week's data set was pretty straightforward. During #WatchMeViz I iterated through some maps, including joining to spatial files for London, and also lots of time series charts. Below are links to the resources, the video, and the final viz.