Subtract data from a query in grafana V1.4 - using InfluxDB

i want to select balance value returning from the below query

SELECT sum(“errorCount”) /count(“responseTime”) FROM “requestsRaw” WHERE (“requestName” =~ /^$request$/) AND $timeFilter

I have tried this, but getting error

SELECT 1 - sum(“errorCount”) /count(“responseTime”) FROM “requestsRaw” WHERE (“requestName” =~ /^$request$/) AND $timeFilter

Not sure how you do this with influxdb, its query language is very limiting and messy.

Check influxdb docs or the infuxdata community site.

I am using grafana dashboard to display this query, where I am stuck with this. Please help.