With Thingspeakread, can you ignore empty datpoints in order to go back further in time?

I have a channel with 8 fields. Fields 1 and 2 get data sent to them every 15 seconds.

I have a timed app that takes an average of the last 5 minutes of data from 1 and 2 and then enters that average into fields 3 and 4.

I have other apps that take longer averages and enters them in the other fields (5,6 and 7,8).

Can I read the data points in fields 3 and 4, ignore empty data, and still return 8000 points of data? All of them with actual data.

I have been using apps to put the averaging data into whole new channels so that there are no blank data points but this seems klunky and wasteful.

Answer 1

[Supraja]

Hello Don,

I understand that you are using 'thingspeakread' function and want to read values of specified data points.

Here is an example from the 'thingspeakread' documentation where only specified date range values are being read. You can use the similar syntax for your code.

[data,timestamps,channelInfo] = thingSpeakRead(12397,Fields=[1 4],...
    DateRange=[datetime(2018,8,9,23,59,01),datetime(2018,8,10,0,02,52)])

For more information, please have a look at the documentation link below:

https://in.mathworks.com/help/thingspeak/thingspeakread.html#:~:text=12397/feed.json%3F%27-,Retrieve%20Data%20from%20a%20Specific%20Date%20Range,-Read%20the%20data

I hope this helps!