For today just a small tip on how to align your parameter changes and filters to all become effective on clicking the same button, like here: How to do this Parameters in Tableau allow the user to provide single values to their workbook. This feature enables interactivity in dashboards. It also allows for the dynamic... Continue Reading →
Automatically set a date picker parameter to Sunday
This is a question that recently came up and my solution to this is quite simple. Assume you have an empty date parameter, that is a parameter of "date" type with no limitations like this: This will enable your users to click it and be greeted with a calendar style date picker w/o any further... 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 →
Summing grand totals from different sheets
For today I have a 'how-to' regarding summing up the gross totals from two different calculations on two sheets with different filters (possibly) applied. Assume your first sheet looks like this. I have randomly filtered to ship date years 2021 to 2023. and the second one like this, filtered based on order date (=2021). Also,... Continue Reading →
A bit about the order of operations – Part 1
Wow, it's been more than a month since I last published something. So it is more than time to get going again. This time, we will do two things: first, revisit workout-wednesday challenge 2022 - Week 15, rebuild it and discuss the challenges related to the order of operations. Then, in Part 2 of this... Continue Reading →
Maintaining relative values in a tooltip
Assume you are creating a chart with some bars on it showing absolute sales and the corresponding percentage of the overall value. So, in sample-superstore terms you have four bars, one for each region. When you hover, you want to show the segments that make up that bar. Like this: As can be seen, the... Continue Reading →
Show ALL Details for underlying data points (that are not even in the view yet)
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
Tableau Adventurer 