Tableau Developers – where should they sit within an organisation?

2019-08-24T14:23:34+00:00August 24th, 2019|Business Intelligence, Experience, Reporting Theory, Tableau|

Often large organisations struggle with where Tableau developers should sit. This could also apply to any other reporting software, the likes of Power BI, Qlik, etc. As some technology is involved (i.e. Tableau) there is often a strong argument to lump it in with IT. However I believe this is incorrect. The optimal place for [...]

Tableau error measuring utf8 to utf16

2019-08-24T13:47:42+00:00January 3rd, 2019|Tableau|

The Tableau error "Tableau Data Engine Error: 40583: error measuring utf8 to utf16" can be caused by creating a TDE in Alteryx. I have seen this error when using the Alteryx Output tool to output a Tableau Data Extract file (TDE) based on CSV files (and possibly other file types). There are a couple of [...]

Tableau how to show prior period when filter is applied

2018-08-24T16:14:41+00:00August 24th, 2018|Tableau|

This type of question, 'How do I show prior month when using a month filter?', 'My Year on Year is blank when I filter?',  appears A LOT on the Tableau forums. There are two main ways to show the prior period / keep a previous value for prior period comparison. 1. Parameter Create a parameter [...]

Excel Product function in Tableau

2018-08-14T19:28:24+00:00August 14th, 2018|Excel, Tableau|

I stumbled across a question on the Tableau forums asking how to write the Excel Product function in Tableau. Full credit for the answer goes to Brian Bell in the comments of this thread https://community.tableau.com/ideas/1857. The Product formula in Tableau is: EXP (SUM( LN ([FieldName]) ) ) Should [FieldName] be a series of financial returns [...]

Create fixed bins from a measure in Tableau

2018-08-20T12:05:16+00:00June 18th, 2017|Tableau|

What feels like a long time ago, pre-Tableau 9, I wrote an article on how to create fixed bins from a measure in Tableau. At the time it was complicated, data duplication and blending was required. Then Tableau 9 came along and this suddenly creating bins from a measure became very easy. The game changer was the FIXED [...]

Tableau dashboard navigation without the double click

2018-08-20T12:19:31+00:00May 14th, 2017|Tableau, Tableau Server|

There are use cases where using buttons can aid Tableau dashboard navigation. For example in your Tableau report you may have a summary dashboard and a detailed drill down. Perhaps you want the user to drill down from the summary to the detail dashboard on a click. Tableau Actions make this drill down very simple. It's [...]

Show the total for selected and unselected values

2018-08-20T12:16:27+00:00April 10th, 2017|Tableau|

Recently I came across a chart that showed the total for both the selected and unselected values. It’s actually very simple to create but did take a bit of thought to begin. We want the values NOT selected to remain within the view. A standard filter removes the values completely. Therefore the unselected values must [...]