Codie- Are you wanting to place the results of all 3 date metrics on a single view? Or is it like 3 filter choices when a user selects for example "Year to Date" pre-calculated filter the view just updates to YTD metrics?
I'm not sure if this approach would work for you, basically you'd create a 3 different views (worksheets) using Relative Date filtering in Tableau
1) Year to Date
2) Rolling 12 Months
3) Rolling 13 Weeks
Once you have these 3 views setup, next step is to create a Sheet Swap Parameter that toggles between the these 3 views. I have created a sample workbook and attached.
Hope this helps.
Sheet Swap_v10.2.twbx 2.3 MB
Hi Steves ,
I have created a video recently on Sheet swap selector , hope it helps !
Please mark the relevant answers as CORRECT & HELPFUL
Thank you both,
I am familiar with Sheet swap in Tableau and this would be an option to show the multiple views, however my question is more towards building a filter from a calculated field to allow multiple time dimensions (R12. YTD and 13W), powering the same visual.