Search the Community

How can i create a time based condition for a time interval that isnt in the periodic condition tool? In this case i want to calculate a statistic for my signal (an average or max) every 15 minutes. How can i do this?

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. 2. Then, use the 'Within' function in the formula tool to filter the signal to only include samples when the compressor is ON. 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

There are many cases where a moving average needs to be monitored. To create any statistic that is associated with a rolling time frame, first use the periods() function in Formula to create the periodic capsules. A few examples are listed below. Intent Seeq Formula 30 day average every 1 day periods(30d,1d) 24 hour average every 1 hour periods(1d,1h) 30 minute average every 5 minutes periods(30min,5min) The rolling capsules will appear overlapped in the capsules lane. Check the capsules pane to verify that the start times and durations meet your expectations. Once the periodic condition is created, then, use the Signal from Condition tool to calculate the desired "moving" aggregation (average, minimum, maximum, standard deviation, etc.) to any signal. Below is an example of a 30-minute moving average sampled every 5 minutes on the Example Temperature data.