# table calculations

## 2020 Week 32: COVID-19 New Case Trends

Introduction This week I wanted to post a WOW challenge derived from a chart I’ve been reporting on for the past 7 months: a cartogram of states showing rolling-seven day average of new COVID-19 cases by state. For this challenge you will use data from Tableau’s COVID-19 Data Hub. I picked this challenge because working …

## 2020 Week 27: What is the distribution of total orders by customer?

Introduction After many weeks of practical challenges. I’ve decided to switch it up this week. If I’m being honest I’ve been saving this challenge since August of last year (it’s still not the oldest challenge I am saving). This weeks challenge is to make a symmetrical dot plot. Not only is the dot plot symmetrical …

## 2020 Week 24: Can you compare a 3-day vs. 14-day moving average and describe the latest trend?

Introduction I’ve got an exciting challenge for you this week!  It involves collaboration with a peer of mine in the data community (Jami Delagrange, who you may recognize as an upcoming Community Month contributor) and also a challenge that involves working with COVID-19 data. This built-for-mobile dashboard was born out of seeking to understand the …

## 2020 Week 18: Which products were most profitable?

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 …

## Week 9: What is the 90 day reorder rate?

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 …

## 2020 week 8: Can you create a concatenated list of values?

There is still a need for legacy reporting, how can we use Tableau to create a report where one row contains all the data? Here’s how to create a concatenated list of values

## Week 5: Where do regions rank month-to-month?

Introduction This week I wanted to share a challenge that comes from a chat that I had with Zach Bowders near the beginning of the year. Zach was shared a step-ranking visualization he was putting together and I really thought it was a great iteration of the chart type.  While there have ben step-ranking charts …

## Week 48: Can you build a Bar Chart that automatically combines small contributions?

How much information have you retained from Tableau Conference 2019?  Are you still watching session videos (like I am?).  This challenge is an homage to the amazing conference from this year. The challenge comes from something I encountered in a recent work situation.  The end-user wanted to be able to automatically group together small contributing …

## Week 42: Can you build a comparative line chart with dynamic inputs?

This week’s challenge is taken directly from a situation I recently had on a project.  The goal of the project was to be able to isolate out time periods of a specific length and compare it to the time period directly before it.  So as an example, if it’s October 2019, I want to look …

## Week 38: Can you build a sales comparison chart with performance indicators?

This week I’m tackling a topic that nearly everyone has been asked – visualizing good/bad as performance indicators that are red or green.  At least here in the western world, the busy executive tends to think about things in terms of traffic lights.  So this week your task is to create something that satisfies their …

Scroll to Top