12/22/2020
Tableau Ideas – Quantity 20: 12 Ideas earlier than the 12 Days of Christmas
This can be a particular version of Tableau Ideas Quantity to mark the tip of this very unusual 12 months. In the event you’ve been following alongside this 12 months then you definately already know that I’ve printed a complete of 194 each day Tableau ideas since March. I’m planning on sharing extra ideas in 2021, however for now, right here is the twentieth installment of Tableau Ideas that includes 12 ideas from 2020 that I feel you may discover helpful.
#12 – A New Answer to Take away the ABC from a Textual content Desk.
Some referred to as it a Tableau Cheat Code, others a Konamy code for Tableau and one individual wrote « this has received to be the hackiest hack of all Tableau time ». No matter you need to name it, it is one other approach of eradicating the ABC from a textual content desk. CTRL-RIGHT-ARROW 3X, drag the column border as skinny as potential, then CTRL-LEFT-ARROW 5X. Abracadabra, the column is now gone! Format->Cell Measurement->Textual content Cell to reset.
#11 – CASE Assertion Maker Calc.
Must populate an extended checklist right into a CASE assertion? Here is a Calculation you should use to do it for you.
//CASE [Sub-Category]
str(« WHEN ‘ » + min([Sub-Category]) + « ‘ THEN » + str(index()))
Drop calculated subject on the canvas, copy it from the info window and paste into new calculated subject.
#10 – Populating Parameter Listing from Vary.
Once you Edit Parameter and choose Listing, it is clean. But when you choose Vary first after which click on Listing then it’s going to populate the Listing for you.
#9 – CTRL-C to Copy Knowledge.
Use CTRL-C to repeat with any drugs or information on the canvas, then paste these values with CTRL-V.
#8 – Fixing Your Marks Card Frustration.
Have you ever created a dual-axis, synchronized and the Marks Card would not keep put in your choice? ARGH! Choose the capsule on the rows/columns to lock it in after which it’s going to keep.
#7 – Obtain all Customized Shapes from a Tableau Workbook.
Go to Matt York’s web site and add his bookmark to your Chrome browser. On any Tableau Public Viz, click on the bookmarked button and it’ll obtain a zipper file of each form.
#6 – Using Animated GIFs.
Create an HTML page and use the GIF as a background image. Host the page and then place a Web Page Object on your dashboard using that web page. You can download my Rainy Day viz to see the way it works.
#5 – Double-Click on to Add a Fast Filter.
Merely double-click a dimension so as to add it to the filters. Mix with multi-select utilizing SHIFT or CTRL key after which double-click for extra filters.
#4 – Including Fast Coloration.
Drag the X or Y axis or any capsule to the chart space to shortly add coloration.
#3 – Transfer the X-Axis labels to the highest of a chart.
There may be an possibility beneath the « Evaluation » menu, click on « Desk Structure » after which « Superior » and uncheck the field « Present innermost stage at backside of view when there’s a vertical axis ».
#2 – 4 Quadrant Coloration Utilizing Annotations.
Annotate Space and measurement the field as wanted. Proper-click to format, color-pick the colour legend coloration (or desired coloration) and set the opacity slider to fifteen%. Be aware regular Mark choice solely works when printed.
#1 – Create a Single Coloration Quadrant Scatter Plot.
Proper-click to edit every line and Fill Above (or under if wanted) w/ background coloration (ex. white). Then right-click on the chart space and format the worksheet pane. It will coloration the remaining sq..
I hope you discover this data helpful. If in case you have any questions be happy to electronic mail me at Jeff@DataPlusScience.com
Completely satisfied Holidays and keep secure everybody!
Jeffrey A. Shaffer
Observe on Twitter @HighVizAbility
