Jump to content

Aggregating only desired values for a Signal over periodic times

Brian Crandall

Recommended Posts

  • Seeq Team

There are many use cases where the user wants to do an aggregation over a periodic time frame, but only include certain values. For instance, in this example, we aim to calculate the average daily compressor power but only when the compressor is Online.

1. First, use Value Search to identify when the compressor is ON, which in this example is when the compressor power > 0.5 kW.

20190912_Aggregating only desired values 3.png

2. Then, use the 'Within' function in the formula tool to filter the signal to only include samples when the compressor is ON.

20190912_Aggregating only desired values 4.png

3. Create daily condition using either 'Periodic Condition' or 'Formula' Tool. 

4. Finally, use 'Signal from Condition' tool to calculate average daily compressor power when it's ON.


Content Verified MAY2024

Edited by Siti Tay
Simplify the steps and add screenshot for the last step
  • Like 3
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...