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 →
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 →
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.
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
Comparing independent table calculation results from different sheets
Just as I had finished my blog on how to transfer results of a table calculation from one sheet to another, a new but related question popped up on the forums. This time, the user wanted to compare two independent rankings. I.e. he did not want to compare on a product level but instead he wanted to compare Rank#1 from Ranking A to Rank#1 from Ranking B etc where both rankings could be based on completely independent filters.
Transferring results of a table calculation as a fixed value into another sheet at the example of a Top N ranking
A returning question on the forums is when users want to take the results of filtered table calculation(s) as a fixed value or value set to another sheet which actually is not possible. In this blog post, we will see three option to do the undoable.
Tableau Adventurer 