Aggregation per hour - only want to display full hour

Fluxlang
1

Hi Community, I am using the below code:

from(bucket: "fabian")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "Sensoren")
  |> filter(fn: (r) => r["_field"] == "Temperature")
  |> filter(fn: (r) => r["Sensor-ID"] =~ /^${Sensor:regex}$/)
  |> aggregateWindow(every: 1h, fn: max, createEmpty: false)
  |> yield(name: "max")

Outcome looks like this:

image
image706×152 23.1 KB

The top entry is changing constantly with Dashboard refresh Iw ould like to see only full hours? how to achieve?

2

Hi @github-ps1304

This should eliminate the current hour:

import "date"

endHour = date.truncate(t: -1h, unit: 1h)

from(bucket: "fabian")
|> range(start: -3h, stop: endHour)
3

Thanks @grant1 will give it a try. Does it work with other periods as well eg: week , month etc.?

4

Yes, it should work with other time periods.

5

If the data is large, do we need to add months and hours as tags to speed up query time?