Combine measurements in single column and show that by day


I have my smart energy meter readings in influxdb. Displaying that data - as is - works fine and gives nice usage graphs.

But now i want to:

  1. Combine 2 measurements to obtain a total measurement
  2. Group dat by day so i see a total energy usage by day

I’m having issues with getting both to work.
I can do “time(1d)” in the GROUP BY part of the query, which does group it. But that’s just being grouped on the current time - 24 hours. I want to to group on a full day from 0.00 till 23.59. (or 0 AM til 12 PM for the 12-hour clock folks :slight_smile:)

As for combining measurements. I have no clue how to do that.

What i eventually want to do is have a 3 column table:
1st column: date (not date time) of the day that’s being shown (i don’t know how to do this one either, it’s currently showing a full date + time…)
2nd column: the KWh used for that day
3rd column: the KWh used for that day compered to the week PRIOR.
Then color the cells in column 2 and 3 with 2 colors to easily see if i’m using less energy then the week before. But that’s still a way off as long as i can’t even get grouping working properly :slight_smile:

Btw, this is all displayed in Grafana, just in case you’re wondering where i’m displaying the tables.

Any help would be greatly appreciated!