Archive

Posts Tagged ‘dashboard’

Add an All to a parameter in Tableau

November 12th, 2012 6 comments

EDIT 3/10/16: A different and simpler way to add All to a parameter in Tableau is written in a new article.

 

I have to thank Ben Sullins for this and his post on how to add an All to a parameter in Tableau, finding that article saved me a lot of time.

To begin create the parameter and add an ‘All’ option. Display the parameter on your worksheet.

Next drag the field you want to filter to the filters shelf.

To filter the field using the parameter right click on the field on the filters shelf and select Filter, then Condition.

In the By Formula box enter the following formula:

IFNULL([FilterField],’Null’) = IF [Paramter] != ‘All’ THEN [Paramter] ELSE IFNULL([FilterField],’Null’) END

How does this formula work? Read more…

Categories: Tableau Tags: , , ,

Tableau Dashboard size for ipad

July 21st, 2012 No comments

Recently I’ve been experimenting in Tableau with dashboard sizes for the ipad. I prefer to set it up landscape viewing and found the optimal size is 1020 x 610 pixels, this more or less seems the perfect size to fill the full screen and remove the need for scrolling.

Waterfall Charts in Tableau

March 8th, 2012 No comments

I’ve noticed waterfall charts are becoming quite fashionable now. If you’re not sure why this is used, it’s a great way, for example,  of showing how total revenue is compiled from it’s components. Using the Tableau Gantt Chart it’s quite simple to build. In this article I’ll give a very quick guide to building your own such as the chart below.


Read more…

Default Naming of Views on Tableau Server

September 15th, 2011 No comments

I have noticed that when publishing to Tableau server, dependent on what you publish, the view name can change. If you publish a worksheet on to the server the view name becomes the same as the sheet title and not the sheet name. If you publish a dashboard the view name remains the same as the dashboard name regardless of title.

The moral of the story is to only publish dashboards on the server – so put your worksheets on to a dashboard(s) before publishing to ensure a self explanatory user-friendly view name which should be easier for users to find.