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 →
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 →
A quickie on understanding table calculations
It's Christmas, the kids are super tired from the exciting day and I am the only one left awake. What could be a better way to (most likely) conclude the year than to provide another example on table calculations? Today I have nothing new or unexpected, it is just adding to the vast array of... Continue Reading →
Mimicing Excels sumif / Vlookup without data manipulation
Update 23 November: As some have noticed, would it not be easier to just do a window_sum(sum[hour_hours])) and compute that by Answer is: yes. The original question was phrased differently with the user asking to also deduct several values which, in retrospect was not what he wanted. All he wanted was to just sum the... Continue Reading →
Keeping a constant number of returned rows
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 →
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 →
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.
Comparing table calculations in a tooltip
A while ago a user wanted to be able to show in a tooltip the deviations of the running sums of his actuals vs the running sums of several different budgets, depending on which budget the user would hover over
Tableau Adventurer 