Simple Conditional Formatting in Tableau

2020-03-18T17:00:51+00:00January 13th, 2020|Tableau, Tableau Basic|

Creating conditionally formatted tables is a regular request for Tableau consultants. This is very similar to what users are used to in Excel. For example they may want some columns to be highlighted and others to be left without highlighting. Conditional formatting in Tableau is an appropriate description. For simple highlighting requests - for example [...]

Fix the number of pages to export pdf from Tableau

2020-02-27T15:53:40+00:00September 22nd, 2019|Tableau, Tableau Basic|

Sometimes download / export to pdf is a requirement of your Tableau dashboard. Whether it's using the Tableau Server download button or downloading the pdf from Tableau Server using the URL the appearance is important. Components should fit cleanly on their page. For example splitting a chart across two pages isn't particularly readable. Therefore the [...]

Tableau format zero values

2020-03-19T14:34:31+00:00March 5th, 2018|Tableau, Tableau Basic|

To format zeroes (0) in Tableau to something else, such as a dash (-) for example, is simple using standard formatting techniques. For example use this technique to not show zero values, simply by formatting zero as a zero length string (“”). In the standard Tableau number formatting there’s a Custom option. It is here [...]

Making Dashboards Relevant

2020-03-05T10:43:34+00:00March 11th, 2014|Tableau, Tableau Basic|

Recently I've seen a lot of sexy dashboards created in Tableau, doing some very cool things. It got me thinking, these look great but actually they're useless. The report users would look at them once, think "wow", and then never use them again as they're not providing any useful information. If you're building reports remember [...]

Tableau Dimensions as Columns in a Table

2020-03-19T10:59:34+00:00December 18th, 2012|Tableau, Tableau Basic|

In Tableau the default number of table discrete (blue pills) columns in a table is six. Any more than this and the left hand columns start to merge into one column. Thanks to a below comment from Joe Mako I learnt the default six can increase to 16. To increase use the Tableau menu. Analysis---Table [...]