When use what? - Part 2

by Benedetta Tagliaferri

CONTEXT FILTER

 

For the Data School second week project, we analysed refugee’s data, in order to get some insights about their routes and numbers of this human tragedy.

In my specific case, I tried to make a macro picture of the Mediterranean countries and I used a dataset showing the main cause of deaths of people, trying to reach Italy, Greece, Spain and Malta.

I wanted to show the top 10 in sum of deaths among the cause of deaths. But if you want to filter more than one thing you need to discover these three words: ADD TO CONTEXT.

 

1

 

Let’s imagine I want to show the top ten (filter -> top 10 by SUM of deaths), I get the first problem:

Lots of unknown.

What I can do is to create a set that exclude unknown and drag it in filter.

 

2

 

Now unknown is not there any more, but you have 9 instead 10. You need to click on “without unknown” in filter and click “add to context”.

This will establish an order of commands in tableau, like if you say first remove unknown data then make the top 10.

Now let’s suppose I have more than one year in the data and I just want to show 2015 top 10 cause of deaths.

I will drag Year in filter but then Tableau will automatically make the top ten within all years and will show you just the value that are present in 2015.

 

3

 

So again if we want top 10 (and not top 7 ) you have to click ADD TO CONTEXT.

 

4

 

Thanks and have a lovely Christmas!

 

Avatar

Benedetta Tagliaferri

Machine Learning 101: the Cost Function or Squared Error Function

2 mins read

Sun 06 Mar 2016

How to add an Academy Award to an Oscar-nominated Film

1 mins read

Thu 03 Mar 2016

Machine learning 101: a really simple explanation about Linear Regression

3 mins read

Thu 25 Feb 2016

How to download Json files in Alteryx Tip Thursday #TipWeek

1 mins read

Thu 18 Feb 2016