Is there a way to create a Calculation with an aggregate function that ONLY considers TVQs with Good quality?
I have a calculation that uses this function here (TotalPerMinute('[localhost.Dataset.Power22]', '5m')), however whenever there is a non Good value withing the 5 minutes the result of this ends up with Quality Uncertain, is there a way to to make it so that the function only considers Good values and skips over Bad or Uncertain values so that the result of the function always has Good quality?
1 reply
-
Hi ,
You would either have to create a prerequisite calc that filters out the Bad/Uncertain qualities before passing it into the TotalPerMinute function, or you can simply override the quality output of the calc you have now. You could force the output to always be Good or use a conditional statement to maybe just override Uncertain qualities.
If you haven't downloaded the CalculationsExport from here (https://helpcenter.canarylabs.com/t/g9yfymb/available-functions-of-the-calculation-server-version-25) and imported it into a test system, there is a How To Override Quality calc that illustrates a few examples.
Print this page