Table calculations TipMonday #TipWeek

by Benedetta Tagliaferri

As a first tip of the week, I want to focus on a Tableau issue that I encountered while I was studying for the Tableau Desktop Qualification exam.

In our Sample Superstore data, I drag region and sub-category on rows and sales on columns.

What do I get?

tip monday1

 

Now for each region of US, I want to see the top three sub-categories I am selling to.

I have recorded a video to show that.

Let’s have a look:

 

So you basically create a index that rank your sub-categories. Then you edit your table calculation and you create the correct settings.

After that,  you convert rank to discrete and drag it into rows.

At the end you drag rank into filter (first you convert it to continuous) so you can decide the top N you want in your view.

 

I hope this is useful!

 

See you tomorrow!

 

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