This week we’ll be taking inspiration from a chart you are likely familiar with, Google’s “Is it busy?” chart. This visualization is probably my favorite Google feature, outside of the dinosaur run game of course, so I felt like it was time to turn it into a Workout Wednesday challenge. Can you figure out if Superstore was busy or not?
- Format: 800px by 450px
- Create a histogram that displays the average number of daily orders for each day of the week
- Overlay a “selected date” bar that displays the number of orders for the day in question
- Only display bar labels for the “selected date” bar
- Make sure the y-axis always extends to the highest value the “selected date” bar could be
- If the day’s order count is the highest value it could be, label “as busy as it gets”
- If the day’s order count is 80% or more of the highest value it could be, label “very busy”
- If the day’s order count is 60-79% of the highest value it could be, label “pretty busy”
- If the day’s order count is 40-59% of the highest value it could be, label “busy”
- If the day’s order count is higher than the average day, label “busier than normal”
- If none of the above, label “not busy”
- Provide the contextual text below histogram
- Do not use any table calculations
- Match formatting as closely as possible
This week uses the superstore dataset for Tableau 2018.3. You can get it here at data.world
Track your progress
Also, don’t forget to track your progress using this Workout Wednesday form.
When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration.