The Chart That Replaced My Stacked Bar (Marimekko Alternative)

3:46

The Chart That Replaced My Stacked Bar (Marimekko Alternative)

Andy Kriebel 12.05.2026 976 просмотров 14 лайков

Machine-readable: Markdown · JSON API · Site index

Смотреть на YouTube

Поделиться Telegram VK Бот

Транскрипт Скачать .md

Анализ с AI

Описание видео

Stacked bars are fine. But once you need to compare proportions across groups AND show the actual totals, they start to break down. This is the chart that replaced it. In this tutorial, you'll build a Marimekko alternative in Tableau that shows the proportional breakdown of each group by light conditions — with the total count for each group displayed directly on the chart. It's a technique straight from a Next Level Tableau class, and once you build it, you won't go back. What you'll learn: - How to set up the base chart and sort groups by volume - Building a running total calculation and placing it on columns - Using fixed size with right-alignment to create the Marimekko bar effect - Nesting a running total inside a percentage-of-total calculation and why two separate table calculations are required - Configuring compute-by settings for both the column axis and the size shelf - Adding a reference line from the Analytics pane to show group totals - Formatting so the totals sit cleanly above the bars without clutter If you're comfortable with table calculations and want a more powerful alternative to the stacked bar, this one belongs in your toolkit. To follow along, download the workbook and data at https://nlt.kit.com/marimekko CHAPTERS 00:00 Intro — What we're building and why 00:24 Base chart setup — columns, rows, sort by accidents 00:56 Create the running total calculation 01:22 Form the Marimekko shape 01:28 Configure nested table calculations 02:17 Why two separate table calculations are required 02:52 The Marimekko is built 02:59 Add reference line for group totals 03:36 Final result + formatting tips 03:43 Wrap-up The analysts who stand out aren't just technically skilled — they build things others haven't seen before. That's exactly what Next Level Tableau is built for. Join us at nextleveltableau.com. Key skills: Table calculations, running totals, percent of total, nested calculations, reference lines, Marimekko chart, advanced chart design #TableauTips #DataVisualization #TableauAdvanced #NextLevelTableau #MariMekkoChart ---------- To go deeper, check out my courses: → Tableau Starter Kit - A beginner-friendly course designed to help you understand Tableau quickly - https://www.nextleveltableau.com/starterkit → Tableau Core Concepts - A comprehensive, self-paced course for Tableau users ready to level up - https://www.nextleveltableau.com/tcc → Join Next-Level Tableau - My most comprehensive Tableau program to help analysts become industry leaders, with the support of a like-minded community, and 1-to-1 help from me - https://www.nextleveltableau.com/ 📩 The Dual Axis Newletter Each week, I'll send you Tableau tips, tutorials, and strategies to design better dashboards, have more impactful, and stand out in your career: https://nlt.kit.com/ 🔽 Connect With Me • Official website - https://www.nextleveltableau.com/ • LinkedIn - / andykriebel #tableau #dashboard #tutorial #beginner

Оглавление (9 сегментов)

Intro — What we're building and why

Okay, so today's video is for Neha. This comes from straight from a next level Tableau class and she wants me to remind her how we build this Marimekko alternative which in the background shows you the total number of accidents within each rural or urban group and then it splits it up into a Marimekko chart inside of each of those that split up by the different light conditions.

Base chart setup — columns, rows, sort by accidents

So we're going to start with a new sheet. So let's start by grabbing rural and urban group and putting that on the columns. And then we're going to sort that by the number of accidents. So I'm going to sort it by a field descending order and number of accidents. Okay, perfect. And let's grab our number of accidents and put that on the rows. And now we want to split this up by the light condition. So let's grab that onto color and we get something like that. But what we want to be able to do is split these bars up side by side.

Create the running total calculation

So the first thing we're going to do is we're going to create a running total calculation. So this is my running total number of accidents. And I'm going to grab that onto the columns. And we get something like that. Let's change it to a bar. And I'm going to grab my number of accidents and put that on size. And on the size shelf if I set it to fixed and then right align everything

Form the Marimekko shape

we get close to our Marimekko but we need to tell Tableau how to sort this calculation. So within my specific dimensions I'm

Configure nested table calculations

going to check both options. I'm going to tell it to do it at the level of light conditions. And I want it to sort specifically on our count field. It doesn't matter which field you choose cuz we're just counting the each of the individual items anyway. Okay? And we need to swap around the rural and light conditions. We're telling Tableau what order to do the sorting in by the order of these fields that are checked. Okay, so that looks good. But we want to convert this to be a percentage of total so that each of these three axes goes from 0 to 100% so that we know the contribution of the light conditions within each rural or urban group. So to do that, we actually need to take our running total calculation and put it inside of another calculation.

Why two separate table calculations are required

And we need to do that because we need to be able to configure the two table calculations separately. So we have a running total of accidents and we're dividing it by the total number of accidents. So let's grab that and put that in place of the field that's on the columns. Okay, so this doesn't look quite right, but what we need to do is this field that's on the size shelf, we actually need to make that a percentage of total. And we need that to compute by the light conditions. And there you go. We've now taken that view, the standard bar chart, and we've made it a Marimekko.

The Marimekko is built

But we want to also have our total number of accidents within each urban or rural group on there as well.

Add reference line for group totals

So to do that, I'm just going to go to the analytics pane. I'm going to add on a reference line for each pane for the count. But I'm going to change the aggregation from an average to a total. And if I move this box out of the way, you can see how we have each of these individual lines. That's showing us the total number of accidents within each rural or urban group. I'm going to set my label to be the value. And in my formatting, I'm going to get rid of my line and fill below the bars. Hit okay, and with a bit of formatting, you can make this look really nice.

Final result + formatting tips 03:43 Wrap-up

And that's how you build an alternative to a standard Marimekko chart that will also show you the total for the individual group. Have a good day.

Другие видео автора — Andy Kriebel

Ctrl+V

Экстракт Знаний в Telegram

Экстракты и дистилляты из лучших YouTube-каналов — сразу после публикации.

Подписаться

Лучшие методички за неделю — каждый понедельник