In today's question from the forums the user asks (I want to) select any point on a graph in dashboard [..] and can sheet 11 [then] show all data from the manufacturers that make up that point? The graph on the dashboard was a profitability line chart by months with Category and Sub-Categories on rows.... 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 →
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 →
Tableau Adventurer 