Skip to main content
Answer

How to calculate a daily average of a signal with a single result per day?

  • March 5, 2025
  • 4 replies
  • 218 views
yracette
Pioneer
Forum|alt.badge.img+2

I have a temperature signal that updates every minute or so and I want to derive the daily average of the signal.

Trendminer average aggregation gives me a rolling average at each timestamp. What I am after, in this case is a single value per day that represents the average from midnight to midnight the next day. When plotted, this result would show a step change at midnight every day.

This would be the equivalent of a PI-Datalink average calculation over a given time period with a 1 day (1d) time interval)

Is this feasible? 

Best answer by Natasha Neese

Hello ​@yracette,

 

Thank you for your question and interest in TrendMiner!

Yes, it is definitely possible to calculate the daily average that covers the period from midnight to midnight. The aggregation you see in TrendMiner is a rolling average, but for the daily average as you described, we can use a different calculation.

We hosted an advanced webinar on this topic some time ago. The recording is available at the following link, and I will upload the slides here as well. The stepped daily calculation is covered in exercise 1.D.

Additionally, I'd like to point you to a community article that discusses how to calculate averages on an hourly basis, which might also be helpful if you are considering further adjustments.

I hope this helps! Let us know if you have any further questions.

 

Best regards,

Natasha

Yves Racette

4 replies

Natasha Neese
Employee
Forum|alt.badge.img
  • Natasha Neese
  • Employee
  • Answer
  • March 5, 2025

Hello ​@yracette,

 

Thank you for your question and interest in TrendMiner!

Yes, it is definitely possible to calculate the daily average that covers the period from midnight to midnight. The aggregation you see in TrendMiner is a rolling average, but for the daily average as you described, we can use a different calculation.

We hosted an advanced webinar on this topic some time ago. The recording is available at the following link, and I will upload the slides here as well. The stepped daily calculation is covered in exercise 1.D.

Additionally, I'd like to point you to a community article that discusses how to calculate averages on an hourly basis, which might also be helpful if you are considering further adjustments.

I hope this helps! Let us know if you have any further questions.

 

Best regards,

Natasha

1 Attachments
Jef Vanlaer
Usman I.
yracette
yracette
Pioneer
Forum|alt.badge.img+2
  • yracette
  • Author
  • March 5, 2025

Natasha, This is awesome and exactly what I was after. Thank you for the very quick and efficient reply!

Yves Racette
Natasha Neese
Natasha Neese
Employee
Forum|alt.badge.img

You're very welcome! I'm glad to hear that it was exactly what you were looking for. 😊 Don't hesitate to reach out again if you have any more questions. We’re always happy to help!

Natasha Neese
Employee
Forum|alt.badge.img

I have created a Functional Tips & Tricks post for the TrendMiner Community based on your question 😊 

 

Pelinsu

Need help?

Can't find the answer to your question? Create a new topic or file a support ticket.

New to TrendMiner?

Discover our Industrial Analytics platform at www.trendminer.com.

Terms & ConditionsCookie settingsAccessibility statement