Hi there! I’m running Grafana V7 with influxDB V1.8. Trying to do some math inside the query to show power factor of an energy installation. These are the variable I currently have:

Real Power = P =“shellyem-BXXXX” = ‘shellies/shellyem-B9FXXX/emeter/0/power’

Reactive Power = Q = “shellyem-BXXXX” = ‘shellies/shellyem-B9FXXX/emeter/0/reactive_power’

By combining these two variables I can get the power factor using the power triangle,

```
Power Factor = cos (Φ) = P / S = P / sqrt (P^2 + Q^2)
where S^2 = P^2 + Q^2; S = sqrt(P^2 + Q^2)
```

This is an example of two queries that show Real Power and Reactive Power:

`SELECT mean("value") FROM "mqtt_consumer" WHERE ("shellyem-BXXXX" = 'shellies/shellyem-B9FXXX/emeter/0/power') AND $timeFilter GROUP BY time(1m) fill(null)`

`SELECT mean("value") FROM "mqtt_consumer" WHERE ("shellyem-BXXXX" = 'shellies/shellyem-B9FXXX/emeter/0/reactive_power') AND $timeFilter GROUP BY time(1m) fill(null)`

How do I combine these two queries (P & Q) to perform the following operation; P / sqrt (P^2 + Q^2) = Power Factor. Is it possible with a Query?

Thanks in advance for your support!