Ever wonder how you might change a Tableau anchor date (see image below) to be dynamic? Fear not, I’ve created a solution which might satisfy those individuals and/or groups who clamor for greater flexibility.
Here are my 3 (yes, just three) steps to Tableau magic:
Step 1: Create (and then show) the following Parameter(s):
- Anchor Date is a Date data type
- Choose Interval is a Integer data type
- Choose Time Segment is a string data type with (Years, Quarters, Months, Weeks)
Step 2: Create Calculation(s)
Step 2.1: Anchor Begin
Step 2.2 Anchor End
Step 2.3 Filter
Step 3: Set it up
The end. You can also see the workbook here.