Tiny Tableau Tips - Round 4


Thanksgiving is next week. One thing that I am incredibly thankful for is our wonderfully amazing Tableau Community. Without them, there is simply no way that I'd be where I am today. So as a thank you, this blog post will feature tips from the community. This will be our 4th round of Tiny Tableau Tips.

As a reminder, these are tips shared by others on social media and I'm just providing a more permanent home.  For more information on how tinytableautips came to be, check out Round 1.  In Round 4, we will be featuring tips from Vince Baumel, Dorian BanutoiuLindsay Betzendahl, and Tim Ngwena.

1) Warning That No Data Exists

Vince Baumel on Feb 4, 2020Time for a #tinytableautip! Here's one way to visually indicate when your user has exhausted all data by too much filtering. Float your viz, set the fit to Entire View, and float a notification box behind it. Simple as that!

2) Identifying Leap Years

Vince Baumel on Feb 5, 2020: Today I had someone ask me about identifying leap years in Tableau. Here's the simplest way I've found to do it! Don't #FearTheModulo - it's super useful sometimes!

3) Select All in Filters Without All Option

Vince Baumel on Feb 19, 2020: #TinyTableauTip time! If your #Tableau filter doesn't have an "All" option, hit this little button to select everything in the list. Not the most groundbreaking tip, I know, but it might be useful to someone!

4) What Dashboard is Your Sheet Used In?

Vince Baumel on Mar 4, 2020: It's #TinyTableauTip time! Here's the scenario: You've got a big workbook with several dashboards and a ton of worksheets. Perhaps you can't remember which dashboard(s) a particular worksheet was used for... but not anymore! Right-click the worksheet name and check this out!

5) Tip for Animation

This one is from me on Mar 20, 2020In a crosstab, you can get rid of the "Abc" placeholder by changing to a polygon mark type. However, if you try to animate it your viz, it won't work because polygons cannot be animated. (Note: if you have a polygon anywhere, your entire dashboard won't animate).

6) Highlight Non-Zero Values in Table

Vince Baumel on Mar 30, 2020: Here's the scenario: you need to show a crosstab, but several of your values are zero. How do you simply highlight where the values are NOT zero? Simple! Squares, Measure Values on color, custom diverging palette, 2 steps, start at 0 and Center at 1. Done!

7) Easy Tooltip Alignment

Dorian Banutoiu via Vince Baumel on Apr 24, 2020: Just noticed this tiny slider that allows us to align Tableau tooltips.

8) Specify Which Dimensions Get Subtotals

Vince Baumel on Jun 9, 2020: Say you've got a crosstab, and you want subtotals but ONLY at a certain aggregation. Did you know that you can right-click individual pills to add or remove their subtotals? Check it out!

9) Suffix or Prefix 

Interestingly, I just wrote about this a few weeks ago...and now I see that Lindsay wrote about it over 3 years ago.

Lindsay Betzendahl on Jul 14, 2020: If your data comes over as full numbers but really should be percents (meaning decimals from 0-1) instead of creating a calc, you can just use the custom number formatting and add the "%" in the suffix field. I do this ALL the time.

10) Suffix or Prefix 

Tim Ngwena via Vince Baumel on Feb 9, 2021#tinytableautip that I learned from Tim Ngwena! I had no idea this existed! Check it out - if you highlight a portion of your #Tableau calculation and double-click a function from the dropdown, it wraps the highlighted portion in that function! What a time saver!

Man, what a bunch of great tips from a great bunch of people! Isn't our community amazing???

That's it until next time. Thanks to all of the people sharing tips and thanks for reading!


Need help with anything related to Tableau?  Through Moxy Analytics, Ken and I provide consulting services such as Tableau Lifeline (get us for 1 hour to help solve a sticky problem), Fractional Data Here (get us on your team for N number of hours a month for whatever you want us for), Tableau Training, and of course, project work. Click the Icon below if you are interested.

Kevin Flerlage, November 13, 2023

Twitter LinkedIn Tableau Public

1 comment:

Powered by Blogger.