Home
Tableau Training
OneNumber Tableau Training Passport
Office Hours
Custom Projects
Blog
About Us
Testimonials
Newsletter
Contact Us
Store
Sign In My Account

Office Hours

Tableau Education and Consulting Experts

OneNumber
0

Aug 24
Aug 24 Using Tableau to Only Display Data from the Latest Date

Eric Parker
Tableau How-Tos

If you have a data set that updates irregularly, figuring out how to filter to show only the latest data is difficult. Relative Date Filters are great but only work well if you have a set time you are filtering to like “today” or “yesterday”. If your latest data could be today, yesterday, or two days ago depending on the refresh schedule, things get trickier.

Aug 17
Aug 17 What does Tableau Prep do (that Tableau Desktop can't)?

Eric Parker
Data, Tableau Prep

If you’ve been using Tableau Desktop for a while you probably know that you can join, union and pivot data in the product. When you hear that Tableau Prep helps you “prepare your data” you might wonder what it can do that Desktop can’t.

Aug 10
Aug 10 Can you put two different fields on color in Tableau?

Eric Parker
Tableau How-Tos

Yes, you can! Check out the image below for an example.

Aug 3
Aug 3 How do you union two tables from different databases in Tableau Desktop?

Eric Parker
Tableau Prep, Data

You don’t.

Tableau Desktop will allow you to union multiple tables from the same database or even multiple .csv files, but you can’t union a table from SQL Server A with a tableau from SQL Server B.

Jul 27
Jul 27 Using Symbols to Get More out of Your Tableau Highlight Tables

Eric Parker
Tableau General Knowledge

Complex data questions are hard to answer with simple visuals. When questions have multiple components, a single graph may not be enough. For instance, imagine you have a table of data displaying average daily high temperatures by month that looks like this:

Jul 20
Jul 20 Use a Tableau Parameter to Compare a Part to the Whole

Eric Parker
Tableau How-Tos

If you've ever tried to compare part of your data to the whole in Tableau (and give your users flexibility to change the view), you might think it's not possible. However, with a combination of parameters and calculations, you can give users the ability to compare a partial selection to the whole, original value.

Jun 29
Jun 29 Compare to the Same Day Last Year in Tableau

Eric Parker
Tableau General Knowledge

Let’s say you want to compare a value from today to the same day last year to evaluate performance…

Jun 22
Jun 22 Answered: How do you edit a calculated field in Tableau Prep?

Eric Parker
Tableau Prep

Creating calculated fields in Tableau Prep is pretty straightforward. Editing them isn’t. The first time I wanted to edit a calculated field in the product I had a moment of hesitation.

Jun 15
Jun 15 Here are Three Things You Can't do with Tableau Prep

Eric Parker
Data, Tableau Prep

Tableau Prep is a powerful tool but it can’t help solve every data preparation scenario. We focus a lot of our time and effort on what it can do, but we thought it would be worthwhile to cover what it can’t do (yet).

Jun 8
Jun 8 Did my join in Tableau Desktop work?

Eric Parker
Data

Joins can be a sticky business, especially if…

●        You haven’t used them much before.

●        You are working with data that is new to you.

●        You don’t trust your data cleanliness.

Jun 1
Jun 1 How to Create Dynamic Titles for Tableau Dashboards

Eric Parker
Tableau How-Tos

Remember the Attribute function? It returns a value if there is only a single value for a result set, otherwise it returns an asterisk.

May 25
May 25 Create a Percent of Total in Tableau That Isn't Affected by Filters

Eric Parker
Tableau How-Tos

As you likely know from using Table Calculations in Tableau, they only compute against the marks displayed in a worksheet. Check out this webinar in you need a refresher.

That means when a filter is applied to the worksheet, a table calculation will update to reflect only the data present in the worksheet.

May 18
May 18 How to Clean Dirty Data with Tableau Prep

Eric Parker
Tableau Prep, Data

May 11
May 11 How to Unpivot (Transpose) Data in Tableau Prep

Eric Parker
Tableau Prep

Tableau Prep is a great tool for dealing with messy or unorganized data. After understanding the basics, one of the first things I found myself wondering was “does Tableau Prep have the ability to unpivot data?”. It has a pivot feature but does not have an unpivot or transpose feature at this point. However, there is a workaround.

May 4
May 4 Unveiling Tableau Prep

Eric Parker
Data, Tableau Prep

May 2
May 2 OneNumber Events in Q2

Eric Parker
Events

Spend your time focusing on high-priority tasks, not getting frustrated trying to get Tableau to work. Sign up for a workshop below to learn the skills you need to accomplish your tasks more quickly!

Load More

Youtube

Visit our Youtube channel for Tableau tips, tricks, and tutorials!

Sign up to the OneNumber Newsletter

Sign up with your email address to receive Tableau tips and news about upcoming classes

We respect your privacy. Your email will not be shared with anyone.

Thank you for signing up to the OneNumber Newsletter! We’ll send you some Tableau tips your way soon!

0