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 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 →
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 →
Summing grand totals from different sheets
For today I have a 'how-to' regarding summing up the gross totals from two different calculations on two sheets with different filters (possibly) applied. Assume your first sheet looks like this. I have randomly filtered to ship date years 2021 to 2023. and the second one like this, filtered based on order date (=2021). Also,... 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 →
Another quickie on aliasing
Have you ever encountered that you were creating BANs (Big (Buttocks) Numbers) and wanted to show sub-segments as well as the total side by side all in one sheet? Let's do an example: Connect to superstore sample data and but segment on columns. Sales goes on Text. Add "Totals" from the Analytics pane This is... Continue Reading →
Centered dashboards
Here is a quickie on dashboards. Ever encountered that your published workbooks just don't center? Try publishing them with dashboards only selected. Do not publish individual worksheets in addition. For unknown reasons this will cause Tableau to left align instead of center. if you only publish dashboards all will center. That's it. Have a great... Continue Reading →
A quickie on renaming and aliases
In many cases your data source will provide you with rather technical column names, be it dimension or measures. Or, you are usually fine with the naming but for a specific table or chart you just need that slightly changed name label to make it even clearer for your audience. Now what usually you would... Continue Reading →
A Quickie on bar chart labelling
For today I have a quick tip on creating a specific labelling for bar charts. This has come out of Workout Wednesday 2021 Week 44. Usually, labels are either at the end of the bar chart (automatic / right), at the end but inside the bar (left) or inside centered (center alignment). But what if... Continue Reading →
Tableau Adventurer 