How can we improve the PI Server?

Event-Weighted Summary Functions

Allow for Asset Analytics to support event-weighted summary functions (as opposed to time-weighted), such as average and count. This will allow for easily aggregating changes in digital tags, discrete sensor readings (e.g., bucket count), etc. This would allow Asset Analytics to easily perform many of the event-weighted functions of PI Totalizers.

69 votes
Sign in
Signed in as (Sign out)

We’ll send you updates on this idea

John McGraw shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

7 comments

Sign in
Signed in as (Sign out)
Submitting...
  • Tom Hosea commented  ·   ·  Flag as inappropriate

    I believe this request is slated to be included in AF 2018 R2. The original request is: Event-Weighted Summary Functions – User Feedback for OSIsoft Products

  • kbobeck commented  ·   ·  Flag as inappropriate

    Something like Excel's CountIf() would be incredibly helpful. It gets excessive always having to do workarounds or add additional tags to support a calculation. If you don't have an EA, that's not always feasible.

  • volljm commented  ·   ·  Flag as inappropriate

    The original idea doesn't seem to specifically address Totalizing. Tagtot is a time weighted function. There is not an equivalent event-weighted function . . . this seems like a big gap in capability

  • Brent Bregenzer commented  ·   ·  Flag as inappropriate

    This could be applied to any of the standard statistical functions (TagMean, TagMax, etc.). For example a moving average over the last 20 sample values rather over the last 20 minutes.

  • Kelsey Duffy commented  ·   ·  Flag as inappropriate

    TagMean does event weighted, but there's no way to get an event weighted total for example. The workaround is to multiply the tagmean by the event count, but even that is not a good workaround because bad values will not affect tagmean but will affect event count, so they need to be handled before the calculation is performed.

  • halla commented  ·   ·  Flag as inappropriate

    Is this not the purpose of the TagMean() function?
    TagAvg() will perform a time-weighted average whereas TagMean() should perform an event-weighted average. I haven't verified but this is my assumption.

Feedback and Knowledge Base

Posted ideas will have one of the following statuses.
Full definition of these statuses can be found on the Home Page.
No status
NEEDS MORE DISCUSSION
RESEARCHING/EVALUATING
DECLINED
PLANNED
STARTED/IN DEVELOPMENT
IN BETA
COMPLETED