Time periods in Tableau

Version 1

    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:

    • Today
    • Yesterday
    • 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

     

    Cheers

    Mark