Grafana influx2 flux query group by time

[limbachd]

Dear Community,

I try to visualize my energy Data per day in a Table.

the current day is unfortunately displayed twice in the column “Day, Tag” and is therefore not summed up correctly.

Below my query and the result.

Apologize, if there is a same topic in here. I was not able to find a solution.

Happy to get some ideas.

[alexandrearmand]

hello ,
are you aware you are using

spread() returns the difference between the minimum and maximum values in a specified column.

As aggregate function.
you should able to use fn : sum it’s seems better to display watt consumption over time, isn’t it ?
maybe mean function usefull too

aggregateWindow() function | Flux Documentation