5 Replies Latest reply on Jun 13, 2018 6:31 AM by Zhouyi Zhang

    date time difference continuous




      I have created start and end date parameters.

      I want to calculate the difference in seconds between two subsequent rows.I want it to be a continuous measure.


      I want something like that:


      (AVG(DATEDIFF('second',[Start Date],[End Date])) - LOOKUP(AVG(DATEDIFF('second',[Start Date],[End Date])), -1))


      but it gives me zero of course because datediff gives only one number.