AnsweredAssumed Answered

Dataset with filter expression

Question asked by SaraFranco on Mar 1, 2017
Latest reply on Mar 2, 2017 by Asle Frantzen

Hi guys!

 

I'm trying to do a 1 hour moving average with a tag in a dataset with this expression tagavg('TAG','*-1h','*') but i need that the average doesn't take the values greater than 20, so i need something that converts the values bigger than 20 in NoOutput().

 

I tryed to do it in a PE with two tags, one that filter the values with  if TAG < 20 then TAG else NoOutput() then take that tag and put it in the moving average, this works perfectly but only show the values after the creation of the PE, the problem is that i need to analyze values from the past year.

 

Can someone help me? I ran out of ideas.

 

Thanks

Outcomes