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: User Experience
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 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)
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 How to remove null values from date fields || Let’s have a (word about) date(s) (1/6)
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 Mini-Series: Map interactivity – Pt. 1
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 Making the “hide” function in Tableau dynamic
Tableau Adventurer 