Introduction Sometimes you want to make fun charts, but life gives you tables. This challenge is another real-life challenge I’ve encountered through Dr. Alicia Bembenek: show a table, but only highlight a subset of the products. An innocent challenge that is actually more difficult than it first appears. –LS. Be sure to check out the …
2020 Week 18: Which products were most profitable? Read More
Introduction My second challenge for the year!!! This week we are looking at calculating Run Rate based on Weekdays. This challenge is a real time work scenario that I came across last week and it was bit of a struggle to get it working based on just the weekdays. My solution might be a bit …
Introduction This week I was challenged with building a chart which shows an Adjusted target and the missing pipeline if targets were not met. So I challenge you, can you adjust the targets and show missing pipeline from the adjusted target. Click to open in Tableau Public Requirements Dashboard Size: 800 x 600 px # …
2020 Week 16: Can you show the adjusted target & missing pipeline? Read More
Introduction Hello Everyone! First – I want to say that I hope you and your loved ones are happy, healthy, and safe during this time. It’s amazing to think when I posted my last workout just 4 weeks ago, that the world (at least mine) looked completely different. I want you to know that you’re …
2020 Week 15: Can you create a chart with a dynamic week start? Read More
Introduction One of the most common questions I get is how to build a sales funnel. I always answer: just build a bar chart! That’s what we are going to do today. To build that sales pipeline we are going to have data where we know the latest stage, but it doesnt track the previous …
Introduction My first WorkoutWednesday challenge for the year! This week let’s create a simple Sales dashboard with some of the key KPI metrics. We will be using the superstore data set showing how the Sales and Profit are performing. Click to open in Tableau Public Requirements Dashboard Size: 800px by 600 px # of …
2020 Week 13 Do you want to build a simple Sales dashboard? Read More
Introduction It’s good to be back WOWsers. This week is looking at showing missing selected periods and autosizing bars based on the selected period (Monthly, Weekly, Daily). It also gives Set Actions some love. The dates idea came from Michael McFadden. Click to open in Tableau Public Requirements Dashboard Size: 1000px by 600 px 2 …
Week 12 2020: Can you show missing selected periods and autosize bars? Read More
Introduction I’ve heard rumblings that the past few weeks have been a little difficult – so this week I’ve decided to keep it simple. The final visualization comes from something I encountered recently. I have a client that works with data that is very volume specific per day, so they wanted a way to quickly …
Introduction But first… Well, this is it! This week marks my final WorkoutWednesday challenge. Its been so much fun contributing the last couple of months, I hope you enjoy my challenges. But I’ve still got one more, this one. So let’s get to it. The Challenge If you haven’t heard, Tableau version 2020.1 has been …
WOW2020 Week 10: Can you use spatial BUFFER() functions in 2 ways? Read More
Introduction I’m not going to hide it: this week will be hard. But this challenge is inspired by real events. In the four months I’ve helped solve various versions of this same problem: how do you do nest a table calculation inside of a level-of-detail calculation? You don’t. But you can nest table calculations–which is …
