The OneNumber Blog — OneNumber

Tableau Parameters, Tableau General Knowledge

Users love filtering and sorting options in Tableau dashboards, right?

Odds are, you know you can use a parameter to change the top number of values displaying in a worksheet. However, did you know you can also use a parameter to change whether it's the Top 10 or Bottom 10 values displaying? Did you know that same parameter can control whether the sort order is ascending or descending? It's true!

Mar 15
Mar 15 Advanced Tableau Donut Charts | Dynamic Colors, Swap Fields

A few weeks ago, we took a look at how to build donut charts in Tableau. Building a donut chart is similar to building many other views in Tableau. It’s simple to set up, but how do you get it looking really great?

This question comes up in my classes. Often, it’s the way we format our charts that has the biggest impact on our end users. So, while this week’s video pertains to donut charts, I hope that it holds some tips and tricks for adding layers of interest into our other views and charts too!

Mar 1
Mar 1 How to Swap a Field with a Tableau Parameter

Tableau General Knowledge, Tableau Calculations, Tableau Parameters

Parameters are a powerful tool in Tableau. They allow your end user to customize the view that they're seeing by selecting your pre-defined parameter values.

But where do we begin when using parameters? Well, the "Swap-A-Field" Parameter is the perfect place!

Feb 15
Feb 15 Multiple Color Legends for a Single Measure in Tableau

Tableau General Knowledge, Tableau Calculations, Tableau How-Tos

When you put a single measure on the color tab in your Tableau worksheet, you get a single color legend. That makes sense.

But sometimes it can be frustrating. For instance, what if two different segments of your business have significantly different Sales values?

Feb 1
Feb 1 How to Build Donut Charts in Tableau

Donut Charts are a very visually-appealing chart type, used to show part-to-whole relationships. They’re simple and effective, and are a great tool to add to your dashboarding arsenal. While they’re not a built-in chart type in Tableau (unlike a bar chart, pie chart, or line graph), we can build them with a few extra steps!

Jan 18
Jan 18 How to Tableau: Pivots in Tableau Desktop

Getting the structure of our data correct for Tableau Desktop can make a huge difference. Tableau is pretty picky about the way it wants our data to be formatted. Generally, each column should be a new dimension or measure.

Dec 28
Dec 28 How to Build a Circle Timeline Chart in Tableau

Tableau General Knowledge, Tableau Dates

When it comes to displaying data over time, it's easy to fall into the trap that you should always use some form of line graph. While line graphs are a great default when displaying chronological data, they aren't always your best option!

Dec 14
Dec 14 How to Tableau: Cross-Database Joins

A huge benefit of using joins in Tableau is that we can combine data from multiple tables into a single table for analysis. When those tables are in different databases, it can be a little tricky to work out where to start. If you know how to join tables within the same database, that's great! Cross-database joins only take a few more steps to execute, and I'll walk you through them in today's video.

Dec 1
Dec 1 Tableau for Excel Users | Webinar Recording

If you are coming to Tableau from the world of Excel, make sure your skills translate!

Excel and Tableau have a long history of being complementary tools. While there are functions that can be performed in both tools, they both have their own strengths and weaknesses.

Oct 19
Oct 19 Number Formatting in Tableau

Have you ever spent waaaaay too long trying to format a number in Tableau? Did you ever change a number format but see no change in your worksheet? These little things can be maddening!

Oct 12
Oct 12 What are Measure Names & Measure Values in Tableau?

Measure Names and Measure Values - they seem to be everywhere! In your data pane, appearing magically when building certain graphs and views… But what exactly are they for?

Measure Names and Measure Values are Tableau generated fields that allow us to reference all the measures in our worksheet.

Sep 27
Sep 27 Tableau Sets: A Comprehensive Guide | Webinar Recording

Tableau Sets are custom fields which allow you to define subsets of data. They can be used in a variety of ways to make charts more intuitive, interactive, and functional!

Sep 22
Sep 22 How to Build a Dot Plot with Average Lines in Tableau

Tableau How-Tos, Tableau General Knowledge

One of my favorite, underutilized charts is a dot plot! A dot plot is like a 2-D Scatter Plot and it's great for visualizing ranges of data. Often, I'll pop an average line on the chart for reference so the user can compare across categories as well. I hope this chart type serves you well!

Sep 15
Sep 15 How to Display Counts in Tableau

“How do you display counts in Tableau?"

I accidentally stumbled upon this popular Google search question and it looks like a lot of people are inputting this query!

It turns out, there are multiple ways to display counts in Tableau. Which method is right for you all depends on what you're trying to display the count of.

Sep 1
Sep 1 How to Add Total Labels to Stacked Bar Charts in Tableau