WorkoutWednesday S02 E4

Do you enjoy working with Tableau? Are you looking for an additional challenge? Workout Wednesday might be what you need. WorkoutWednesday a set of weekly challenges from  Andy Kriebel and Emma Whyte (for 2017) and Rody Zakovich and Luke Stanke. (For 2018) designed to test your knowledge of Tableau and help you improvise your development skills. The idea is to replicate the challenge that they pose as closely as possible. When you think you have it, leave a comment with a link to your visualization and post a pic on Twitter for others to enjoy.

2017 WorkoutWednesday Challenge: Link

2018 WorkoutWednesday Challenge: Link

This week Rody and Luke asked us to build a simple text table with a twist of course.

Workout Wednesday Week 4 Challange: Link 
  • Show a table of Sales by Customers and Years
  • Only Include Customers whose sales have increased each year from 2014-2017
  • Sort them by their 2017 Sales amount

The Twist

  • You cannot use any LoD Calculations
  • You cannot use ant Table Calculations

Step 1:

As per the instruction, you can use your own Superstore Data or you can use the dataset available at Data.World

First, create an account on Data.World and copy the tableau link by clicking on the Download icon as per the below image.

The moment you click on “Tableau Icon”, a new Popup will open which contains a connector URL.

Copy the highlighted URL and open the web Connector API.

Paste the Copied URL and Press Enter. Now your Tableau is connected to the given dataset.

Step 2:

Read the requirements carefully and try to replicate all the required the steps.

Create a Crosstab that displays Sales by Customers and Years.

Step 3:

Create each year Sales as per the below Image.

Step 4:

Now we need to create a calculated field that gives us all the Customers whose sales have increased each year from 2014-2017.

Let’s create three different sets based on each year sales and then drag on the Filter shelf.

These conditional Sets will give you your end result. Make sure to sort your customer based on 2017 Sales.

Step 5:

Even without creating a set we can achieve the above result. Drag Customers to the Filters shelf and write the logic as per the below image.

Related Posts


About the Author: Rajeev Pandey

I am a multidisciplinary designer working in data visualization, interaction design and innovation. Expertise in developing Tableau, Web focus based visualization and reporting applications. I have a passion for analyzing, dissecting, and manipulating data sets as well as, building beautiful dashboard. Naturally talented in communicating between technology and business needs. Diverse and experienced in plenty of different domains .I am quick learner who can absorb new ideas and can communicate clearly and effectively.I love creativity and enjoy experimenting with various technologies.

Leave a comment

You must be logged into post a comment.