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.
@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
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.