9 Replies Latest reply on Mar 13, 2015 2:28 PM by Ahamad shaik

    How to create a biweekly week end date using week ending date

    Nicholas Yu

      Hello,

      Anyone know how to create a biweekly report in Tableau? I want all my data look back biweekly; report is from Monday - Sunday.... I'm doing MTD and YTD by making a calculated field that's essentially an the sum of an if statement that runs like: if date is in this month then number else null


      I think i need some calculated filed for biweekly too, but i cannot think of one. Plz help out

       

      E.g.

      Sept 30, 2013 - 10/13/2013

      10/14/2013 - 10/27/2013