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

In the previous post we had a look at how to do a series of year-over-year comparisons using a self-union. But what if you can't use a self-union, for example because your data source does not allow you to do that? Also, we wanted to have a bit more insights into how to do some … Continue reading How to do a Series of Year-over-Year comparisons in Tableau || Let’s have a (word about) date(s) (4/6)

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)

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

Summing grand totals from different sheets

For today I have a 'how-to' regarding summing up the gross totals from two different calculations on two sheets with different filters (possibly) applied. Assume your first sheet looks like this. I have randomly filtered to ship date years 2021 to 2023. and the second one like this, filtered based on order date (=2021). Also, … Continue reading Summing grand totals from different sheets