Hello,
i have an InfluxDB 2 instance and am storing data like this:
_time _value hostname system username
2023-08-10 15:36:01 1234 host1 PRD mueller
2023-08-10 13:11:01 5541 host1 TST mueller
2023-08-10 11:33:01 1234 host1 PRD mueller
2023-08-09 13:32:01 2234 host1 PRD mueller
2023-08-09 10:46:01 3334 host1 PRD mueller
Now i want a simple graph showing the amount of entries in this measurement per day:
2023-08-10 => 3
2023-08-09 => 2
Currently i try with following flux query:
from(bucket: “v6crashes_temp”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r[“_measurement”] == “crashes”)
|> group()
|> aggregateWindow(every: 1d, fn: count)
|> yield(name: “count”)
As a result i get in Graphana for each day a time of 02:00 added, so 2023-08-12 02:00 is have a value of 3 (but this is already the next day) → is this normal?
Is my query wrong?
Also if i query for last 30 days it is “ok” (with the above +2 hours). but if i query for last 90 days data is missing (see attachments)