5 Replies Latest reply on Mar 2, 2014 6:14 PM by Shawn Wallwork

    How do I trick Tableau into thinking today is yesterday?

    John Munoz

      I have a report that looks at a number of metrics on a month to date basis. I want to replicate my 'month-end' view. Rather t as it appeared at month end. Rather adjust all of my calculated fields to use today()-1 or 2 or 3 or whatever, is there a way to change the date that Tableau references to make it think that today is actually yesterday? For example, I need Tableau to think today is 2/28/2014, not 3/1/2014. I tried changing the data on the server that Tableau is running on, but somehow Tableau still knows it's the 1st and not the 28th.

       

      Thanks.