Stop doing this in Excel. Tableau has a cleaner, more powerful way to count only the weekdays between any two dates. And once you see how it works,you'll use it everywhere.

In this tutorial, you'll learn how to build a dynamic date range selector  using parameter actions, then strip out Saturdays and Sundays using DATEPART weekday logic wrapped in a Level of Detail expression, so you always get an accurate weekday count, no matter the range.

This is one of the most common questions I get asked, and the solution is simpler than you think.

📥 Download the workbook + data: https://nlt.kit.com/weekdays

Unlock Powerful Tableau Drill Downs With Set Actions 🔍

If you’re still clicking around dashboards trying to “fake” a drill down — stop! In this video, I’ll walk you step-by-step through how to use Set Actions in Tableau to build a fully interactive bar chart drill down.

👉 Start here to level up faster:

Tableau Starter Kit → https://www.nextleveltableau.com/starterkit

Core Concepts Course → https://www.nextleveltableau.com/tcc

Next-Level Tableau → https://www.nextleveltableau.com/

I’ve helped thousands of Tableau analysts move from frustration to clarity using features like this — and once you master Set Actions, your dashboards will finally work like your users expect them to.

📌 If you’re ready to stop confusing your users and start building cleaner, smarter dashboards… you’re in the right place.

See how it all works below the video.

Over on Tableau Public, Judit Bekker create this fantastic directory of charts to help you pick the one that's most appropriate for your analysis.

Check it out below.

Demystify ANY data set by answering 5 simple questions:

1. When?
2. Where?
3. Which?
4. Who?
5. Why?

----------

P.S. Newsletter subscribers get a deeper dive into each of these for FREE when they sign up. Go to andykriebel.com to get yours. 

Explore the full spectrum of data visualization with Tableau histograms and the Data Guide feature! 

This comprehensive video tutorial takes you on an exploratory journey from the basics of histograms to the advanced insights offered by Tableau's Data Guide.

In this instructional video, you will:

- Grasp the concept of histograms and their role in revealing data distributions.

- Tailor bin sizes and intervals in Tableau for customized data analysis.

- Utilize Tableau's Data Guide to enhance your understanding and interpretation of histograms.

- Apply your knowledge for practical learning.

Additionally, I'll walk you through the Data Guide in Tableau - a powerful feature that aids in decoding your data's story, ensuring you're not just seeing data but truly comprehending it.

By the end of this tutorial, you'll not only master the creation of histograms in Tableau but also leverage the full potential of the Data Guide to make informed decisions.

Download the workbook here.

This comprehensive video will help you create business dashboards that are more actionable and meaningful and that your users will find easy to use at first glance. You’ll be on your way to being a dashboarding expert!

You’ll learn:

1. Building basic charts
2. Formatting fundamentals
3. Using layout containers
4. Dashboard formatting
5. Essential tips for padding
6. Filter controls

We'll create an interactive sales dashboard for Adidas in Tableau that's going to dynamically update based on the filters on the side of the dashboard which will allow us to select specific years, regions, products, and more. 

⏬ DOWNLOAD my preferences file, the data, and starter and solution workbooks for £2 (this covers the costs of making this and future videos):
https://andykriebel.gumroad.com/l/adidassalesdashboard

Sign up for my newsletter to get advance, exclusive viewing of all of my videos, tips for using Tableau, plus exclusive discounts on products that I create.
https://andykriebel.com/

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.

A Merimekko Chart, also known as a variable width bar chart, is useful for comparing both high-level data and low-level data in the same chart. However, since we have size variables for both the width of the bars AND the height of the bars, comparing different segments of the chart is more challenging than it needs to be. Read more about the problems with Merimekko charts here.

In this example, I show you how to make an alternative to a traditional Merimekko Chart. I show you how to compare both category sales and regions sales within each category at the same time.

This can be easily replicated by simply swapping out the dimensions and updating one LOD calculation. Alternatively, you could use two parameters to allow the user to pick both the high-level and low-level dimensions and a third parameter for the measure to compare.

In this tip I show you how to create a jitter plot. A jitter plot is very similar to a dot strip plot other than it reduces the overlapping of the data points. The data is plotted like a dot plot and then we use either the RANDOM() or INDEX() functions to spread out the dots.

Data - https://data.world/vizwiz/mock-car-sales