Tableau Display Measures in a Table

2018-05-07T18:42:09+00:00 September 19th, 2011|Tableau, Tableau Basic|

Displaying measures in a table in Tableau is something that should be straightforward but for some reason I always struggle with it hence I’m writing this blog post. In the Tableau screen at the bottom of the Dimensions section there’s a field called Measure Names and in the Measures section there’s a field called Measure [...]

Default Naming of Views on Tableau Server

2011-09-15T11:29:15+00:00 September 15th, 2011|Tableau, Tableau Server|

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 [...]

Tableau Hide Null Values

2018-05-07T19:11:41+00:00 September 14th, 2011|Tableau, Tableau Basic|

Depending on the circumstances there are 2 general ways to hide Null values in Tableau. 1. Format the pill and hide the null values Hide Nulls in Tableau Select Hide in the Special Values section of the pane. For further explanation I have written about this previously. 2. Drag the pill into the [...]

SSRS Add Line Feed to Textbox

2011-09-07T10:48:10+00:00 September 7th, 2011|SSRS|

To add a line feed to a textbox in SSRS is quite simple - in the textbox expression where you want to add the line feed type: '& VbCrLf &' For example The expression: ="To add a line feed in SSRS" & VbCrLf & VbCrLf & "Use the VbCrLf function" Returns: 'To add a line [...]

Tableau Connecting to Data

2011-09-05T19:08:43+00:00 September 5th, 2011|Tableau, Tableau Basic|

Tableau is very flexible when it comes to connecting to data. Using the full paid for product it’s possible to connect to any data source accessible by an ODBC connection, cubes (both SSAS and Orcale Essbase), text files, spreadsheets and a number of different databases. It’s possible to connect to the live data [...]