Tableau how to show prior period when filter is applied
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 …
Excel Product function in 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 …
How to display custom labels in a Tableau line chart
The standard Tableau label options for line charts in give a lot of flexibility. But what if you want to do something non-standard, something that’s …
Keep dashboards simple
Within the Tableau community I see many dashboards shared that look great. Often they are highly complex, sometimes like works of art. In reality, in …
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 …