4 Replies Latest reply on Sep 5, 2013 5:09 AM by SUGANYA SAEE

    Time Dependent Calculated Field

    Patrick Calnan

      Hi,

       

      I have an issue that is very easily solved in the Excel but I cannot find the correct logic when developing a calculated field that is time dependent. I want to see if a unit starts and this is dependent on the previous time period. I have mocked up the issue in the attached Excel file.

       

      =IF(AND(C4=0,C5>0),"Start","")

       

      TimeUnit VolStart/Stop
      00:000
      00:300
      01:00100Start
      01:30120
      02:00100
      02:30200
      03:000
      03:30100Start

       

      I have tried to replicate this in Tableau by creating another column in which I have added time by 30 mins. I have used the following calculated field to no avail.