In today's question we will be answering how we can keep the returned results limited to a defined/definable number of rows. That means for example if we say we want only 200 rows to be returned but we have four different segments then each segment should only hold 50 results. If we increase to 300... 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 →
Diagonal running sums in a table – 2nd edition (and why it is actually window sums)
Misunderstandings happen all over the place and Tableau and it's Forums are no exception to that rule. Specifically when referring to my last blog entry on the above matter, the provided data was so simplified that my resulting understanding turned out to be wrong. What the user wanted was not - as I had deduced... Continue Reading →
Diagonal running sums in a table
Hi there. In today's episode of "everything table calc" we will be having a look at how to compute a diagonal running_sum in a table in Tableau. Though in honesty the use case isn't really clear to me the fact that someone on the Tableau forums asked precisely this question is an indication that their... Continue Reading →
Summing profit & loss whilst maintaining stock value for balance sheet with a single day slider filter
Being a finance guy by background, this question from the forums got me straight away. The request was to find a solution where a single value slider (this is important) filter could be used on a daily basis but when the "All" function was used, it should only sum up the values for the profit... Continue Reading →
Rapid Dashboarding: 5 step process to dashboard success
Sometimes the best you can do is quote someone who did it all so well. So here we go, a great blog post from Julie Laux on fast (or rapid) dashboarding. 100% worth a read.
Filling the gaps – three levels of difficulty
Forums are most fun when a question really makes you think. For today’s blog post, we will be revisiting a question that asked how a table with missing values, i.e. nulls, could be filled not with the preceeding value but with the following value. Also, there can be multiple instances of null values in succession. For this exercise, however, we will be going through three levels of difficulty to gradually evolve our understanding.
A quickie on nested table calculations
When speaking about table calculations a repeated request is to show ranking over time based on for example cumulative sales. Usually, the question will be why what the asker is doing does not work as intended. Lets have a look at the most common reason.
Workout Wednesday – 20201 | W21
I thought it was time to deliver on what the blog is promising, i.e. to from time to time provide solutions on Workout Wednesday Challenges and this time we will be looking at an - by now - older challenge dating back to week 21 of 2021.
A Sunday quickie – Tip on collapsing sheets in a container
One thing that you may have stumbled upon is when you are trying to swap a sheet that is text only. In this case, the text only sheet will not entirely collapse. Let's quickly dive into how to solve that.
Tableau Adventurer 