Add filters support to AF Summary calculations
PI-DataLink allows for filtering of aggregate calculations, for example to get the average inlet temperature of a compressor when the turbine speed is > 1000 RPM.
This is not possible with AF. The KB01120 article does not work and is very messy and relies on the output to be written to a new PIPoint - which is wasteful on licenses.
AF-SDK filteredSummaries call do work.
It would be best to support this directly within the product. One option might be to add the filter expression to the PIPoint Data Reference conifguration window. As well as providing the time offset, e.g. -1d, which is currently supported - add another text box to put in the filter expression.
Matt Voll commented
i'm not sure i agree with the idea of modifying the pipoint data reference config window . . . but, yes, the inability to do a summarization analysis with a filter expression in a single analysis is a HUGE issue. This type of analysis/calculation is very common in excel/datalink, and while I don't think everything in Excel can be easily done in AF, it is a glaring gap. Especially when training/showing new users the "power" in AF and, to them, it seems like a lot of extra steps to do filtering when they are used to it in a single datalink function.
i'd much rather just see it as an optional arguement field in the existing summarization functions (tagtot, tagmean, tagavg, etc etc)
Brendan Dufresne commented
This could also be done by adding an overload to the analysis summary functions that allows you to specify a filter expression.