Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want to create an indicator for the following scenario:
If "Start Time" value is between a range in the previous row (Range = Start Time to End Time) then I want to mark this record with value "1".
For example, look at ObjectID 3796578:
It's start time is on 22/12/2019 8:27:10, which is between the previous row range ( 22/12/2019 8:27:00 - 22/12/2019 8:27:14)
How this can be done within the script?
Thanks.
hi
assuming your table is sorted in the right order
than you should be able to use something like this
if([Start Time] >= previous([Start Time]) and [Start Time] <= previous([End Time]),1,0) as Flag
hi
assuming your table is sorted in the right order
than you should be able to use something like this
if([Start Time] >= previous([Start Time]) and [Start Time] <= previous([End Time]),1,0) as Flag
Thanks!!! @lironbaram