MATLAB: Thingspeak, Analysing within a channel

Question

Hi Team,

I have a channel with data in field1 to field6. Now I want to use these data points to calculate the values for field 7. But I can't write the data with the exact same timestamp as the values of field1 to field6. I know, I could write the calculated data into a new channel, but I think this is a rather inelegant solution. One workaround is to add one second to the timestamps. But again, I would prefer a cleaner solution. Is there a way to do this properly?

Answer 1

This is by design -- once the data is recorded for a particular timestamp, the datapoint associated with that timestamp is considered immutable. If that restriction was relaxed, someone could go back and re-record a value for a pre-existing timestamp & field combination. Then, one would have trouble to know what was the recorded value, and what was the "derived"/"computed" value.

If you are "deriving" data from a "measured data" channel, the currently recommended solution is to put that derived data in a separate channel.