extend TimeScale | ThingSpeak API | Forum

Avatar

Please consider registering
Guest

Search

— Forum Scope —






— Match —





— Forum Options —





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

Register Lost password?
sp_Feed sp_TopicIcon
extend TimeScale
Avatar
kipk
New Member
Forum Posts: 3
sp_UserOfflineSmall Offline
1
March 1, 2016 - 5:45 am
sp_Permalink sp_Print

Hi

With an update each 15sec, the timescale parameters seems a bit limited.

Would be nice to have it completly dynamic and not limited to some values ( actual is 10, 20, ... 720..).
this would allow me to generate graph with different time range always using the same "resolution" by adjusting dynamically the timescale to export the same volume of data.
If it's not possible, could you add 1 mn and 5mn to the timescale ( & even a bit more if you can ).

Thanks.

Avatar
kipk
New Member
Forum Posts: 3
sp_UserOfflineSmall Offline
2
March 1, 2016 - 5:52 am
sp_Permalink sp_Print

ho another thing, when exporting using timescale parameter, it starts to jump from first value. The problem with that is you always miss the last fresh value then.
Using timescale should timescale from the last values to the first. Missing the first one is mostly less important than the last fresh data.

This also solve some charts api display problem like generating highstock with highchart.js. Missing last data can makes important gaps on the chart navigator bar at loading, and cause nav issue.

Avatar
kipk
New Member
Forum Posts: 3
sp_UserOfflineSmall Offline
3
March 7, 2016 - 11:14 am
sp_Permalink sp_Print sp_EditHistory

I hope some TeamSpeak guy will pass here.

I've found a more important issue.
I was wondering why I couldn't get like one month of field data using timescale to preserve bandwidth.
Whatever the TimeScale parameter I use, it only gives me 34 hours of last data ( one data each 15 )
It seems the Timescale filtering is applied after the export limit. Laugh

I mean, if you have like 2 102 400 entries in your channel corresponding at sensors updating each 15sec for a year, and you want to grab this year of data with a timescale of 1440, this should gives 1460 entries. Far better than grabing the 2102400 just for generating a year graph.
But you can't because it will filter the last limited entries (looks to be 8000 ) giving only 5 result ( 8000/1440)

There's no sense of having a timescale parameter capable of 1440 if the source data is filtered before to the last 8000 entries.
It should work the other way, first it filters data with timescale from your database, then if there's more than the limit, only deliver the last 8000..

This looks more a bug than a feature, or have I missed something ?

Any input from ThingSpeak devs?

Thanks

Avatar
schlaubstar
New Member
Forum Posts: 1
sp_UserOfflineSmall Offline
4
January 18, 2018 - 2:25 am
sp_Permalink sp_Print

I would like to push this issue - as I encountered the same problem.

It's a real pain and API bug that should be fixed.

A simple setup (i assume 1 month has 30 days in average)

- log data for a year in a 15 Min interval.
- try to query a range of one year => you will be limited to 8000 points (8000 points / 96 points[per day]/30 days[per month] = 2.7 months, instead of a year)
- try the logical consequence: reduce the interval to 60 mins (which should give you: 8000 / 24 / 30 = 11.1 months, almost a year)

The real result however is, that you will get the datapoints within a 2.7 months timespan but a lower resolution. So changing the interval parameter does not help you at all to change the length of a plottable timespan.

Could you please have a look at this issue as this heavily limits the useability ?

Avatar
Vinod

Forum Posts: 189
sp_UserOfflineSmall Offline
5
January 18, 2018 - 9:31 am
sp_Permalink sp_Print

We'll look into this and get back on this thread.

Forum Timezone: America/New_York

Most Users Ever Online: 114

Currently Online:
32 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

rw950431: 252

Vinod: 164

cstapels: 96

piajola: 75

vespapierre: 63

Adarsh_Murthy: 59

Newest Members:

aogomaeqaza

ureomug

itixuwidouzuv

eilimir

memozupi

isejfujajku

Forum Stats:

Groups: 4

Forums: 17

Topics: 1313

Posts: 4565

 

Member Stats:

Guest Posters: 1

Members: 5703

Moderators: 0

Admins: 2

Administrators: Hans, lee