Search the Community

There are many cases where a moving average needs to be monitored. To create any statistic that is associated with a sliding 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) Once the periodic condition is created, use Signal from Condition to calculate a moving average, max, min, or other statistic. The sliding capsules will appear overlapped in the capsules lane. Refer to the capsules pane to verify the capsules meet your expectation of start time and duration, then apply the desired "moving" aggregation (average, standard deviation, etc.) to any signal with the Signal from Condition tool. Below shows a moving 30 minute average sampled every 5 minutes on the Example Temperature data.

Currently I am using the Periodic Condition to be able to view average capacities hourly, however I'd like to know if there is a way to obtain these averages every minute. What I am are trying to achieve here is to be able to see the average capacities every minute of our tags and if at the same time this data could be portrayed as a signal so that we can compare the averages with our original signal in one single lane if both are possible together. Thanks again.