I made a simple math expression that multiplies two queries . The price per KWH multiplied by current consumption. Grafana give is a result but it is not the result of the two value muliplicaiton please see snip below

Hi,

Can you send the results of both queries independently, also are both queries using the same units ?

Good Luck

Thanks Walid

The result of both Queries are on the top of the snip

1st query 0.072 the unit is JOD / kWh with is current price this changes 3 times a month based on electricy consumption so in a typical 30 days cycle there is only 3 records. therefore I set the query to “Last”

2nd query value is 424 watts, I devided the result by 1000 to get it in kW therefore the result is 0.424 the result is changing all the time could be every few second, but also set it to “last”

but you asked to get the results independently. I am not sure how to do that?

Hi,

Since you are using the same datasource, why not use the math operator in the query :

Hope it helps.

Good Luck