Hoi I am the newbie in town
need some help by creating my dashboard
I have one graph with 3 time serie. which come from the following queries
SELECT mean(“value”) FROM “Usage-current” WHERE timeFilter GROUP BY time(__interval) fill(null)
SELECT mean(“value”) FROM “Delivery-current” WHERE timeFilter GROUP BY time(__interval) fill(null)
SELECT mean(“value”) FROM “Instant” WHERE timeFilter GROUP BY time(__interval) fill(null)
which results in 3 layer graph
i like to create and extra graph which show the result of the following formula
value = Instant - (Usage-current+ Delivery-Current)
How to get this in a new graph
PS. Instant is the total of my solar pannels
Thanks for the help
Chris