12/21/2020
Tableau Ideas – Quantity 19: Hidden Gem Ideas
Right here is the nineteenth installment of my Tableau Ideas collection. The title got here from a touch upon my Tableau Ideas tweet, referring it as a hidden gem. This quantity will function these ideas which can be exhausting to note, but very useful- similar to valuable gems.
#10 – Drag Capsules to Inline Formulation for Fast Calculations.
Double-click on the Marks Card or Rows/Columns and drag capsules into the inline system for fast calculations.
#9 – Fast Tablet Swap.
I realized this one from @DataRevelations. Holding down the CTRL key, choose two capsules and right-click and choose swap to shortly swap (any tablet combo of blue, inexperienced, dimensions or measures).
#8 – Change Date Properties Week Begin in Information Supply
By default the beginning of the week is Sunday, however you possibly can change this within the knowledge supply for all dates. Choose Information from prime menu and the information supply. Choose « Date Properties » & change Week Begin.
#7 – Clear Formatting in Textual content Field.
Shortly clear the formatting of a textual content field with out resetting it by clicking the X to the fitting of Insert. This may hold your customized textual content, however merely reset the formatting again to the default.
#6 – Utilizing Massive Textual content in Tableau.
The restrict of a Tableau textual content field is measurement 72. Nevertheless, you possibly can copy and paste from Phrase at a a lot bigger font measurement if wanted. This may be helpful for dashboard titles, labels or BANs.
#5 – Add a Hyperlink to Textual content in a Textual content Field.
Have an internet site in a textual content field? Add http:// or https:// to an internet site tackle to robotically flip that textual content right into a working hyperlink.
#4 – Rename Inline Calculations.
This can be a variation on a trick all of us realized from
@datavizlinds at #IronViz. Including a remark to an inline calculation will change the title of the inline calculation.
#3 – Reset Titles and Captions.
After altering a title or caption, you possibly can shortly reset it by Proper-Clicking on it and choosing Reset.
#2 – Shortly Swap Worksheets on a Dashboard.
This one comes from Brian Scally who posted this tip earlier. On the Dashboard pane, click on a sheet after which hover over a brand new sheet & click on the small swap sheet button to swap.
#1 – Fast Paste to Customized Worth.
Again in July I posted a tip for pasting values right into a Customized worth listing. You’ll be able to view the complete tweet here. Very useful for a person. You can too do that in a filter choices field, clicking « Customized worth listing » & pasting values. Proper-click to edit every line and Fill Above (or beneath if wanted) w/ background coloration (ex. white). Then right-click on the chart space and format the worksheet pane. This may coloration the remaining sq..
I hope you discover this data helpful. In case you have any questions be happy to e-mail me at Jeff@DataPlusScience.com
Jeffrey A. Shaffer
Observe on Twitter @HighVizAbility