Bug in average calc in API read? (Thingspeak)
1 view (last 30 days)
when I request the average data of a feed using the api call, I sometimes get unplausible values. My channel contains one field for special purpose, that is being updated asynchronously. It seems like, when that field contains data (while the others contain NULL), the average calculation is messed up. I believe that the average calculation interprets NULL as 0.
Is this a bug or a feature?
Vinod on 31 Dec 2020
A NULL or non-numeric value in a field is "Not a Number" and will be treated as a zero in the averaging in the implementation on ThingSpeak. Typically when I have seen this to be an issue is when some fields in a channel are updated at different rates than other fields, resulting in the fields having NULLs in them when a value was not specified.
More Answers in the ThingSpeak Community