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.
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?