Bar chart side by side?

[merlin123]

I’m logging several measurements. For each value there are many entries per hour.
Now I want to have a bar chart which shows my the average for each value for one hour, the chat should show e.g. the last 12 hours.

the query looks like this:

from(bucket: “iobroker”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r[“_measurement”] == “0_userdata.0.PV_Produktion”
or r[“_measurement”] == “0_userdata.0.PV_Eigenverbrauch”
or r[“_measurement”] == “0_userdata.0.PV_Netzbezug”
or r[“_measurement”] == “0_userdata.0.PV_Wallbox”
or r[“_measurement”] == “0_userdata.0.PV_Nur_Einspeisung”)
|> filter(fn: (r) => r[“_field”] == “value”)
|> aggregateWindow(every: 1h, fn: mean, createEmpty: false)

The bars for each hour are show at one place. Stacking is set to none. I tried several hints, but I didn’t manage to show the bars side by side.
What is wrong?
Tried it with a new panel, only 2 values, split the query in separate queries etc. Nothing helped

[grant2]

Welcome @merlin123 to the Grafana forum.

In Grafana with your current query, can you toggle the query results to Table View and post a screenshot or two of the results here?

Second, in Influx Data Explorer, can you post some of the results from the same query (CSV or screenshot)?

Also, it is possible you could restructure your data so you have only 1 measurement (call it userdata) and then a tag called “PV” with 5 values (Produktion, Eigenverbrauch, etc.). I created something like this below:

[merlin123]

Grafana:

Influx:

The part with the restructuring I didn’t understand at the moment… I’ll have a closer look at your example and try to figure it out