# table calculation

## #WOW2022 | Week 45 | Average Patient Waittimes

Introduction This week’s challenge was derived from a project that I helped some colleagues with. My colleagues were working on a client project for a travel company. They wanted to be able to compare a selected “Event Date” with an average travel day. The aim was to see if and how travel patterns might be …

## #WOW2022 | Week 03 | Can you visualise percent difference from a selected date?

Introduction I can’t believe I am entering my 4th year as a Workout Wednesday coach. It has been such an incredible journey so far. I bet you think how do we come up with the challenges all the time? Tableau has such a broad range of calculations and different ways of doing things so that …

## 2021 Week 1: Can You Find the Variance Along the Line?

Introduction For the longest time, I avoided table calculations as much as I could because I thought they were overly complicated (compute using…relative to…sort by…nested…ughhhh) especially when I had LODs in my back pocket.  But, over time, I’ve made my peace with them (dare I say, a fan now) as I recognized how powerful they …

## 2020 Week 31 LIVE: Can you show the top 10 rank over time for each Olympic country?

Introduction For this weeks challenge we are doing a Live collaboration with Preppin’ Data. Where you work through the data prep and then use the outputs to build in Tableau. This is a live event happening on Wednesday 29th July 2020, 4pm BST. The idea of the collaboration allows you to have a look inside …

## Week 48: Profitability Bridge

This week we’re building a chart I was asked to create at work. A stakeholder drew this exact chart type and said, “make the chart look exactly like this!” At first glance I wasn’t sure I would be able to do it. After a little playing around I was able to re-create it! Challenge Click …

## Week 46: America’s Aging Population

It’s been way too long since I’ve given you all a challenge. I’ve really enjoyed learning set actions the past two weeks, but if you know anything about me, you know I love table calcs. So guess what? I’m back with a table calcs challenge for you; I know deep down you’ve missed them. In …

## #WorkoutWednesday 2018 – Week 3

Rody kicked things off last week with the running_sum() function. This week your challenge will be with both parameters and the window_sum() function. This visualization may look simple but it was a challenge for both Rody and myself (You’ll probably see a variant of this later this year). Requirements Data should be aggregated to the …

## #WOW2017 | 43 | Rolling Calcs

Introduction This challenge is hosted on Andy’s website – check it out here  Click to open in Tableau Public Attribute When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration.  Also include the hashtag #WOW2017 in your description to make it searchable! Share After …

## WOW2017 | 15 | Table Calcs vs LODs

Introduction This challenge is hosted on Andy’s website – check it out here  Click to open in Tableau Public Attribute When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration.  Also include the hashtag #WOW2017 in your description to make it searchable! Share After …

Scroll to Top