New functions for analysis

You can use the array functions, i.e. recordedvalues(), map() and count(), that were introduced with the AF 2018 release to perform countif().

Would love to have a Cubic Spline function in PI Analysis

Asset Analytics runs on a schedule. In its very core, it's either triggered by new input values (event triggered) or by time (periodic). In all case, the behavior is that calculations are triggered in real time, i.e. as time moves ahead, you would either get a new input value or the wall clock changes. Thus, it's important to remember that Asset Analytics was built to be a "streaming" calculation engine and not as an adhoc calculator. While I know what Cubic Spline does, I would like to know in your opinion whether a Cubic Spine function fits the mold of a streaming calculation engine. For example, would you want to calculate a Cubic Spline for every new input values? I would love to hear more about your specific use case.

In response to Stephen Kwan, "Asset Analytics runs on a schedule.  In ..." Hi Stephen   My goal is to build a real-time distillation profile with the cubic spline trace above my actual profile within a PI Vision custom control. I've already built the Vision control which can display the distillation curve, and now want to add to the control a second cubic spline trace for the same x-axis attribute points.   Current Vision Control:   Goal:     regards, Andrew

In response to Stephen Kwan, "Asset Analytics runs on a schedule.  In ..." thinking about it now, I could probably build the cubic spline into the javascript within my control. Would still be nice though to have Analytics output it to PI attributes/tags

We have some customer requests every year to implement calculations relying on iteration to reach the final numbers, and - as always, we either say no or suggest custom applications. I hope we could be able to use for/while loops in expressions in the future, as it would give AF Analyses that extra functionality allowing us to solve "everything" OOTB. A combination of user-defined functions and looping would really make the analysis service "next level".