What version of influxdb are you using?
What do you mean by sort/group them to check on which day? The data has a timestamp, no? So don’t you know which day? Or do you mean day of the week? Can you include some more detail around what you’re trying t achieve please? Thank you
Influx 1.8 i use
i temp over 25 is a summerday, i would like to count at the end how many day over 25 i had. When did the fist summerday came when the last.
the same will be with a hotday over 30 degree.
if i measure in one day a couple of time over 25 degree it still should be at the end - one day and not multiple days!
“how the query should be to really show only the count over 1?”
Try a nested query:
select hightemp from (SELECT COUNT(“temp”) as hightemp FROM “temperatur” WHERE
“temp” >=25 GROUP BY time(24h)) where hightemp>1
I’ve not tested that exact query, but I’ve used the general principle in my
own queries, so give it a go and if you get an error message that you can’t
resolve, come back with the detaisl and we can try to help further.
@Pooh just found out i could work, the time just shows the Date so this would be OK, so i don’t have to be fixed to much to the TX25GE but just to the time output.
i think i will have to put it into " INTO clause" and save it as measurment
and in a second query take the sum of this or a fist and last input