Count day over xTemp | store it | Telegram it

Hello

i would like to count days this happen.
The Part to get the data und send a basic Telegram works, but i would like to have more, but don't know what path to go. This are two example.

Tn20GT = Tropennacht = Tropical night
beween 18:00 - 06:00 Tmin ≥ 20 °C

TX25GE = Sommertag = Summer Day
Tmax ≥ 25 °C

Storage in a InfluxDB 1.8 for the longer future!

sending Telegram like

TX25GE = Sommertag = Summer Day
Tmax ≥ 25 °C

2021 (3 Days) 12.06 / 20.06
2020 (4 Days) 27.06 / 25.08
2019 (7 Days) 15.06 / 15.08
year; how many time happens; first in the year / last in the year

so at the end i would get my own statistics about wheater.

have a nice day
vinc

Are you already sorting storing the raw data in influx? If so then you should be able to get the answer by querying the data in influx.

[Edit] Corrected typo.

@Colin
thanks for your feedback!
yes i do have some datas aproximatly 6 Month - i wish to copy them into a new dp but can't find information how to do it.

influxDB 1.8x

source would be
DB-Name db433Mhz
measurements average

neue DB
DB-Name spez_temp_day

into a new measurement temperatur
no measurements now

thanks for a feedback
vinc

Sorry, I don't understand what you are asking.

If I were trying to solve the question you originally asked I would save all the temperature samples into influx with each sample including a tag indicating whether day or night (in order to simplify the query later). Then you can query for the data you want by grouping over 1 day intervals, selecting the maximum of daily day temperatures and the minimum of daily night temperatures, and use the influx COUNT function to determine the answer. Query separately for each year to get the specific answers you want.

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.