Tableau format zero values
Common questions such as “How to format zero as dash in Tableau” and “Tableau format zero values” are surprisingly simple to answer. There is no …
Tableau dashboard navigation without the double click
Dec 2020 update: This article about navigating between Tableau dashboards was first written back in 2017. Since then, Tableau introduced a navigation button, hugely simplifying …
Show the total for selected and unselected values
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.
MS Access query isn’t in the Tableau table list
Using MS Access in conjunction with Tableau isn’t always a painless experience, especially when it comes to the Access query. Although both Access and Tableau …
Tableau Cannot use boolean type in IF expression
The “Cannot use boolean type in IF expression” error in Tableau calculated fields is quite self-explanatory. In Tableau IF statements you’re not able to return …
Using Alteryx for Data Quality checks
Data Quality is now a rapidly growing area in many Financial Services organisations. There are multiple vendors, such as Informatica and Ab Initio, with software …
Add All to a Parameter in Tableau
This article shows two different ways to add All to a parameter in Tableau. It is surprisingly simple to add All to a parameter and …
Move or Copy files in Alteryx
This post describes how to move a file in Alteryx. To move or copy files in Alteryx use the Run Command tool. As the name …
Tableau tabcmd error code 16
Do you get the tabcmd error code 16, Invalid username or password? Unsure what is causing this, as you’re entering the correct username and password …
Unzip a file in Alteryx
A regular question on the Alteryx forums is how to unzip a file in Alteryx. This is another situation well suited to the Run Command …