Aggregate into hours of day 0 - 24

Using Grafana 9.2 and Influx 1.8

I am trying to Aggregate my data and display in bar chart 0 - 24.
I have power consumption and I want to simply bucket it - not group by time(1) as that retains the days etc.

My query is this:

Select INTEGRAL(“x”, 60m)/1000.0 from (SELECT mean(“value”) as x FROM “mqtt_consumer” WHERE (“topic” = ‘N/dddddddd/grid/30/Ac/Power’) AND $timeFilter GROUP BY time(1m) fill(previous)) group by time(60m)

My time filter will be last 7 days.
Any way to work this out?