Daily average of a temperature

17 visualizzazioni (ultimi 30 giorni)
Matthias Borremans
Matthias Borremans il 3 Ago 2021
Commentato: colm carmody il 9 Feb 2022
Hi all,
I have a ds18b20 and esp8266 with espeasy which posts a temperature reading to thingspeak every 5 minutes, works without any issue.
I want to have multiple fields to be able to show a daily average. I think this is not possible with espeasy directly so i have to get some workaround with the visualizations. I have the code below to show an average, it outputs a number, but nothing is plotted.
% Read temperature over the past hour from a ThingSpeak channel
readChannelID = 1462749;
TemperatureFieldID = 1;
readAPIKey = '__REDACTED__';
% Get temperature data for the last 60 minutes
[data, timeStamps ] = thingSpeakRead(readChannelID,'Fields',[TemperatureFieldID], 'NumPoints',30,'ReadKey',readAPIKey);
% Calculate the average temperature
avgTemperature = mean(data);
display(avgTemperature,'Average Temperature');
% Plot temperature and timestamp
plot(timeStamps,avgTemperature)
ylabel('temperature (°C)');
  1 Commento
colm carmody
colm carmody il 9 Feb 2022
Did you solve this issue I have the same problem, I can compute the average but not plot it.

Accedi per commentare.

Risposte (2)

Yongjian Feng
Yongjian Feng il 3 Ago 2021
Your avgTemperature is just a scalar, a single point. Maybe you want to plot the data instead?
plot(timeStamps, data)
  10 Commenti
Matthias Borremans
Matthias Borremans il 3 Ago 2021
Could you maybe guide me through the process?
Yongjian Feng
Yongjian Feng il 3 Ago 2021
How about this:
  1. Use a for loop to loop through all the days you want to plot.
  2. Inside the loop, get the temperatures of that particular day, and do an average
  3. append this average to an array, inside the for loop
  4. once the for loop is done, you have an array of averageTemperatures
  5. Plot that array.

Accedi per commentare.


Christopher Stapels
Christopher Stapels il 9 Ago 2021
You can use the pencil icon on the top of the ThingSpeak plot to make the timeScale Daily.
Also, you can write the output from the code above to another ThingSpeak channel. We call that a derived channel.
Instead of 'NumPoints',30,
use 'NumDays', 1.
Use thingSpeakWrite() to write the data to you new channel.
And then use a timecontrol to call that code daily. Then you will have a plot of daily average.
See the getting started tutorial for an example of that workflow.
Also you could create a matlab visualisation that reads many days of data and then use retime() function to calculate the daily avarage and plot it.
I reccomend using 'outputformat','timetable' when you read the data becasue retime works nicely on timetables.

Community

Più risposte nel  ThingSpeak Community

Categorie

Scopri di più su Write Data to Channel in Help Center e File Exchange

Prodotti

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by