I was wondering if anyone can let me know of a way to check whether or not a value has repeated in the last 20 minutes or so?
I have an attribute that is supposed to go up from 1 to 300 sequentially. However due to data quality issues, sometimes it goes back an forth.
In the screenshot example below, I'd like analysis to flag True on the red highlighted rows (as the numbers have appeared before).
Then I can use this flag as indicator that the value has repeated.
I have a feeling we will need to use FindEq of some sort but can't really figure out how.
Thanks in advanced!