Over my Christmas Holiday's I finally had a little bit of time to go back to practicing a bit / playing around with Workout Wednesday challenges and since I had't done so in a long time, there were plenty for me. Week 47 by Erica Hughes asked us to provide a solution to a three... Continue Reading →
How To select preceding periods with broken time ranges or cross year using sets.
Assume you have been tasked with creating an option for your users to freely select any (monthly) time period. This period shall be compared not to the previous year but to the preceding months. Example: Your user select Jan, Feb and March 2024, then your preceding periods would be Oct, Nov and Dec 2023. The... Continue Reading →
An easy way to limit set selection
For today we shall have a look at an easy way to limit the number of selections like in this example. Create the sets First, start by right clicking Customers and select "create --> set". Select all customers and name it [SET - All customers]. Next, do the same again but this time don't select... Continue Reading →
Filter a table w/o filtering
For this month's posting we will have a look at how to enable your users to "filter" columns from a text table without actually filtering it. Why would that be needed? Well one idea could be that you have one of these massive tables (you know, the ones you do not want to built but... Continue Reading →
Using a SET to Filter “and” condition
Recently on the forums a user asked how they could use a filter that was conditioned to imply "and" instead of "or" (factually I think Tableau translates any multi-select as an "in" clause like "where xyz in (....)" ). So, what did the user want to do? The requirement Let's have a look to better... 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 →
Tableau Adventurer 