This content has been marked as final.
Show 5 replies
-
1. Re: date time difference continuous
Zhouyi ZhangJun 13, 2018 5:57 AM (in response to george.gousios)
1 of 1 people found this helpful -
2. Re: date time difference continuous
george.gousios Jun 13, 2018 6:07 AM (in response to Zhouyi Zhang)Hi Zhouyi Zhang!
Pretty close!
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!
-
3. Re: date time difference continuous
Zhouyi ZhangJun 13, 2018 6:16 AM (in response to george.gousios)
No worries, could you mark my answer as helpful or correct to close the thread? thx
ZZ
-
4. Re: date time difference continuous
george.gousios Jun 13, 2018 6:30 AM (in response to Zhouyi Zhang)Of course! Thanks!
-
5. Re: date time difference continuous
Zhouyi ZhangJun 13, 2018 6:31 AM (in response to george.gousios)
cheers,
ZZ