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 →
Quickie on combining index and sub totals
In case you encounter the problem that you want to number your table by using index and still add a subtotal and thereby run into this here is the workaround: Copy your dimension which you intent to number using the index. In the above example, it is customer name. Put the original customer name to... Continue Reading →
Tableau Adventurer 