Blog

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 2

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 A bit about the order of operations – Part 1

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 Maintaining relative values in a tooltip

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 Highlight and zoom to a point on a map but do not filter

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 Quickie on combining index and sub totals