2 Replies Latest reply on Aug 5, 2017 11:21 PM by Dmitry Chirkov

    Tableau "Today()" Function

    Gerald Lucey

      Hello,

       

      I have a brief question about the relative date functions in Tableau.

       

      Within a packaged workbook saved locally on one's computer, will the date returned by Today() automatically update each day? Or must the workbook be refreshed before the date that Today() returns will update?

      If a filter is utilized to have only Today() selected, can filter automatically update each day so that the view dynamically responds to temporal changes?

       

      Thank you!

        • 1. Re: Tableau "Today()" Function
          Dmitry Chirkov

          All relative date functions in Tableau are handled in a very special manner (read with care and love) so yes, TODAY() will always be evaluated at the viz rendering time. Even more, calculations based on TODAY() will also be recalculated so if you have something like YEAR(TODAY()) it'll do extra work every time you open workbook.

           

          For the second part, I don't think it is currently possible to have only TODAY() selected on the filter. For that I'd recommend using relative datetime filter and configure it to select "last 1 day".

           

          -Dmitry

          2 of 2 people found this helpful
          • 2. Re: Tableau "Today()" Function
            Dmitry Chirkov

            Might be of interest: https://www.dataplusscience.com/TableauTips10.html, tip #5

            Another new feature in Tableau 10.3 that will be super handy. You can now filter based on the most recent discrete date. This will allow you to have data that can be updated at regular intervals (ex. daily or monthly) and your visualization will now open with the filter set to the most recent day in the data. Click on a discrete date filter and select the checkbox for "Filter to latest date value when workbook is opened".