4 Replies Latest reply on Apr 1, 2020 3:03 AM by Steve Wood

    I need help constructing a calculated field that calculates time between two dates but has a condition built into it

    Keith Richmond

      I need help constructing a calculated field that calculates time between two dates but has a condition built into it. As you can see from the attached sample data, the "Spoken Key: Spoken Key" field shows a single value of "HBKKNR" but as you can see there are multiple rows because this data tracks the history of this record.

       

      What I am trying to do is look at the "Old Value" column and find the first instance of "Proofs Sent to Client" for this particular spoken key based on the "Edit Date" field (in this sample data that would be 1/13/2020). Once that date is identified I would then like to look at the "New Value" column and find the last instance of "Client Approved" for this particular spoken key based on the "Edit Date" field (in this sample data that would be 1/27/2020).

       

      Is something like this possible in Tableau?