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 →
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 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 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 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 →
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 →
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 →
My first year blogging
Given that my blog just turned 1yr old I created a small dashboard and actually intended to embed it via an iFrame but apparently this is not possible for people that only pay "premium" (lol, what a joke). At least everything looks great in preview mode and when I publish, it just all goes blank...... Continue Reading →
Dynamically adjusting Histogram
Histograms are the go-to solution when you want to show distribution frequency. Thus, no wonder Tableau offers an out-of-the-box solution for this where you can either have Tableau auto-detect / suggest bin sizes or you can manually set them or your are even free to use a parameter to adjust your bins on the fly.... Continue Reading →
Changing date granularity based on filter (!) selection
For today I have an interesting one. Let's assume we are faced with a request where the circumstances allow you to show a maximum of twelve bars in your chart. Reason isn't relevant, let's just stick with that as a prerequisite. At the same time, you are tasked to provide the most conclusive yet granular... Continue Reading →
Tableau Adventurer 