Chart Average or Median not working | ThingSpeak API | Forum

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.
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
Chart Average or Median not working
No permission to create posts
January 15, 2014
4:56 am
Avatar
turboencabulator

Silver
Members
Forum Posts: 7
Member Since:
January 15, 2014
sp_UserOfflineSmall Offline

Hi,

I can't figure out what I'm doing wrong. If I put any average or median entry into the properties on a chart, the chart returns nothing. When I use the API and put median or average (or any aggregation) I get null in the data.

For example:
http://api.thingspeak.com/channels/9675/feed.json - returns data but
http://api.thingspeak.com/channels/9675/feed.json?average=10 - returns null

Can someone please point me in the right direction.

Thanks

January 15, 2014
11:43 am
Avatar
lee

Admin
Forum Posts: 457
Member Since:
March 14, 2011
sp_UserOfflineSmall Offline

Hi,

You have the URL correct ( http://api.thingspeak.com/channels/9675/feed.json?average=10 ), however the data in your channel is a bit off. You have an extra space after each field entry, for example "16 ". Please input your data without the trailing space (like "16") so that our system can recognize the data as a number rather than a string.

lee

January 16, 2014
2:15 am
Avatar
turboencabulator

Silver
Members
Forum Posts: 7
Member Since:
January 15, 2014
sp_UserOfflineSmall Offline

Thanks, fixed.

Forum Timezone: America/New_York

Most Users Ever Online: 166

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

tran, huldacormier, bogart, estebanmateo93, mikewrite, onlinebusiness

Moderators: cstapels: 460

Administrators: Hans: 405, lee: 457