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
This week Rody and Luke asked us to build a simple text table with a twist of course.
- 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
- You cannot use any LoD Calculations
- You cannot use ant Table Calculations
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.
Read the requirements carefully and try to replicate all the required the steps.
Create a Crosstab that displays Sales by Customers and Years.
Create each year Sales as per the below Image.
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.
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.
Leave a comment
You must be logged into post a comment.