1 Reply Latest reply on Feb 18, 2018 6:29 PM by Zhouyi Zhang

    How to calculate DateDiff for rows where dates are in different rows for same ID

    BHAUSAHEB SHEDBALE

      Hi All,

       

      I have data in different rows for same ID, Dates are in different rows and varies based on Even type, now I want to calculate the Date difference for different eventtype and Date.

      Please let us know how to calculate this in tableau

      E..g Data looks like Below.

       

            

      Sr.NoIDEventypeAuthorEventDateDateDiff
      11000AcceptedXYZ2/10/2018 30 daysReady for Dev - Accepted Dat
      11000DoneXYZ1/12/2018
      11000In FixXYZ1/17/2018
      11000DevelopmentXYZ1/25/2018
      11000Ready for DevXYZ1/10/2018
      21001AcceptedYET2/20/2018 20 Days
      21001DoneYET1/12/2018
      21001In FixYET1/17/2018
      21001Ready for DevYET2/1/2018
      31002AcceptedYET2/12/2018 10 Days
      31002DoneYET2/1/2018
      31002In FixYET2/1/2018
      31002Ready for DevYET2/1/2018