How to do Series Year-over-Year comparisons in Tableau || Let’s have a (word about) date(s) (3/6)

In the last episode we learned how to do a year-over-year comparison when only two years are in the game. However, there may be cases when you want to show multiple years and their year-over-year development in a table - mostly this is something that senior management wants (why the heck do they love tables … Continue reading How to do Series Year-over-Year comparisons in Tableau || Let’s have a (word about) date(s) (3/6)

How to do Year-over-Year comparisons in Tableau || Let’s have a (word about) date(s) (2/6)

For today, we will be looking at how to do year-over-year comparisons avoiding one of the most annoying effects when creating such a comparison out of the box. Using sample superstore, assume you want to compare two years and their difference. Your initial build will look like this: Next, you will be adding a quick … Continue reading How to do Year-over-Year comparisons in Tableau || Let’s have a (word about) date(s) (2/6)

How to remove null values from date fields || Let’s have a (word about) date(s) (1/6)

Assume you have a data source with dates and some other values but some rows in your date column are empty. These will show as null values in Tableau: So, how can we replace these null values with something else, an alias? With any ordinary dimension, you can simply right click and select "edit alias". … Continue reading How to remove null values from date fields || Let’s have a (word about) date(s) (1/6)

Mini-Series: Map interactivity – Pt. 1

Today we will be looking at some ideas on how to add interactivity to maps without overloading them. Both are based on recent questions in the forums and we will also be building on one of my previous posts as well as make use of the latest addition to Tableau - Dynamic Zone Visibility. Part … Continue reading Mini-Series: Map interactivity – Pt. 1

Making the “hide” function in Tableau dynamic

What you will learn By the end of this posting you will have gained an idea of how we can make the "hide" option in Tableau dynamic which is essential when you are not only using table calculations but also applying totals from the analytics pane. The challenge Assume you want to show a 12 … Continue reading Making the “hide” function in Tableau dynamic