Skip to main content

With the aggregation tool I set up a minimum for 24 hours of a given data set. Is it possible to set this minimum value for a certain time range. And I get peaks between my 24 hour minimum values. I don't understand where they come from and would like to remove them from my graph because these are not minimum values. 

We had a short meeting to take a closer look at the questions and to better understand the context. The goal is to create a new tag that shows the daily minimum process value of the flow, which can then also be monitored. This approach is also explained in more detail in an existing community article.

Step 1 is to create an aggregation using the minimum operator over 24 hours.

Step 2 involves a formula that uses the TM_day_time zone tag and the aggregation from step 1:

if(and(a<>b,b=c), AGGREGATION_1, if(and(a=b,b<>c), AGGREGATION_2, sqrt(-1))).

Mapping of variables:

  • a = TM_day* shifted by +1s

  • b = TM_day*

  • c = TM_day* shifted by -1s

  • AGGREGATION_1 = aggregation from step 1

  • AGGREGATION_2 = aggregation from step 1 shifted by 23h59m59s

This setup is valid when using FORWARD aggregation.

If you are using BACKWARD aggregation, the time shifts need to be adjusted:

  • AGGREGATION_1 should be shifted by -23h59m59s

  • AGGREGATION_2 should be shifted by -1s

The result will be the same: the new formula tag will display the minimum daily flow as a step-shaped tag for each day.

Reply


Terms & ConditionsCookie settings