You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The airquality_urban producer has a bunch of negative values polluting its PM10_PT1H_avg hourly aggregation, and those seem to randomly pull the average to the negative, and while I don't any direct evidence of this, even when the average doesn't go negative, those random negative values probably induce a systematic error to the data available to the consumers of the endpoint.
It seems pretty obvious, that when you count up from zero, you can never go negative.
Please fix the averaging query so that it doesn't include negative values at all when it calculates the average for an hour.
... and please fix the sensors and the integration between the sensors and the master data, to handle errors and uncertainties better.
The text was updated successfully, but these errors were encountered:
mikaelhg
changed the title
Please document the significance of negative values from the timeseries endpoint for count-from-zero observations
Document the significance of negative values from the timeseries endpoint for count-from-zero observations
Jul 1, 2023
mikaelhg
changed the title
Document the significance of negative values from the timeseries endpoint for count-from-zero observations
Document the significance of negative values for count-from-zero observations
Jul 1, 2023
The
airquality_urban
producer has a bunch of negative values polluting itsPM10_PT1H_avg
hourly aggregation, and those seem to randomly pull the average to the negative, and while I don't any direct evidence of this, even when the average doesn't go negative, those random negative values probably induce a systematic error to the data available to the consumers of the endpoint.It seems pretty obvious, that when you count up from zero, you can never go negative.
Please fix the averaging query so that it doesn't include negative values at all when it calculates the average for an hour.
... and please fix the sensors and the integration between the sensors and the master data, to handle errors and uncertainties better.
The text was updated successfully, but these errors were encountered: