Description: Automatic time period calculations using a single parameter date
Tableau Version: 8.3
Original Author: Mark Fraser
A recent query on the forum prompted me to put together the attached (v8.3) where I use a parameter date to drive different time periods on a single sheet.
Time calculations include:
- Week to Date (WTD) (defaults to Monday)
- Month to Date (MTD)
- Quarter to Date (QTD) (Jan-Mar is Q1)
- Year to Date (YTD)
- Year to Date Previous Year
It may not be the most efficient, or best practice, but its how I do it, and I thought I would share
If you have alternative methods, improvements, suggestions etc, feel free to comment!
Also posted in Viz Talk