VizWiz

Launch, grow, and unlock your career in data
Showing posts with label table calc. Show all posts

February 25, 2026

How to Build a Quadrant Chart in Tableau | Step-by-Step Tutorial

No comments

In this lesson, I walk through how to build a quadrant chart (4-quadrant scatterplot) in Tableau.

Quadrant charts are one of the most effective ways to compare performance across two measures and quickly identify outliers, opportunities, and risk areas.

In this example, we’re analyzing:

- Profit Ratio
- Average Discount

At first glance, a scatterplot shows the relationship.

But once you add quadrant segmentation, the insight becomes much clearer.

You can instantly see:

- High profit / Low discount performers
- High profit but heavily discounted items
- Low profit / Low discount products
- Low profit / High discount problem areas

Inside the video, I’ll walk you through:

- Creating a Profit Ratio calculation
- Building the base scatterplot
- Adding average reference lines
- Splitting the view into four quadrants
- Categorizing marks based on performance
- Two different ways to build the quadrant chart

This is a foundational analysis technique you can apply to product performance, customer segments, sales teams, marketing channels, and more.

Download the Workbook + Dataset

You can download the workbook and dataset used in this lesson here:
👉 https://nlt.kit.com/quadrant

If you want to go deeper than individual chart techniques, this is exactly the kind of real-world training we focus on inside Next-Level Tableau.

Live classes.
Real use cases.
Advanced techniques you can apply immediately.

Learn more here:
👉 https://www.nextleveltableau.com/


June 30, 2024

How to Rank & Filter the Top 5 in Tableau in Under 60 Seconds!

No comments
In this tip, you will learn how to show the rank of each team in MLB by homeruns for 24 seasons. 

We'll start by computing the RANK table calculation for each Season before filtering to only the top 5 Teams in each Season.

May 3, 2024

How to Make Your Cycle Plots Actionable in Tableau

No comments

Cycle plots are a fantastic way to identify seasonality in a data set. And you can make them even more useful by adding indicators for whether they are above or below the average.

Here's how you can do that in Tableau in only 2 minutes.

Like this? You'll love Next-Level Tableau. Learn more at nextleveltableau.com.

April 13, 2024

25 Example to Help You Master Calculations in Tableau

No comments
I guarantee that if you study these 25 examples, you'll be on your way to mastering Tableau calculations. 

Credits to Sara Hamdoun and Fuad Ahmed.

 

April 9, 2024

How to Create a Floating Bar Chart in Tableau

No comments

A floating bar chart is similar to a Gantt chart, except it shows the range of two data points instead of two dates.

March 11, 2024

#MakeoverMonday 2024 Week 11 - Housing Vacancies in America

No comments
This week I decided to turn Makeover Monday into a Workout Wednesday of sorts. I wanted to try a technique I haven't used in a while...showing elements on either side of a rank and filtering out the rest.

Want to give it  a try? Get the data here.

