ThingSpeak


Daily Average Calculation seems wrong.

happybono on 27 Oct 2024 (Edited on 27 Oct 2024)
Latest activity Reply by Christopher Stapels on 28 Oct 2024

Hi,
I don't know why really. Why is there seems a difference between daily average that calculated with .csv file that has exported directly from the channel.
and calculation with the ThingSpeak Daily Average API, there is a lot of difference at the moment.
Why does this happens, and how should I fix this issue?
Attached image file is daily average that has been retrived through the API,
And attached excel file is raw data from the channel.
Thank you.
thingspeak.mathworks.com/channels/920137/charts/2?average=daily&bgcolor=%23FFFFFF&color=%233282B8&dynamic=true&results=60&title=PM+10.0+%28미세먼지+μg++%2F+m³%29&type=line
thingspeak.mathworks.com/channels/920137/charts/1?average=daily&bgcolor=%23FFFFFF&color=%233282B8&dynamic=true&results=60&title=PM+2.5+%28초미세먼지+μg++%2F+m³%29&type=line

1 Comment

Christopher Stapels
Christopher Stapels on 28 Oct 2024
Often the issue is the time zone for the calculation. ThingSpeak may be using GMT for the daily calculation.

Tags

No tags entered yet.