Hi Zhouyi Zhang!
Because I have timestamps which differ by 1 minute , so the result should be a continuous vector with the value 60.
So I changed your field to :
(AVG(DATEDIFF('second',[Start Date],[Timestamp])) -
LOOKUP(AVG(DATEDIFF('second',[Start Date],[Timestamp])), -1))
although I am not using the End Date and I am not sure how it is working!
and it works fine.
Thanks for the help!
No worries, could you mark my answer as helpful or correct to close the thread? thx
Of course! Thanks!