hello, I want to find the first record: the value is 1 and lasted 24 hours, like my picture： in obs 1,the value is 1 and the record after 24h is obs 4，but between these two records is a record with AVALCN=0,so obs 1 is N; in obs 2 ,the value is 1 and the record after 24h is obs 5，but between these two records is a record with AVALCN=0,so obs 2 is N; in obs 3,AVALCN=0 ,,so obs 2 is N; in obs 4,,the value is 1 and the record after 24h is obs 6，the value between these two records is 1 ,so obs 4 is Y; in obs 5,the value is 1 ，no records were obtained after 24h,so obs 5 is N;
... View more
