1 Reply Latest reply on Feb 10, 2016 9:32 AM by Shawn Wallwork

    Extract last N days only

    Narasimha Rao

      Hi All,

       

       

      How I can create last 90 days data extract in tableau ? required last 90 days data availability in the  extract. Its give good performance for my dashborad with HIVE data

        • 1. Re: Extract last N days only
          Shawn Wallwork

          Create this calculation:

               [Order Date] >= DATEADD('day', -90, TODAY())

           

          Use it as a filter when you do your extract:

           

          If you put an integer parameter in place of the 90 you can adjust the number of days back. If you're going back you'll have to keep the negative sign front of the parameter.

           

          --Shawn

          1 of 1 people found this helpful