> So even for monthly average temperature I guess I can use sum instead of
wsum.
Well no, because you do not know whether the archive interval for all of
the records is the same. For obs, such as rain, where you are interested in
the absolute sum for each day (or month or year) you use the sum
Thanks. That makes sense. So even for monthly average temperature I guess I
can use sum instead of wsum. I am using wsum for temperature (monthly
average) now and it seems to work fine. It was when I attempted it for rain
that it went all wrong and then i modified the query based on obs_type. I
am
As a general rule if you are working with averages you should be using wsum
and sumtime, but it really depends on what you are calculating. To
understand you need to know what the daily summary wsum field contains and
how it is different to the sum field. I have no idea what the time field
is,
