1 of 1 people found this helpful
Juan as you've discovered, the issue is when you filter data you make it unavailable to Tableau. So instead of filtering the data we can hide it. In the attached workbook I dropped the QUARTER(Order Date) on the size shelf, and then selected the first three quarters in the size legend, right-clicked and clicked 'Hide' (at the bottom). Then I moved this pill from the size shelf to the Detail shelf, so it wouldn't mess up your viz.
This is fairly manual, but there are ways to 'automate' it depending on how you decide which quarters you want to show/reveal. (Based on what?) Cheers.
Thank you very much for your response Shawn. You're right, it´d be better to hide the information you don´t want to see instead of using a filter, and the way you did it solved manually the problem.
Since this exercise is part of a requirement for a project, it would be necessary to make this process automatically to show either the present quarter we are, or if it's possible, the next three months based on our current date (that would be the ideal scenario). My first thought with this last option was a range of dates to specify that I´d like to see next three months, but that would be using a filter again. Any thoughts?
You can create calculations that use the TODAY() function to determine a T/F result, which is essentially what you seem to be wanting/needing to do. So the 'manual' hide could instead be a 'relative' hide. You still set the calc up manually, but if the calc changes based on TODAY() then you've 'automated' it. Yes?