9:08 pm


Silver
April 8, 2019

I have a sensor that records data every 15 seconds, and I would like to use averaging but the minimum amount of averaging. When I select Average 10, Thingspeak seems to be averaging approximately 40. When I select a higher number of points to average (or median for that matter), Thingspeak seems to use an even higher amount.
Does averaging 10 mean 10 minutes (arbitrary and I don't want) or 10 data points (I want)?
EDIT: I seem to remember that when I used thingspeak a year ago, I didn't have this problem
EDIT 2: Here is the channel with the problem: https://thingspeak.com/channels/752396
11:17 am


Moderators
March 7, 2017

Average 10 means average over 10 minutes. You can see the explanations here (this page wasn't available a year ago):
https://www.mathworks.com/help/thingspeak/channel-chart-settings.html
Please let us know if there is more information missing, you can click the stars at the bottom to leave a comment.
The behavior for averaging has not changed.
I looked at your channel, and the battery voltage seems to be low according to the lamp indicator, but the actual voltage looks decent. Also the fluctuation in temp stopped today. Did you turn the heater off? 🙂
I would recommend creating a MATLAB visualization. You can average over a number of points or a time interval. This example reads for a number of minutes:
https://www.mathworks.com/help/thingspeak/calculate-average-humidity.html
Or this example reads the data as a timetable (recommended) and does some averaging and visualization:
https://www.mathworks.com/help/thingspeak/Use-Area-Plot-to-Compare-Traffic-Data-Sets.html
1:16 pm


Silver
April 8, 2019

Good to know. Thanks for the Matlab suggestion, that would probably work. As for the battery indicator, it is what it says: a "low" battery indicator. It would light up if the graph is in the red. As for the change in fluctuation, I moved the sensor away from right next to the heater (but did not turn it off).
EDIT: Wait, did you mean the batter indicator was on? That shouldn't have happened. Note that it is visible even when it is off, but gets brighter when on.
Most Users Ever Online: 166
Currently Online:
23 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
rw950431: 272
Vinod: 240
piajola: 95
turgo: 70
vespapierre: 63
Adarsh_Murthy: 62
Member Stats:
Guest Posters: 1
Members: 8665
Moderators: 1
Admins: 2
Forum Stats:
Groups: 3
Forums: 14
Topics: 1600
Posts: 5760
Newest Members:
Advantagetreeexperts, laundrydaddyuk, techhhelp5, ken, tran, huldacormierModerators: cstapels: 460
Administrators: Hans: 405, lee: 457