1 Reply Latest reply on Sep 19, 2016 4:54 AM by Andrew Watson

    Including previous values in a calculation

    Zeeshan Hussain

      I have two columns in my SQL database. These are Start time and End time.


      I am currently able to filter out the first start and end time by creating a LOD in a calculated field to find the min date/time for those fields and to then filter on it.


      The calculation I want to perform is a subtraction of the second result from the start time (The second start time of that day) by the end time of the first result that I have filtered out.


      I understand this is somewhat achievable with the use of a 'LOOKUP' function within tables.


      Is there an alternative way to achieve what I am looking for in any other graph in Tableau?


      Thank you.