Negative number of Wind Chill

[MksRasp]

we are getting negative number, is it expected result? or there is something wrong in the database (img :22jun2021.png) we run: weectl database calc-missing --date=2021-06-22 weectl database rebuild-daily --from=2021-06-21 --to=2021-06-23

but it did not make any different on results we are including csv file (file :22jun2021.csv) for that peroid of the database, there are some NULL (Blank in CSV file) in the database. is it possible to make weewx-wxobs ignore such negative numbers and display blank instead. 22jun2021.csv

[glennmckechnie]

It's a dud value. 0 degrees.

1624328100,1,5,,,,,,,,,,,,0,,,,,,

The timestamp doesn't convert for me (different timezones) but it's the only zero I can see.

Your database values are in degrees F and you are displaying in degrees C.

0 degrees F converts to -17.77778 degrees C

Being the only value in that whole archive entry suggests it doesn't belong there.

[glennmckechnie]

Actually. I take that back. I'm miscounting fields.

wxobs uses the averaging functions within the sql database so from that point of view I can't check the maths, but then you aren't averaging - it's the actual values.

wxobs can show every archive entry by setting skin.conf values. It would be helpful to see what it sees for the those entries. You appear to be using a 5 minute / 300 sec interval so within skin.conf set ... _displayinterval = 300 You also have it set for single values (measured) already so leave it at that.

That should display every value over that archive period.

[MksRasp]

We tried these numbers for display_interval 300 600 900 1800 on 300 the negative numbers are the most and it is the least on the 1800

with this setting 3600 the negative numbers are gone. the image below made it more puzzling and we are looking at the wind speed with suspicion.

[glennmckechnie]

This would be easier with the actual database. You up to sending it? If so my email address can be found in the wxobs files. skin.conf has it in the top section.