from(bucket: "beta")
|> range(start: -1y)
|> filter(fn: (r) => r._measurement == "pageview")
|> filter(fn: (r) => r._field == "page")
|> window(every: 1h) // Time windows of 1 hour
|> group(columns: ["_start", "_value"]) // Group by time window start and page
|> count(column: "_field")
Currently, I have this. In the table view, it does display the groups properly, and the count per group, but I’m not sure how to add a time field to this. Here’s what I’m trying to do.
06:00:00 “/gallery” 5
06:00:00 “/home” 3
07:00:00 “/gallery” 2
07:00:00 “/home” 1
08:00:00 “/gallery” 22
08:00:00 “/home” 5
Right now, it just shows this.
