#WorkoutWednesday 2018 – Week4

This week we are just building a simple text table……with a twist of course.

Requirements

  • 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

Data can be found at Data.World

Be sure to tag myself (@RodyZakovich) and Luke (@LukeStanke) on Twitter

8 thoughts on “#WorkoutWednesday 2018 – Week4”

  1. I really wanted to just write SQL code and display the results in Tableau…but I played nice and did it in Tableau only.

    [Link toViz]https://public.tableau.com/profile/fritz.von.mundorff#!/vizhome/WorkoutWedsWeek4/Results)

  2. Hi guys,
    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.
    https://public.tableau.com/profile/antonio.jose.gonzales.alves#!/vizhome/WorkoutWednesday2018Week4-CustomersgoUP-failed/IncreasingCustomers?publish=yes

    Thanks in advance.
    Antonio

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Scroll to Top