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 →
On my own account: Vizzies 2022
Now that TC22 is over I am happy to share that even though (as honestly I did expect) I didn't win I am still humbled by having been nominated for three different awards which in itself is much more I had ever expected. #1 CoE & Server Superstar (I think this was a mistake and... Continue Reading →
Tableau #vizzies award @TC22
Next week Tableau Conference 2022 is up for an in-person as well as online event. Part of that will be the announcement of the '22 #data-fam #vizzies awards. The vizzies awards are community awards that will be granted in 15 different categories. Nominees have been selected by the community throughout the last weeks and now... Continue Reading →
A bit about the order of operations – Part 2
Here is the second and concluding part of the mini series on diving into the order of operations based on workout-wednesday 2022 week 15 challenge by Erica Hughes. In Part 1 we rebuilt the solution that was in the challenge but this time our aim is to avoid using hard-encoding the maximum date or storing... Continue Reading →
A bit about the order of operations – Part 1
Wow, it's been more than a month since I last published something. So it is more than time to get going again. This time, we will do two things: first, revisit workout-wednesday challenge 2022 - Week 15, rebuild it and discuss the challenges related to the order of operations. Then, in Part 2 of this... Continue Reading →
Maintaining relative values in a tooltip
Assume you are creating a chart with some bars on it showing absolute sales and the corresponding percentage of the overall value. So, in sample-superstore terms you have four bars, one for each region. When you hover, you want to show the segments that make up that bar. Like this: As can be seen, the... Continue Reading →
Highlight and zoom to a point on a map but do not filter
Update: Further below you will find that I suggest applying a factor to one of the calculations. This has been identified to be version related. In Tableau 2021.3 (the version I created my file with) using a buffer on the marks layer results in a lesser zoom extend. In 2021.4 this behaviour is not observed... 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 