2 Replies Latest reply on Aug 4, 2017 3:03 AM by Vishant Nayak

    How to display previous month

    Vishant Nayak

      Hi Team,

       

      I have each month data snap shot, which have been extracted the 1st week of next month For Ex: July 17 extracted 1st week of Aug 17.The column name is date_extracted shows the date of the August instead of July month.

      When i create the dashboard in tableau, how can I convert / interval to display the previous month in tableau.i.e July month instead of Aug

       

      Through SQL query I use the below.

      SQL query - ( Table Name.Date_Extract  -  Interval '1 Month') as Date_Extract

       

      Please advice, how can i do it in tableau.

       

      Sorry I don't have snap shot or tableau workbook attached