Thingspeak channel has fields with different sample rates - what is best way to deal with this?

Question

Steven Grobler 2023-6-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1990108-thingspeak-channel-has-fields-with-different-sample-rates-what-is-best-way-to-deal-with-this

评论： Steven Grobler 2023-8-29

Some fields come in to a channel from a device at intervals of 5 minutes, whilst others come in from another device at intervals of 15 minutes. The channel (consisting of several fields) has only one time stamp array. When data comes from different devices and/or at different rates, this gets messy. Lots of timestamps have no data for some fields, which makes processing more difficult and it also limits how much data can be read - eg the 8000 data point limit means you can't read as much real data as you could for a slow channel if it had its own slow timestamp - instead it has the fast timestamp and lots of wasted "empty" readings.

Ideally it would be nice if each field (or each group of fields from one device) would have their own timestamp. Are there any methods or tricks to deal with this issue?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Chetan 2023-8-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1990108-thingspeak-channel-has-fields-with-different-sample-rates-what-is-best-way-to-deal-with-this#answer_1293597

Hi Steven!!

As per as my understanding you are dealing with multiple fields coming from multiple devices at different rates.

There are several methods and tricks that can be used to address the issue:

Interpolation: Use interpolation techniques to estimate values between known timestamps for fields that have different arrival rates.
Resampling: Resample the data from different devices to a common time based by selecting a specific time interval and adjusting the data to fit within that interval.
Time Alignment: Shift the timestamps of one device to align with the timestamps of another device based on a known time difference between them.
Separate Timestamp Arrays: Modify the data acquisition process to include separate timestamps for each field or group of fields from one device.

You can refer the following article for more info & sample code:

Hope it helps!

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Steven Grobler 2023-8-29

I did not pose my question very well, but thanks for answering. All of those things can be done to data that is downloaded from Thingspeak, but I was looking for a way of it happening inside thingspeak so it did not have to be done after downloading.

This article below describes a way of doing what I wanted to do, but it requires the interpolated data to be written to another Thingspeak channel, so not ideal if you don't have lots of spare channels.

https://au.mathworks.com/help/thingspeak/regularize-irregularly-sampled-data.html

请先登录，再进行评论。