Hi Ahmed,
Thank you for reaching out.
To retrieve data from a ThingSpeak channel, you can refer to the example "Retrieve Recent Data with Its Timestamp" on the MathWorks documentation page: Retrieve Recent Data with Its Timestamp.
Similar to the example provided, you can retrieve data from your ThingSpeak channel. Once you have the data, you can use the 'find(~isnan(data))' function to identify the indices of non-NaN values. Then, you can use these indices to locate the last non-NaN value in the required column.
Here’s a brief outline of the steps:
- Retrieve Data: Use the thingSpeakRead function to read data from your ThingSpeak channel.
- Identify Non-NaN Values: Apply the 'find(~isnan(data))' function to get the indices of non-NaN values.
- Get the Last Non-NaN Value: Use the indices obtained to find the last non-NaN value in the data.
Note that if you want to retrieve the end index for a particular column, you need to use indexing in the data array to specify that particular column.
I hope it helps!
