Hi,
A daft question. I have 2 Influx time series results:
SELECT mean(“consumption”) FROM “consumption” WHERE timeFilter GROUP BY time(__interval) fill(previous)
This gives me energy usage used.
and also
SELECT last(“rate”) FROM “rates” WHERE timeFilter GROUP BY time(__interval) fill(previous)
This gives me cost at each data point.
Is it possible to multiple the 1st result/series with that of the 2nd series.
Perhaps I can use some of the new features of Grafana 7?
Many thanks!
