This example shows how to find the mean of data in a ThingSpeak™ channel while ignoring the NaN values.
ThingSpeak channel 12397 contains data from the MathWorks® weather station, located in Natick, Massachusetts. The data is collected once every minute. Fields 3 and 4 contain humidity and temperature data respectively. Read the data over the last day from channel 12397 using the
data = thingSpeakRead(12397,'NumDays',1,'Fields',[3 4],'outputFormat','matrix');
nanmean function returns a matrix of mean values that are computed after removing NaN values.
mean = nanmean(data)
mean = 54.2651 39.8932