7/7/2016
Tableau Tips - Volume 3 "The Need for Speed"
I previously posted Tableau Tips Volume 1 and Tableau Tips Volume 2. These continue to be popular posts, so I thought I would continue the series, this time focusing on tips specifically for speed. Click on images below for full screen
#10 - Drag pills to the chart area for quick color.
We all know that you can drag a pill to the color shelf to assign color. You can also drag a pill to the chart area, for example, right on top of a bar, and it will also assign color.
Note: One issue with using this method is you can't do double color, meaning you can't place two blue pills on the chart area for color. If you do this, one will end up on color and the other on detail. However, if you multi-select two blue pills and drag to the color marks you can have two blue pills on color. Be careful how you use this one as color can quickly become confusing with too many categories.
#9 - Use the CTRL key to multi-select pills to drag on and off the canvas.
In previous tips I discussed the use of multi-select using the CTRL key to multi-select colors and other items in Tableau. This same tip can be leveraged with Pills as well. In this case, I can multi-select all of the blue pills except one and drag them off of the canvas.
#8 - Use CTRL-F for a quick search of a field name.
When the data sets get large and there are loads of field names you may find yourself scrolling through name after name looking for the field you want. At any point or location in the viz, simply click CTRL-F and the search dialog box will appear above the Dimensions. You can also click the small search icon. Entering in the first letter or two of a field name will quickly narrow them down for you.
#7 - Type field names on the in-line formula.
Even quicker than searching for a field, just double click on the blank space in the row or column or the white space in the Marks Card. A text box outline will appear and you can start typing in formulas or field names. As you type the first letter or two, the field names will filter and appear. Simply double click the one that you want and the pill will magically appear.
#6 - Right-click and drag a field to rows, columns or the Marks.
Certain fields such as Sales, Profit or Quantity may have a default aggregation as SUM. You can change this default aggregation, but often times you will want to keep the default aggregation as one thing and use the pill in the viz as a different aggregation. Instead of dragging each pill and changing the aggregation, right-click and drag the pill. This will give you a dialog box where you can pick the aggregation before placing the pill. For example, Sales has a default aggregation as SUM(Sales), but using right-click drag you can drop it on the Columns as AVG(Sales) without having to change the properties of the pill.
#5 - CTRL-Drag to quickly duplicate fields.
Sometimes you want to duplicate a field, using the same pill twice. For example, creating a dual axis chart where you need to duplicate one of the Measures. This is a super quick technique. Just hold the CTRL key down and drag the pill to be right next to itself.
#4 - Hide fields not being used/show hidden fields.
As we already discussed, sometimes the list of field names in the data can be very long. Once you have the fields that you need in the viz, you can make your life easier by hiding fields that are not being used. This will help narrow the list dramatically by only showing fields that are used. Once you do this, you also need to be able to see them again, so the other half of this tip is showing the hidden fields.
#3 - Unhide hidden fields.
Hiding the fields is easy, just a click of a button, but there is no "click to unhide" for all of them. You can leverage the multi-select discussed above, by clicking the first field in the list and holding the SHIFT key down and then selecting the last field in the list. Then you can unhide all of the fields at once. You will need to do this once for Dimensions and once for Measures.
Alternatively, you can also click on the data source and do it in one multi-select. Click the first column in the data and hold the SHIFT key and then click the last column. Then right-click and select unhide.
NOTE: When unhiding all of the fields, in either method, the hierarchy is not preserved. You will need to recreate the hierarchy, for example Location.
#2 - Creating fast hierarchy.
Drag one pill on top of another pill and you have an instant hierarchy. Then you can drag other pills into the hierarchy and order them in whatever way you want. For example, dragging the Region pill on top of the Country pill automatically creates a new hierarchy. Then I can add State, City and Postal Code.
#1 - Drag the x-axis or y-axis to the chart area for color.
Probably the quickest speed tip of all. After you have your chart built, simply drag a field that is on your y-axis or x-axis into the chart area and that pill will be used on color.
I hope you find these tips helpful. If you have any questions feel free to email me at Jeff@DataPlusScience.com