Requirements:
  1. Size - 1000x475
  2. Max 4 containers; no tiled containers allowed
  3. Filter out Alaska, Hawaii and Puerto Rico
  4. Clicking on a MSA in the map highlights the MSA in the map and bar chart and changes the MSAs that are displayed in the bar chart
  5. The bar chart shows the rank of the MSA for the metric selected.
  6. There should always be 11 bars (though I didn't test the lowest rank).
  7. The label on the end of the bar and in the map reflect the formatting of the measure selected (i.e., either whole numbers or a percentage to one decimaal).
  8. Include an option to change the measure and to change the number of MSAs on the map.
  9. Create a mobile view
  10. NO LODS!

Have fun! 

March 16, 2023

How to Dynamically Resize Marks in Tableau

No comments

In this video, I show you how to resize marks (in this case circles) dependent on how many marks are in the view. For example, if all possible marks are in the view (100%), the circles should be small. If only 10% of possible marks are in the view, the circles should be large.

I show how to do this on a map, but it can be extended to scatter plots, box plots, dot plots, jittered bar chart, and more.

September 26, 2022

#MakeoverMonday Week 39 - Average Internet Speeds Across Europe

No comments

My goal this week was to correct my failures from last week, so I focused almost exclusively on building the starburst/sunburst chart. As promised to the viewers, I will also record a separate tip video for how to build them.

Here's the WatchMeViz and the viz is below that.


September 15, 2022

Table Calculations vs. Level of Detail Expressions - % of Total

No comments
In this video, I show you the difference between table calculations and level of detail expressions with the % of total calculation. I review: 

  1. How to compute a % of total with a table calc 
  2. How to compute a % of total with an LOD 
  3. How filters impact these calculations 
  4. How context filters impact level of detail expressions 
  5. Tableau's order of operations 

Download the workbook here. Download the order of operations chart here.

December 20, 2021

How to Filter by Rank Across Multiple Worksheets

No comments

In this tip, I show you how to use a parameter to filter the rank across multiple worksheets or an entire dashboard.


September 29, 2021

#MakeoverMonday 2021 Week 39 - MLB All-Time Offensive Wins Above Replacement

No comments
This is the final installment of Makeover Monday as a community project and I decided to go back to the very first week of Makeover Monday in 2016 to use as our viz to makeover this week. It's looking at a complicated stat in baseball called Wins Above Replacement, which is basically a measure of how good a player is that an average player that would replace him.

There are several, even more confusing stats included. I thought the easiest way to compare them would be with a scatterplot. So I made an interactive scatterplot that highlights players that are above the average of the top 200 players. 

If you watch the Watch Me Viz video (below), you'll see how I used table calcs to highlight those players and also count the number of players in that quadrant. You'll learn how to use parameters to create a dynamic scatterplot, plus some other bits along the way.

Thanks for coming along on this 300 week journey with me. I hope you have developed your skills and become better at your work. Until next time...


August 31, 2021

How to Compare to the Average with a Bar Chart

No comments

Context is important in data visualization. For every chart you create, consider asking yourself "compared to what?" 

In this tip, I show you how to add context to a simple bar chart by showing whether a value is above or below the average.


July 12, 2021

#MakeoverMonday 2021 Week 28 - COVID Vaccination Rates by Ethnicity and Age in England

No comments
How can ethnic groups be treated differently when it comes to the COVID vaccine? It's terrible! And this data from NHS England clearly demonstrates the racial divisions that exist in this country.

I'm not sure what happened during the recording, but it got split into two parts. Both are below.

Resources:


Thanks for tuning in! Interact with the viz by clicking on the image below or here.



June 1, 2021

How to Calculate the Most Frequent Value of a Measure

No comments
In this tip, I show you how to use both a level of detail expression and a table calculation to compute the most frequent value in a measure. 

First, I show you how to return this as a histogram as well as a single number.

By the end of this tip you will be able to calculate the most frequent quantity ordered. This same process could be used, for example, to compute the most frequent discount. 

May 11, 2021

Threshold Analysis - Level of Detail Expressions vs. Table Calculations

No comments

DS22 is nearing the end of their training and today was a bit of a refresher. One of the questions I wanted them to answer was how many sub-categories in each region had sales above $40,000?

We then expanded that to include (1) the sales for those sub-categories and (2) the % of sales those sub-categories make up of the region sales. They were to complete this using LODs.

As they worked on the task, I thought that this, for sure, could be done with table calculations. This is perfect for the Data School Gym. 

If you know me, you know I love table calculations. And if you know Lorna Brown, you'll know she HATES table calculations. So this is your Data School Gym challenge Lorna.

Of course, everyone is welcome at the Data School Gym. It's actually not that hard and is a good way to help you learn about LODs vs. table calcs.

I'm not too fussed about making it look exactly the same. The point is to see if you can create the identical tables. Enjoy!

April 8, 2021

How to Create a Ternary Graph / Triangular Chart

No comments
Ternary graphs visualise the ratios between the three variables. A ternary graph requires three metrics, plotted as a triangle, where the sum of all three variables adds up to a constant. You can think of it as a three dimensional scatterplot. 

Each dimension is plotted based on its relative variance (on a scale of 0%-100%) to the largest value within the dimension. 

A value plotted near the top would indicate a weighting towards the variable at the top. Likewise, for the bottom right, a value plotted there would indicate a weighting towards the variable that was plotted on the bottom right. A value in the middle, indicates the dimension is balanced across all three variables.

Download the Car Sales mock data set here. Download the triangle I used as the background image on the chart here.

March 23, 2021

How to Create a Parallel Coordinates Plot Over Time

No comments
Typically a parallel coordinates plot compares multivariate, numerical data. However, you may want to create a parallel coordinates chart for a single variable over time. In this tip, I show you how to create that chart.

Resources:

March 19, 2021

#WorkoutWednesday 2021 - Week 2: Customer Lifetime Value (CLTV) Matrix

No comments

If you like a table calc challenge, this Workout Wednesday is for you. Get Ann's requirements here. On the surface it seems pretty simple:

  1. Get the first order date for each customer.
  2. Determine the number of quarters that elapsed since then.
  3. Calculate the cumulative value of each cohort.

Steps 1 & 2 are pretty simple with an LOD and a calculated field. Step 3 is an aggregate calculation that Ann gives a big hint for and then it's cumulative across the view.

The tricky part comes when you try to get rid of any future quarters. The cumulative calc forces each cell to be filled in. The requirements say that you can't show any quarters after the cohort's latest quarter.

This is where the table calc magic happens. When I create complex calculations, I nearly always split them into multiple calcs because (1) they're easier to debug and (2) I can see my progress along the way and see where I am going wrong.

First, calculate the average lifetime value.




Next, calculate each cohort's cumulative lifetime value.


You should now have a view like this with the marks are filled in across the whole table




We need to figure out how to get rid of the marks when they start to repeat after each cohort's last quarter since birth. This is where the complex table calc comes into play.



Add this calculation to the Filters shelf, choose true and you're done! Click on the image below to view my version on Tableau Public.

March 8, 2021

#MakeoverMonday Week 10: Female Participation in the Summer Olympics

No comments

First, thank you to Tommaso Ferri for moderating Watch Me Viz. I enjoyed working with this data set and was able to build nine vizzes in about 40 minutes, then took another 40-50 working through formatting and some pesky table calcs. I got there in the end!

After the live stream ended, I created one more version that uses containers. I think I like this one best. Below you'll find the live stream recording as well as the two final visualizations.

Thanks for watching!







February 16, 2021

Understanding Table Calcs vs LODs: Explained with a Slope Graph

No comments
Table calculations and LODs, especially understanding the difference between when to use each, is one of the most difficult concepts to learn in Tableau. Through my time teaching, one of the most effective means for explaining the differences between them is with a simple slope graph.

The idea is to color each line of the slope graph by whether it represents an increase or a decrease. You'd think this would be super simple, but it's not. In this video, I show you:

1. How to write the required calculations
2. The benefits of table calcs vs. LODs
3. Why table calcs are often more flexible

My general rule of thumb: If all of the dimensions I need for the calculation I want to write are already in the view, start with a table calculation. If all of the dimensions I need are NOT in the view, then you must use a level of detail expression.

Download the sample data set here - https://data.world/vizwiz/car-sales-mock-data