Posts tagged set actions

2019 Week 14: Can you build a line chart with dynamic highlight and comparison?

Care to join me on an adventure to the dark side?  While it’s true I might not yet have the Sith skills of Curtis when it comes to the dark side, I’ve decided to tip the balance of the force toward the dark this week.

The workout this week combines a few concepts inspired by a recent work project someone shared with me.  The inspired ask was to create a way to have more user-driven comparisons while retaining other peer information in the background.  The end user experience was to be very direct – the user should know what has been clicked and more supporting information should appear in context.  The resultant dashboard serves up a fun (and colorful) way to dynamically highlight subcategories for comparison while revealing their monthly averages.  Per usual, the devil’s in the details on this one, so make sure you study the final requirements and dashboard carefully.

Click to View on Tableau Public

Requirements

  • Dashboard size: 1300 x 1000; no more than 3 sheets
  • Limit data to 2018, Office Supplies
  • Create a line chart that does the following
    • When clicking on a subcategory at the top, the chosen subcategory will highlight teal and an average line will appear
    • The chosen subcategory will disappear from the bottom selections
    • The chosen subcategory will move to the far left and be teal (remaining sort is ascending by sales)
    • When clicking on a subcategory at the bottom, the next chosen category will highlight hot pink and an average line will appear
    • The bottom chosen subcategory will disappear from the top selections
    • The chosen subcategory will move to the far left and be hot pink
  • When one or more lines is highlighted, the non-highlighted subcategories will change to a darker gray
  • Dark mode
    • Background: #555555
    • Teal: #00c0c6
    • Hot Pink: #f0007b
    • Gray 1: #959595
    • Gray 2: #757575
  • Match all tooltips, labels, and formatting

Dataset

This week uses the superstore dataset for Tableau 2019.1.  You can get it here at data.world

Attribute

When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration.

Share

After you finish your workout, share on Twitter using the hashtag #WorkoutWednesday2019 and tag @AnnUJackson@LukeStanke@lorna_eden, and @curtisharris_!

Track Your Progress

Also, don’t forget to track your progress using this Workout Wednesday form.

2019 Week 8: What percentage of products make up 80% of sales?

For this week’s workout, we look at one of my favorite chart types, the pareto. I love the pareto chart as a data exploration resource, and also as a powerful analytic resource. If you aren’t familiar with the pareto, the purpose is to see what % of x, makes up what % of y, with the common assumption that 20% of the x makes up 80% of the y. This week’s workout takes this chart a couple steps further by identifying the point where the % of x crosses 80% of the y. We will also give our users the power to drill into the actual values of any subset of the x. A key piece of this challenge is using Tableau’s built in functionality to your advantage, try and build this viz with two or less written calculated fields!

Have fun!

Requirements

  • Dashboard size is 1200×500 – 2 sheets
  • Place a circle on the mark where the % of Total Products crosses the 80% of Total Sales threshold
  • Place a reference line at 80% of Total Sales and 20% of Total Products
  • Use Tableau’s out of the box features – only two written calculated fields allowed
  • Dynamically show/hide selected products from the pareto chart
  • Make sure there is 15px of inner padding on all sides of your worksheets, and the left and right sides of your title and line separator
  • Match colors, tooltips, fonts, and formatting

Dataset

This week uses the superstore dataset for Tableau 2018.3.  You can get it here at data.world

Attribute

When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration.

Share

After you finish your workout, share on Twitter using the hashtag #WorkoutWednesday2019 and tag @AnnUJackson@LukeStanke@lorna_eden, and @curtisharris_!

Track Your Progress

Also, don’t forget to track your progress using this Workout Wednesday form.

2019 Week 2: Order Sales Spread by Region

Happy New Year!  It’s time for my first Workout Wednesday of 2019 and I hope you’re ready for a challenge.  This week I’ve decided to take inspiration from a trick or two from past workouts and combine them with some recent work I’ve been doing.  To be more specific, one thing about Tableau that I like is that you can set independent axes for continuous measures if you’ve got headers on the same shelf (rows or columns).  But what if you wanted to have independent axes and headers aren’t on the same shelf?  The workout this week explores that idea and puts it to the test – I’ll be honest, the jury is still out for me on if this works well with the Superstore data set, but I can absolutely see value in this if we were to have a similar metric with extremely varied ranges.

