Posts tagged Parameters

Week 27: Can you build a dynamic KPI view?

How often do you think about scale? Making sure my dashboards scale over time is one of my top priorities whenever I start a new project, so this week’s Workout Wednesday is going to be focused on building a solution that will scale combined with standard KPI views. I’ve been asked to build KPI views many times in my career, and I’m always looking for ways to inject pieces of interactivity, while keeping the high level view in tact – this challenge should help you think of ways you can incorporate Workout Wednesday directly into your work.

Have fun!

Challenge

Click to view on Tableau Public

Requirements

  • Format: 720x420px
  • Create a summary view that can display the Category or Segment dimension on demand
    • The summary value should represent the profit ratio for the most recent week/month/quarter in the data, depending on what your date parameter is set to
    • The additional up/down number should represent the absolute percentage point change from the previous week/month/quarter
  • Create a dynamic color legend for the Category or Segment dimension members, that highlights the dimension member your user is hovering over
  • Create a line chart that displays the overall profit ratio for the last n weeks/months/quarters (as decided by the slider in the top right)
    • The line chart should also support an additional line for the dimension member your user is hovering over
  • Turn off all the tooltips – you’re welcome
  • Where you are assuming black, use #181818 instead
  • Where you are assuming white, use #e6e6e6 instead
  • Match all other colors as close as you’d like

Dataset

This week uses the superstore dataset for Tableau 2019.1.  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, and @curtisharris_!

Track your progress

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

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 18: Let’s Compare Quarterly Sales Performance

Have you ever been asked to make a tool that allows end users to dynamically select two periods and compare them?  The challenge this week takes inspiration from this all too likely to be asked request.  At surface level it can be an easy ask, but how can you add on additional context along with a responsive and intuitive design that allows for a good user experience.

In this challenge you’ll be creating 3 often used chart types: a line chart, bar chart, and BAN (big ass number).  The twist?  You’ll be adding on custom axes that reference color identifiers throughout the dashboard and ensuring that the most recent quarter selected is always highlighted.  And what happens if someone accidentally selects the same quarter and tries to compare it to itself?  Well you’ve got that covered too with some nice flavor text to help them along.

CLICK TO VIEW ON TABLEAU PUBLIC

 

Requirements

  • Dashboard size: 1500 x 900; maximum of 3 sheets; No text boxes!
  • Create a line chart that does the following after a user selects 2 different quarters
    • Shows the running total of sales by day
    • The older quarter is gray, newer quarter is blue
    • The axis at the top displays dates related to the newer quarter
    • The axis at the bottom displays dates related to the older quarter
    • The tooltip references the order date, # of days into the quarter and the running total sales amount
  • Create a BAN that shows the percentage difference
    • The older quarter is always the “compared to” or prior value
    • When the quarters are the same, text displays “Change Comparisons”
  • Create a bar chart that shows total sales for each selected quarter
    • Bars should always have the blue bar on the right (newer quarter)
  • Create a dynamic title that always shows the newer quarter first and in blue
  • Match all tooltips, labels, and formatting (including axes)
    • Blue: #2cb5c0
    • Gray: #b4b7b7

I highly recommend you view the original on Tableau Public to see functionality in action.

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.