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

    date time difference continuous

    george.gousios

      Hello,

       

      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.