For today, we will do a rather short quickie. Imagine you are tasked with providing a dynamic view that can alter between say weekly, monthly, yearly and you want to show always time-period end values. Create a string parameter and insert there whatever you need, for example the values outlined before. Then, create this calculation: … Continue reading How to select the last day of a dynamic period in Tableau || Let’s have (a word about) date(s) (6/6)
Author: Steffen
Weeks and why you need to be careful || Let’s have a (word about) date(s) (5/6)
Many companies just love weeks and request reports being done on a weekly or by-week basis. That is all fine, fun and games but there are a couple of things you need to be aware of, especially if you are either just starting with Tableau, or week-based reporting or if your company is located in … Continue reading Weeks and why you need to be careful || Let’s have a (word about) date(s) (5/6)
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)
Tableau Adventurer 