For today I have just a super tiny tip. Sometimes, your dataset only consists of data like [city name], the [latitude] and the [longitude]. No further information available. If you put that on a map, Tableau will automatically draw the dots and the map in the background like this: That is ok but not really... Continue Reading →
How to put a ratio above a side by side bar chart built from two different measures
Today we are going to deal with a request that recently popped up during our work. The question was how to put a ratio above two bars from two different measures that are grouped by year. Like this: Either, there is nothing on this topic or we are very bad at googling, but in any... Continue Reading →
A(nother) quickie on bar chart labeling
A quick one for today. How do we get from this to this? There are several techniques and I have described one >> here << already but the one for today is this: add a secondary axis to your columns (sum(0)) Dual axis, synchronize create two calculated fields, one named "label +" the other "label... 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 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 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 →
Tableau Adventurer 