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 How to evalute the drill down level in a hierarchy
Category: Level of Detail | LOD
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 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 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)
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 Changing date granularity based on filter (!) selection
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 filter selection and custom “all selection” on text marks
Tableau Adventurer 