Energy per Day / flux query question

[MichaelMMS]

Hello,

I want to use the new implemented enery total data in flux with grafana. So i can see the energy per day in a bar chart. My query works but I have the use the flux group function. This group command returns a lot of columns, so the labels in grafana do not work anymore (see picture)

I need to get two columns with the properties in one column within a array.

My query:

import "timezone"
option location = timezone.location(name: "Europe/Berlin")

from(bucket: "rct")
|> range(start: -4d, stop: 0d)
|> filter(fn: (r) => r["_measurement"] == "raw_data" and r["_field"] == "value_float")
|> filter(fn: (r) => r["name"] == "energy.e_dc_total[0]")
|> window(every: 1d)
|> last()
|> group()
|> difference()

You can't use the aggregateWindow (which keeps lables working) because you will get the last day doubled and date shifted. Any idea to use the group command and get the lables working?

[MichaelMMS]

So, I use prometheus and it works like that:

Query A in Grafana: delta(rctmon_energy_solar_generator_sum[1d] offset -1d)

Query B in Grafana: delta(rctmon_energy_household_sum[1d] offset -1d)