Creating a filterable year-over-year Waterfall Chart with multiple measures using internal data densification

For today I have something hopefully interesting for many. A Waterfall chart is a quite common type of chart whenever we look at financial data but obviously can be used in many regards. In any case, it always does the same: it explains how we come from a starting reference to an end value by … Continue reading Creating a filterable year-over-year Waterfall Chart with multiple measures using internal data densification

Two quick ideas on reference lines

Here are two quick questions that were raised recently, both regarding the use of reference lines. Question: How to create a custom reference line? In this case, the user wanted to show a median as a reference line but only for values that exceeded a certain threshold. So, in effect he had a bar chart … Continue reading Two quick ideas on reference lines

Combine dynamic zone visibility and user permissions to de-clutter your user interface

Here is a quick note on dynamic zone visibility and how you might use it to improve user experience apart from the obvious. So, DZV is new since 2022.3 and you can use it to show and hide for example sheets dynamically based on a condition. Some caveats apply though: Source: https://help.tableau.com/current/online/en-us/dynamic_zone_visibility.htm Showing or hiding … Continue reading Combine dynamic zone visibility and user permissions to de-clutter your user interface

How to select the last day of a dynamic period in Tableau || Let’s have (a word about) date(s) (6/6)

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)

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)