I want to calculate a min & max deviation of a parameter but in that i want to consider only those values which are remained deviated for some amount of time.
Lets say i have parameter named 'abc' whose min value is 10 & max value is 30 . If the value of that parameter deviates frequently then i don't want to consider all those values. But if value is deviated & remains deviated for some time say for 30s then & then only i want consider those values for min & max deviation otherwise just ignore rest of the values.
In Excel using DataLink function "PIAdvCalExpDat()" i have calculated all the deviated values but i'm not able to calculate values which are deviated for some time.