This content has been marked as final.
Show 3 replies
-
1. Re: filtering multiple month views with one filter across several views
Deepak RaiOct 25, 2018 4:50 PM (in response to Scott Francis)
We need a workbook to help you fast!!!
-
2. Re: filtering multiple month views with one filter across several views
Scott Francis Oct 26, 2018 6:59 AM (in response to Scott Francis)I cannot share the workbook I'm using due to privacy restrictions. Feel free to use Tableau's Superstore database.
-
3. Re: filtering multiple month views with one filter across several views
Scott Francis Oct 29, 2018 11:46 AM (in response to Scott Francis)This was accomplished by creating two calculated fields which targeted a date parameter that controlled the date(s) being viewed. Below are the calculated fields
- Month Control
- DATETRUNC('month',[-MasterDate]) = DATETRUNC('month',[Month Control])
- Month Control Previous 6
- DATETRUNC('month',[-MasterDate]) <=
- DATETRUNC('month',[Month Control]) AND
- DATETRUNC('month',[-MasterDate]) >=
- DATETRUNC('month',DATEADD('month',-5,[Month Control]))
These were then placed in the Filter window for their respective worksheets and the value accepted as ‘True’. The parameter is then brought into the view and it worked perfectly!!!
- Month Control