Hi,

I would like to compine (sum up) the following two queries into one, but I don’t know how.

SELECT mean(“value”) FROM “PowerDcInput” WHERE (“dimension” = ‘DC input power A in W’) AND timeFilter GROUP BY time(__interval) fill(null)

SELECT mean(“value”) FROM “PowerDcInput” WHERE (“dimension” = ‘DC input power B in W’) AND timeFilter GROUP BY time(__interval) fill(null)

I already tested the “Transform | Add field from calculation” option, but my dataset has empty rows and finally I would like to show multiple overlaying graphs.

Regards Andreas

When you tried the Transform approach, was the issue that you have empty rows? In that case you can try `fill(0)`

instead of `fill(null)`

. Presumably since you’re doing a sum, missing values should be treated as zeros.

No, that is not the main problem.

The graph shows me a zero line, although there are no values at the marked times. In the example it is 8 p.m. and the recording only started at 8 a.m.

I would expect something like this with an open start and an open end…

Furthermore I would like to combine/overlay this graph with other graphs.

I guess, combinding the the queries could solve the problem. How can I do it?