Query Help With Using Math In Selection

Grafana
8

I have Grafana v7.4.3 and also use Influx, and have a similar setup with query A, query B, and query C (which subtracts the results of query B from query A), and it works. Here is what my 3 queries look like:

Query A:
SELECT mean(“PRESENT_VALUE”) FROM “stations” WHERE $timeFilter GROUP BY time(1m) fill(null)

Query B:
SELECT mean(“SETPOINT_VALUE”) FROM “stations” WHERE $timeFilter GROUP BY time(1m) fill(null)

Query C:
SELECT mean(“PRESENT_VALUE”) - mean(“SETPOINT_VALUE”) AS “DIFFERENCE” FROM “stations” WHERE timeFilter GROUP BY time(__interval) fill(null)