Week 04: Can you combine relative and custom dates?

4 Comments / Tableau, Workout Wednesday / By

Introduction

Well here we are! My first week as an “official” contributor of #WorkoutWednesday! I’m so excited to share my three (3) challenges with you so let’s get to it with the first one. In my day to day life at Cerner, I build analytics that cast a wide net of user personas with all types of different questions of the same data. And as such, the overwhelming majority of my dashboards have custom date filters where each user can go in and select their own date range that they need and every one’s happy. However, I’ve always thought it would be nice to provide “quick” filter options while still allowing for custom date ranges. If you’ve worked with dates in Tableau you know there’s no native way to dynamically flip between relative and custom dates.
 
And that’s what this challenge will focus on. Giving your users the experience of selecting between relative and custom date ranges.
Click to open in Tableau Public

Requirements

    • Dashboard Size: 1100px by 800 px
    • # of Sheets – up to you
    • Create a Row of KPI BANs – #049DA5
      • Total Sales
      • Profit Ratio
      • Total Profit
    • Create an outlined area chart showing Sales by day
      • #049DA5
    • Add in a dynamic button to select the date range
      • Last 14 Days
      • Last 30 Days
      • Last n Days
        • When selected the user should be able to type an integer
        • When not selected, the integer box should not be visible
      • Custom Date Range
        • When selected, the user should be able to select a start date and an end date
        • When not selected, the date selectors should not be visible
    • The “Last …” selections should be anchored to the max date of the dataset
    • Match formatting and tooltips

Dataset

This week uses the superstore dataset for Tableau 2019.4. 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.  Also include the hashtag #WOW2020 in your description to make it searchable!

Share

After you finish your workout, share on Twitter using the hashtag #WOW2020 and tag @AnnUJackson, @LukeStanke, @lorna_eden, and @HipsterVizNinja

Solution

Interactive