4 Replies Latest reply on May 20, 2016 12:53 PM by Mahfooj Khan

    help with ifference between multiple dates - unique situation

    ryan otto

      good day all - i have been running through forums / google all day and cannot figure this out!

       

      i have attached a photo of what i have

       

      as you can see, i have a list of serial numbers in one column, then in the next column i have the date of last service.

      what i need to do is add a 3rd column that tells me the days between each service based on the serial number.

       

      i have used: DATEDIFF('day', LOOKUP(MIN([service date]), -1),LOOKUP(MIN([service date]), 0))

       

      it does not seem to work properly - i have boxed in red some entries that do not seem right.

       

      i am fairly new to tableau and am happy for any help i can get.