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 →
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 →
How to show filter selection and custom “all selection” on text marks
By incident, today's blog post is somewhat related to my last post and once again comes straight out of the Tableau forums where the solution I am going to share has been very well received. Apparently, this is a topic that concerns many users. The question asked was how we could show each single item... Continue Reading →
How to show the selected time frame and a warning if it is broken
A quite common request is to display what the user has selected within a filter. In our today's case what we will do is to show within the header the selected date range plus a warning if the dates have a break in it. That is, if the user selects January, February and April, the... Continue Reading →
A bit about the order of operations – Part 2
Here is the second and concluding part of the mini series on diving into the order of operations based on workout-wednesday 2022 week 15 challenge by Erica Hughes. In Part 1 we rebuilt the solution that was in the challenge but this time our aim is to avoid using hard-encoding the maximum date or storing... Continue Reading →
Tableau Adventurer 