AnsweredAssumed Answered

Flagging duplicate values in AF analysis

Question asked by Idris on May 18, 2017
Latest reply on May 19, 2017 by tmcmanus

Hi All,

 

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!

Outcomes