In addition to exploring how to get over that obstacle, I also wanted to play around with date filtering.  This week you’ll be exposed to a user-friendly calendar that doubles as a filter OR highlighter.  I’ve found that it represents a great way for end users to freely pick a single date, multiple dates, date ranges, random individual dates – pretty much any combination that they would like.  Calendars are also familiar visualizations of dates, so I think it’s quite comforting – and additionally it serves as another layer of information – when there isn’t any data, there isn’t a square for the date.

 

click to view on Tableau Public

Requirements

  • Dashboard size: 1200 x 800, jitterplots must be one sheet, everything else is up to you
  • Create a jitterplot that shows sales by order ID (no need to worry if your jitter isn’t exactly the same as mine)
    • Ensure that each plot behaves as if it has an “independent axis” and spans the extent of data within each region
  • Create a calendar view that can be used as a filter or a highlighter
    • When used as a filter, chosen dates will filter the jitterplot
    • When used as a highlighter, chosen dates will change to a darker color in jitterplot
  • Create a footnote that is responsive to the date selection
  • Create average line & callout that are responsive to date selection
  • Match colors & tooltips please 🙂

Dataset

This week uses the superstore dataset for Tableau 2018.3.  You can get it here at data.world

Attribute

When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration.

2019 Week 1: Sales Drill Down

We’re back for 2019. We’re using the hashtag #WorkoutWednesday2019. The challenge this week involves building a dynamic drill-down table. This one is slightly more difficult than average so be sure to check the spoilers at the very bottom if need be.

Challenge

 


 

Click to view on Tableau Public

Requirements

  • Dashboard size is 500px wide by 600px tall.
  • Create a table that shows sales for category and year. When you click on a category show the sales by sub-category below it.
  • Use the right arrow “►” and the down arrow “▼” to indicate when details are showing. This makes it look like an accordion.
  • Match row borders and row shading to highlight these values.

Dataset

This week uses the superstore dataset for Tableau 2018.3.  You can get it here at data.world

Share

After you finish your workout, share on Twitter using the hashtag #WorkoutWednesday2019 and tag @AnnUJackson, @LukeStanke, @lorna_eden, @curtisharris_, and @VizWizBI!

Track your progress

Also, don’t forget to track your progress using this Workout Wednesday form.

Spoilers

  • Union the data to itself one time.
  • One part of the union will create the summary for category and the other will create the summary for sub-category.

Week 47: Unit Volume Comparison

Why wait for 2019 when I can start challenging you all right now? I’m not quite ready to jump off the set action hype train yet, and this challenge is setup to help you think about some different ux/ui capabilities that set actions can enable. I don’t anticipate this being the most difficult challenge you’ve faced… so grab a drink, sit down, and let’s get to work.

click to view on Tableau Public

NOTE: I disabled download on the workbook on Tableau Public to force you to think through the solution. Yes, I know it’s mean, but you’ll learn more this way. I’ll turn on downloading toward the end of the week.

Requirements

  • Dashboard size: 900 x 700
  • Use no more than 3 sheets
  • Match text formatting and colors (doesn’t have to be exactly the same)
  • Give every object some room to breath from the edges of the dashboard… 25px sounds about right
  • Summary numbers and highlights should line up perfectly; only separated by the borders of the highlights
  • Try and use set actions to match the functionality
  • Do not display headers for the summary number section
  • Add context to the summary numbers in the leftmost cell only
  • Make sure the word UNITS appears next to the nearest 500 of the highest point on the line
  • Show labels for matching months on hover… if you hover over June 2018, we should see labels for all of the June points
  • Match line/area chart look and feel

DATA SET

Data from this week comes from the Saved Data Source in Tableau 2018 (Sample – Superstore), download here if needed.

SHARE

After you finish your workout, share on Twitter using the hashtag #WorkoutWednesday2018 and tag @VizWizBI, @AnnUJackson, @LukeStanke, @RodyZakovich, @lorna_eden, and @curtisharris_.

TRACK YOUR PROGRESS

Also, don’t forget to track your progress using this Workout Wednesday form.