This week we are just building 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
10 thoughts on “#WorkoutWednesday 2018 – Week4”
Nice challenge. Very subtle solution that might trip people up…I love those! http://www.vizwiz.com/2018/01/workout-wednesday-week-4-2018.html
I really wanted to just write SQL code and display the results in Tableau…but I played nice and did it in Tableau only.
Here’s my version:
(i’m catching up!)
I finally got it!
Is the soultion posted after Wednesday?
You can download the solution at anytime from the Tableau Public links.
I liked this challenge and I did it after had a look at the solution.
However, I couldn’t understand why I need to use a “set” otherwise it will not work.
In my mind, a calculated field like below being a filter of TRUE should work.
[sum2015]>[sum2014] and [sum2016]>[sum2015] and [sum2017]>[sum2016]
But not…Just when I use this calculated field inside a “set”.
Why is this?
I posted my failed solution as well and maybe someone can have a look at it.
Thanks in advance.
Where can I find the solution for this? Please help!
I’ve searched for it too!
Click on the image in the task ;))
Didn’t really get the limitations of this one. After reviewing other people’s solution, it looks like calculations were used by all: https://public.tableau.com/views/WOW2018-Week4-TrickySimpleTable/WOW2018-Week4?:language=en-US&:display_count=n&:origin=viz_share_link