Hello,

Is there a way to calculate the maximum value less than xxxx over a period of time?

I have few tags that show some outlier values as shown below, I want to find the maximum value over time filtering out the outliers. I tried datalink using the maximum value in the calculated data function, I added the filter expression 'Mytag' < 15000 which I thought it will leave out the outliers but that didn't work. The function is still returning the outlier value.

Any Idea how I could get what I'm looking for?

Thanks,

Oscar

Maybe the Advanced Calculated Data function could help you in this case. I haven't got a working PI System here to play with, but, based on the example available on the documentation of the function in the Live Library, I would try something like this:

=PIAdvCalcExpDat("IF 'Mytag' < 15000 THEN 'Mytag' ELSE NoOutput()","y","t", ,"maximum", "event-weighted","compressed", ,50,1,4,)