# 10 Obscure Tableau Tips

*Ten Tips Plus My Favorite Tip of All Time*. If you haven’t read it, then you should definitely check it out. Additionally, others have written great blogs and given presentations sharing a variety of tips, including Jeffrey Shaffer, Andy Kriebel, Ann Jackson, Lorna Brown, and many others. If you haven’t watched the Jeff vs Andy or Ann vs Lorna tip battles from Tableau Conference, then be sure to watch them—I promise you’ll be glad you did.

**1. Hiding Marks**

__High/Low__

// Is this month's total sales the
overall min, max, or neither?

**IF ****SUM****(****[Sales]****) = ****MIN****(****{FIXED**** : ****MIN****(****{FIXED**** ****DATETRUNC****(****'month'****, ****[Order Date]****): ****SUM****(****[Sales]****)****}****)****}****) THEN**

** ****"Min"**

**ELSEIF ****SUM****([****Sales****]) = ****MAX****(****{FIXED**** : ****MAX****(****{FIXED**** ****DATETRUNC****(****'month'****, ****[Order Date]****): ****SUM****(****[Sales]****)****}****)****}****) THEN**

** ****"Max"**

**ELSE**

** ****"Neither"**

**END**

*Note: This is use case # 5 on my blog, 20 Uses for Level-of-Detail Calculations, so feel free to check out the blog if you'd like more details on how exactly this works.*

__High/Low
Sales__

// Sales for only the high and low
points.

**IF ****[High/Low] ****<>
****"Neither" ****THEN**

** ****SUM****(****[Sales]****)**

**END**

**Sales**measure (same as the first axis). Then we drag

**High/Low**to the color card. After changing to a dual axis and synchronizing the axes, we get this:

*Note # 1: If you don't want to color using this field, you can drag it to the color card, hide the item, then drag the pill to the detail card. The item will remain hidden, but the field will no longer control the color.*

*Note # 2: To bring back these hidden marks, click the*

**Analysis**menu, then choose**Reveal Hidden Data**.**2. Resize a Dashboard without Resizing the Objects**

**3. Format a Field in a Tooltip or Label**

**4. Mute Your Background Image**

**5. Make a Date when MAKEDATE Is Not Supported**

**DATE**

**(**

**STR**

**(**

**[Month]**

**) + '/' +**

**STR**

**(**

**[Day]**

**) + '/' +**

**STR**

**(**

**[Year]**

**))**

**DATETIME**

**(**

**STR**

**(**

**[Month]**

**) + '/' +**

**STR**

**(**

**[Day]**

**) + '/' +**

**STR**

**(**

**[Year]**

**) + ' ' +**

**STR**

**(**

**[Hour]**

**) + ':' +**

**STR**

**(**

**[Minute]**

**))**

**6. Copy and Paste Calculated Fields**

__Quantity x 2__**[Quantity]**

***2**

__Quantity x 2 x 2__**[Quantity x 2]**

***2**

__Quantity x 2 (Copy)__**[Quantity]**

***2**

__Quantity x 2 x 2 (Copy)__**[Quantity x 2]**

***2**

__Quantity x 2 (1)__**[Quantity]**

***2**

__Quantity x 2 x 2 (1)__**[Quantity x 2 (1)]**

***2**

*referenced*in the second calculation and automatically updates it to reference the

*new*field. While this seems like a minor tip, it can be quite powerful. Often, particularly when performing very complicated calculations, you’ll end up with a set of calculated fields that all relate to each other. If you need a new set of these and you duplicate them, you then have to go back and update each calculation to reference the new copy of previous calcs, which can be a painful process. I’ve run into this quite a bit when building sankeys and the copy/paste technique proves to be a big help.

**7. Use Table Calcs to Trick the Order of Operation**

*before*the rank. Tableau is, therefore, removing the data from the view,

*then*ranking the cities that are left. What we want is to rank the cities first, then filter. And the only way to do that is to force our filter to be a table calc filter (orange highlight). To do this, we can create a calculated field like this:

__State TC__**LOOKUP**

**(**

**MAX**

**(**

**[State]**

**), 0)**

*after*the RANK table calc.

**State**with

**State TC**.

**8. Bring Your Own Bins**

**9. Excel Tables & Named Ranges Act Like Separate Tables**

**10. Use Custom SQL with Excel**

**OK**then follow the wizard to import/link your table.

*can*exceed the complexity limits of Access.

## No comments: