Usually, when using toggles, we refer to using parameters. However, it is also possible to create a toggle using a dimension and its two members (two because a toggle is either on or off, true or false, 1 or 0, A or B - or, you would have to "make it two" by whatever logic... Continue Reading →
How to do a count distinct over a rolling window
Recently a user on the forums asked how a distinct count over a rolling window could be done. Easy, you might say at first. Just use countd() and all be good. And that is true - and it is not. The problem we are facing here is that the usual countd() combined with say a... Continue Reading →
Creating a filterable year-over-year Waterfall Chart with multiple measures using internal data densification
For today I have something hopefully interesting for many. A Waterfall chart is a quite common type of chart whenever we look at financial data but obviously can be used in many regards. In any case, it always does the same: it explains how we come from a starting reference to an end value by... Continue Reading →
Changing date granularity based on filter (!) selection
For today I have an interesting one. Let's assume we are faced with a request where the circumstances allow you to show a maximum of twelve bars in your chart. Reason isn't relevant, let's just stick with that as a prerequisite. At the same time, you are tasked to provide the most conclusive yet granular... 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 →
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 →
Tableau Adventurer 