For this month's posting we will have a look at how to enable your users to "filter" columns from a text table without actually filtering it. Why would that be needed? Well one idea could be that you have one of these massive tables (you know, the ones you do not want to built but... Continue Reading →
Automatically select the last day of a period in a natural date-hierarchy drill down
Somewhat akin to what I wrote about lately, today we will be focussing on a question that was raised in the forums today. The asking person wanted to use the natural date hierarchy drill down (i.e. using the little plus / minus icons on date fields) to drill from year to quarter, month etc. This:... Continue Reading →
How to evalute the drill down level in a hierarchy
For today we want to see if there is a way to evaluate the level at which our view is set. What do I mean by that? Assume this is our hierarchy: and the task is to know if we are drilled down to Category, Sub-Category or Manufacturer. For example, in this screenshot, we are... Continue Reading →
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 →
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 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 →
Tableau Adventurer 