How can we improve the PI Server?

Filter expression for inputs to a Rollup

As a user configuring a Rollup analysis, I want to be able to apply a filter expression on the inputs so that the Rollup only includes inputs that satisfy a condition.

Note: This was previously Enhancement 114349.

58 votes
Sign in Sign in with OSIsoft
Signed in as (Sign out)

We’ll send you updates on this idea

AdminTodd Brown (Product Manager, OSIsoft) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

6 comments

Sign in Sign in with OSIsoft
Signed in as (Sign out)
Submitting...
  • evan.crawford commented  ·   ·  Flag as inappropriate

    As touched upon by volljm below, I would extend this to ensure that System Explorer analysis configuration has most of the functionality that PI Datalink has. This makes it easier for power users to migrate to a PI admin role.

  • jacques.vosloo commented  ·   ·  Flag as inappropriate

    I find this useful as well, but would like to request if string concatenation could also be included?

  • Frank Walsh commented  ·   ·  Flag as inappropriate

    Encountered a similar case :: user was was trying to rollup the Volume (Attribute, PITag) of separate Tanks (Elements) that had variable content types (Attribute, PITag). Since the tank content is changing, the fairly simple conditional sum of Tank Volume required ACE code.

  • Brad.Anderson commented  ·   ·  Flag as inappropriate

    This would be very helpful trying to totalize/manage various liquor inventories in a kraft pulp mill liquor cycle.

  • volljm commented  ·   ·  Flag as inappropriate

    agreed . . . one of PIAF's biggest short comings in comparison to Excel Datalink is not having an easy, intuitive way to do any of the calculation functions with a filter. I understand it can be done with multiple analyses, but that approach gets messy with all the extra outputs and analyses that are simply intermediate values.

  • gougd commented  ·   ·  Flag as inappropriate

    We need a mean to be able to filter an expression on a condition like: "what is the average load on a motor for the last hour only when it is running".

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