How to Colour Scale a Map Using Set Actions!

I thought my Best of DS11 blog would be my final blog post on the Data School website but no, I have one quick blog post left. Set Actions. They’re new and exciting, right? Today at the Data School, Harry of DS11 taught us (and the coaches) set actions as he was assigned to teach the public this topic a few weeks ago. He has two blog posts on set actions which will delve much deeper than my blog post right now, check them out here and here. Andrew has also written one on proportional brushing here.

In this blog post, I will show you how to use set actions to change the colour scale of your filled maps depending on the locations you choose to lasso.


Let’s start!

Figure 1 below shows a map of Europe with sum of sales on colour (this is EU Superstore). The first step to creating this set action is to create a set. Right-click on ‘State’ which is every region or some sort of chunk within each country and click Create> Set. Select all the “states” and call the field ‘State Set’.

Fig 1. Starting map
Click to keep reading!

Dashboard Week Day 2: Everyone loves a pretty map

My first day of Dashboard Week! Yesterday the rest of DS11 enjoyed vizzing >200M rows of data about snow ploughing while I watched from home (hurray for a coincidental day of annual leave).

 

The Challenge

This morning I was rested and ready to take on the challenges of the week. Today, Andy set us the challenge of analysing New Orleans Police Department (NOPD) body-worn camera data. Now, this would have been super fun and interesting if there was information on the crime that was being recorded, whether this led to an arrest, etc.. but no. As you can see from Figure 1, the data contained information on the times body cams were used, where, how long each video is, when it was uploaded to the system… not exactly the juicy stuff.

 

Fig 1. What’s in this fascinating dataset?

 

Click to keep reading!