calculations

2024 Week 45 | Sigma: Can you create these patient demographic visuals? 

Sigma, Workout Wednesday / By

Introduction Hey everyone! This week’s Workout Wednesday focuses on creating clear, actionable patient demographic visuals using a Sankey, a KPI, and two bar charts—binned and unbinned. Here’s the setup: the Sankey chart helps us map distribution, while the KPI delivers an at-a-glance view of a key metric to ground the analysis. With the bar charts, …

2024 Week 45 | Sigma: Can you create these patient demographic visuals?  Read More

2024 Week 41 | Sigma: Can you create a dynamic column bar chart? 

Sigma, Workout Wednesday / By

Introduction For this week’s challenge, we’re creating a dynamic column bar chart. The end user can select the number of columns to split the data into. Note that there are only 37 States in the Plugs data, so do your best not to hard code anything for a more realistic use case! Have fun!-Katrina Need …

2024 Week 41 | Sigma: Can you create a dynamic column bar chart?  Read More

#WOW2024 | Week 11 | Can you filter a Small Multiples chart?

community, Tableau, Workout Wednesday / By

Introduction I may have gotten a little overexcited with this challenge by combining TWO problems that some of my colleagues came up against recently when trying to solve problems for their clients. That being said, this week’s challenge should be a good workout. Since the challenge applies some more advanced calculations, I have broken down …

#WOW2024 | Week 11 | Can you filter a Small Multiples chart? Read More

#WOW2023 | Week 3 | Calculating Year-On-Year Percentage Change

community, Tableau / By

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

#WOW2022 | Week 35 | Conditional Table Formatting with Dynamic Headers

1 Comment / Tableau, Workout Wednesday / By

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

#WOW2022 | Week 30 | Dynamic Dates in a Heatmap

1 Comment / Tableau, Workout Wednesday / By

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 …

#WOW2022 | Week 30 | Dynamic Dates in a Heatmap Read More

2022 – Week 29: What is the Time-Weighted Return?

Tableau, Workout Wednesday / By

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 …

2022 – Week 29: What is the Time-Weighted Return? Read More

#WOW2022 | Week 25 | Double drill-down with Set Actions

1 Comment / Tableau, Workout Wednesday / By

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

WOW2021 – Week 52: Can you build a table with one measure?

Tableau, Workout Wednesday / By

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

Scroll to Top