Introduction This week’s challenge is one I’ve been waiting to share with you. It has a bit of everything, so I hope you enjoy it! The goal is to visualize the Sales in a given year for different countries in Europe, with an indicator in the tooltip to identify whether this value has increased or …
#WOW2023 | Week 3 | Calculating Year-On-Year Percentage Change Read More
Introduction This week’s challenge is brought to you by a guest coach, my colleague Valerija Kirjackaja, who came across this problem at work and created a beautiful solution for it. How often do you get asked to re-create Excel tables in Tableau? On a scale from 1 to ‘I am never doing this again’ – …
#WOW2022 | Week 35 | Conditional Table Formatting with Dynamic Headers Read More
Introduction I’ve been wanting to create this challenge for some time, so I’m really glad to finally be releasing it. This challenge was inspired by some work I did last year where a client wanted to be able to visualize the number of hours that their team had spent working on different projects. What made …
Introduction Working with financial data is hard. There are some calculations that make for long evenings to get right. One of those calculations is Time-Weighted Return. This challenge is simple: calculate the Time-Weighted Return Rate for a simple data source and return a line chart. Click to open in Tableau Public Requirements Dashboard Size: 400px …
Introduction My second favourite challenge in Tableau, after Table Calculations, is anything with Set Actions. Some of you may have already used these in previous challenges this year, but this week I am dedicating it to this wonderful (and sometimes tricky) Tableau functionality. Warning: this is not a beginner-friendly challenge! The problem I wanted to …
#WOW2022 | Week 25 | Double drill-down with Set Actions Read More
Introduction For the last week of 2021 we’ve got a straightforward challenge: create a table with one measure. For fans of the (The Great British) Bake Off note the simple instructions for this technical. Click to open in Tableau Public Requirements Dashboard Size: 1000px by 600 px Match the values in the table using Sales, …
WOW2021 – Week 52: Can you build a table with one measure? Read More
Introduction The goal is a modified mekko chart. My guess is you will need LODs to solve but it is 100% possible with table calculations. Click to open in Tableau Public Requirements Dashboard Size: 800px by 400 px Set the bar height to be percent profitable. The level of analysis should be at the sub-category …
2021 Week 13 | Tableau: What percentage of sub-orders are 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
My personal favorite Workout Wednesday challenges are those that come straight from the workplace, this is one of those weeks. Just recently I was asked to produce a very similar visualization, but with the affordance of my good friend Alteryx. For this challenge, all of the data prep has to be done in Tableau, without …
