Retrieve sum for more than 1440 minutes ? | 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
Retrieve sum for more than 1440 minutes ?
No permission to create posts
December 12, 2013
4:18 am
Avatar
meltsys

Silver
Members
Forum Posts: 17
Member Since:
November 1, 2013
sp_UserOfflineSmall Offline

For example I would retrieve a sum for the past month.

Is there a way to do it ?

December 12, 2013
4:22 pm
Avatar
lee

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

Hi,

Unfortunately our backend doesn't provide the ability to sum more than 1440 minutes, however you can use JavaScript or another programming language to calculate this sum yourself by getting the sums for the past 30 days and adding them together.

lee

December 13, 2013
1:47 am
Avatar
meltsys

Silver
Members
Forum Posts: 17
Member Since:
November 1, 2013
sp_UserOfflineSmall Offline

Hi Lee,

Thanks for your reply.
Do you think If i install thingspeak on a local server It would ne possible ?

Have a nice one

December 13, 2013
12:45 pm
Avatar
lee

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

Hi,

Yes if you install ThingSpeak onto a local server this would definitely be possible. Here's the line you'd have to modify: https://github.com/other/thingspeak/blob/master/app/controllers/feed_controller.rb#L201 .

lee

December 13, 2013
4:02 pm
Avatar
meltsys

Silver
Members
Forum Posts: 17
Member Since:
November 1, 2013
sp_UserOfflineSmall Offline

Thanks again Lee

Thats a good news :)

January 20, 2014
2:17 pm
Avatar
meltsys

Silver
Members
Forum Posts: 17
Member Since:
November 1, 2013
sp_UserOfflineSmall Offline

Hi Lee,
I modified the line you suggested with the new value 43830.
But some month have 30 others 31 days so not the same number of minutes.

Do you have another idea to retrieve a sum for a month ?

Another question, the max result : 8000 is only on thingspeak.com ? If not where I can modify it ?

Many thanks again

Alex

January 21, 2014
12:59 pm
Avatar
lee

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

Hi,

I don't know of an easy way to retrieve the exact sum for a month.

There is no 8000 data point limit on the open source version of ThingSpeak.

lee

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:

tran, huldacormier, bogart, estebanmateo93, mikewrite, onlinebusiness

Moderators: cstapels: 460

Administrators: Hans: 405, lee: 457