Display daily values at a certain time

Hi all,

I am collecting runtime data of my heating system with an ESP8266. The uploaded time is reset every day at midnight, so each day starts with 0 minutes. I would like to create a chart that shows the runtime value at 23:59 of each day to allow a comparison of the daily burner runtime. Y-axis should be daily runtime, x-axis date.

Is that possible?

Thanks and best regards,

Markus

[Nicolas B.]

In which format do you save your data? What your data looks like?

[Markus Roedel]

The data is saved as integer in seconds. The diagram shows it in minutes.

https://thingspeak.com/apps/matlab_visualizations/173617?width=1500&height=900

Answer 1

[Christopher Stapels]

Is the field you want to plot the one called "brennerlaufzeit"?

[Markus Roedel]

Yes, correct. It is the runtime of my heating furnace. For my desired plot, the daily maximum of this field should be displayed. As the runtime only grows over the day, the maximum will always be at the end of the day just before the value is reset to 0 at 0:00 hours.