Graphing out hourly values into daily values

Hello all, I currently have a graph where I hourly send a value of counts. I want to be able to view these hourly on the graph like I already do but also group up all of the values into daily values so the graph would show the same data per hour as it would per day just adding the sum of the values within the 24h period together. Any ideas as to how I could do this effectively?

A query of your data with

|> aggregateWindow(every: 1d, fn: sum)

should do the job.

Something like that:

data= bucket
 |> range()
 |> filter()

by_hour |> yield(name:"byhour")
by_day |> aggregateWindow(every: 1d, fn: sum) |>  yield(name:"byhour")
1 Like