5 Replies Latest reply on Mar 2, 2016 12:18 PM by Steve Mayer

    Date Cycle / group date

    Mattia Pradella

      Hi,

      I'm trying to create date cycles in tableau:

      starting from a specific date like the 07/09/14 I'd like to have a single date every 14 days to include all the previous 14. eg:

        

      Day of Shift_DateCycle end date
      7/09/201420/09/2014
      8/09/201420/09/2014
      9/09/201420/09/2014
      10/09/201420/09/2014
      11/09/201420/09/2014
      12/09/201420/09/2014
      13/09/201420/09/2014
      14/09/201420/09/2014
      15/09/201420/09/2014
      16/09/201420/09/2014
      17/09/201420/09/2014
      18/09/201420/09/2014
      19/09/201420/09/2014
      20/09/201420/09/2014
      21/09/20144/10/2014
      22/09/20144/10/2014
      23/09/20144/10/2014
      24/09/20144/10/2014
      25/09/20144/10/2014
      26/09/20144/10/2014
      27/09/20144/10/2014
      28/09/20144/10/2014
      29/09/20144/10/2014
      30/09/20144/10/2014
      1/10/20144/10/2014
      2/10/20144/10/2014
      3/10/20144/10/2014
      4/10/20144/10/2014

       

       

      Any help is much appreciated