5 Replies Latest reply on Mar 6, 2013 9:45 AM by Sarah Gehrke

    Calculating phase duration using dates in Tableau

    Sarah Gehrke

      Hi,

       

      I am trying to calculate how long various phases of a project took. There are many worksteps in the data set. I am using the start date of a work step and the end date of another work step to calculate duration. I haven't been able to figure out how to write a calculation that will compare the dates of the two work steps. The closest I have gotten is calculating end dates with today's date (but that isn't helpful).

       

      For example, how many days did it take to move from USA to FICO (see data set for worksteps)

       

      Any ideas? I have attached a small portion of my data set.

       

      Thank you!!