Help needed with average/median/etc. using wrong number of data points | General | Forum

Avatar

Please consider registering
Guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

— Forum Scope —






— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed sp_TopicIcon
Help needed with average/median/etc. using wrong number of data points
No permission to create posts
April 8, 2019
9:08 pm
Avatar
finnbear

Silver
Members
Forum Posts: 5
Member Since:
April 8, 2019
sp_UserOfflineSmall Offline

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

Confused

April 9, 2019
11:17 am
Avatar
cstapels
Moderator
Members


Moderators
Forum Posts: 730
Member Since:
March 7, 2017
sp_UserOfflineSmall Offline

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

April 10, 2019
1:16 pm
Avatar
finnbear

Silver
Members
Forum Posts: 5
Member Since:
April 8, 2019
sp_UserOfflineSmall Offline

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. Confused

April 11, 2019
1:09 pm
Avatar
cstapels
Moderator
Members


Moderators
Forum Posts: 730
Member Since:
March 7, 2017
sp_UserOfflineSmall Offline

I think I spoke too quickly - it was red but may have been the lighter color that means it isn't triggered. My apologies for the confusion. Seems to be white now.
Let us know if you get the averaging to work out how you like.

Forum Timezone: America/New_York

Most Users Ever Online: 166

Currently Online:
28 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:

aaceitunog01, AlinaCutle, MARTO, simplicity1, jango6954, LDN001

Moderators: cstapels: 460

Administrators: Hans: 405, lee: 457