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

The ThingSpeak community site has been upgraded to a new site. This site is currently in read-only mode. You can ask questions or post and read discussions on the new site.

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

April 8, 2019
9:08 pm

finnbear

Silver

Members

Forum Posts: 5

Member Since:
April 8, 2019

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

cstapels

Moderator

Members

Moderators

Forum Posts: 885

Member Since:
March 7, 2017

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

finnbear

Silver

Members

Forum Posts: 5

Member Since:
April 8, 2019

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

cstapels

Moderator

Members

Moderators

Forum Posts: 885

Member Since:
March 7, 2017

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:
23 Guest(s)

Currently Browsing this Page:
1 Guest(s)