# table calculations

## 2022 – WEEK 44: What is the lifetime value of customers?

Introduction This is probably my favorite challenge of the year. So i’m saving it for near the end. You’ll need level-of-detail and table calculations to solve this one. For this challenge you need to calculate customer lifeftime value (in sales). While their are many ways to do this. We are going to keep this as …

## #WOW2022 | Week 43 | Selected Subcategory Influence

Introduction Hi Workout Wednesday friends!  I’m back, just in time for the Tableau 2022.3 release, which means we’ll be exploring Dynamic Zone Visibility.  This new feature allows you to use calculations and logic to dynamically show and hide dashboard elements (pretty powerful).  So in this challenge, you’ll get some hands on exposure to this new …

## #WOW2022 | Week 42 | Can you use Tableau to estimate Aaron Judge’s home run trajectories?

Introduction Hello there, Workout Wednesday #DataFam! This weekâ€™s challenge is all about two of my passions growing up: baseball and physics. This past baseball season, New York Yankees outfielder Aaron Judge broke the 61 year old American League record for home runs in a single season set by Roger Maris in 1961 – Judge concluded …

## #WOW2022 W38: Can you create a Waterfall Pipeline using Salesforce Data?

Introduction This week is Dreamforce; Salesforce’s conference. So I thought I would stay on theme and use Salesforce Data. When I first started to see Salesforce pre-built dashboards they included several elements, but the one we are going to focus on today is the Waterfall chart. This allows us to see how much value is …

## #WOW2022 Week 36: Let’s build a Marrimeko Chart

Every needed to visualize a % of total across two dimensions & measures? Then the Marrimeko chart is what you need! Check out this week’s #WOW2022 challenge for a throwback to 2017 week 8

## 2022 – Week 34: What is the average occupancy by weekday?

Introduction This week we return to another business-specific challenge. This team we will explore hospitality data. The goal of this challenge is to determine what the average occupancy is by day at three different properties. The challenge of this data is that you’ll only ever know when customers check-in or check-out. Not the actual total …

## #WOW2022 Week 31: Let’s build a KPI dashboard

Introduction Who doesn’t love a good KPI dashbaord? This one is fairly simple and straightforward. Let’s look at four simple metrics and see how each subcategory ranks within a selected metric. With this challenge – MIND THE NUMBER FORMATTING đź™‚ Click to open in Tableau Public Requirements Dashboard Size: 700 x 350 2 sheets Display …

## #WOW2022 Week 22: Can you maintain rank?

Introduction This week’s challenge was inspired by one of the charts Ann Jackson used in her Advanced Speed Tips session with Lorna Brown. If you had a chance to watch live or virtually, you know it was an awesome session with some great tips and techniques (so if you haven’t seen it yet, you should …

## 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 …

Watch

Scroll to Top