table calculations

2022 – Week 14: Can you track headcount?

Introduction This week we are looking at HR headcount data. Headcount data can sometimes seem straightforward to work with, but sometimes the reporting rules can be a bit complicated–particularly with large organizations. This week you will attempt to measure the headcount of a large organization using data from the Real World Fake Data project by …

2022 – Week 14: Can you track headcount? Read More

WOW2022 Week 2: Can you build a weekly Year-over-Year line chart?

Introduction I’m excited to join the Workout Wednesday coaching team this year! For my first challenge, I’m pulling from some recent work experience. Our leadership team wanted to see weekly performance for the week ending Sunday, with the current and prior 2 years in the chart. We also needed to include the YoY% change, and …

WOW2022 Week 2: Can you build a weekly Year-over-Year line chart? Read More

2021 Week 34: How Many Consecutive Starts?

Introduction Today I’m excited to share a challenge in collaboration with Dr. Eric Eager at PFF. PFF analyzes data about professional football (in this case the American version). In this game, there are many players, but the most critical player supports a role called the Quarterback. In this challenge you’ll count the number of consecutive …

2021 Week 34: How Many Consecutive Starts? Read More

2021 Week 33 | Tableau: Can you create a moving average chart with a focus on selected subcategories?

Introduction After the results of the community survey, the top ranked feature was Table Calculations, so guess what? Let’s do some Table Calculations! Click to open in Tableau Public Requirements Dashboard 600 x 600 ONE SHEET Table Calcs ONLY! Create a parameter controlled moving average by month for sales. Create a way to multi-select subcategories …

2021 Week 33 | Tableau: Can you create a moving average chart with a focus on selected subcategories? Read More

2021 Week 27: Can you find the top and bottom performers?

Introduction Like a fine pinot grigio, I really enjoy a good box-and-whisker plot. There is so much good stat stuff in one place like the min/max, median, top/bottom performers, and outliers in the data set.  I have found, however, that they are rarely used and some business end users find them hard to read.    …

2021 Week 27: Can you find the top and bottom performers? Read More

2021 Week 26 – Tableau: Profitability with Dual Axis Charts

Introduction This week we are going to do two things:  look at alternative for the most common scatterplot I see in Tableau. use a very uncommon unsynchronized dual axis chart. First, the chart I always run into is this scatterplot of total sales and total profit by order. While we can see which orders were …

2021 Week 26 – Tableau: Profitability with Dual Axis Charts Read More

Scroll to Top