I am using derivative to calculate the delta between two samples. This calculates the bytes/sec. However I want to display the B/s per subscriber. I tried to divide by a field that shows the number of subscribers but Grafana doesnt like it.
SELECT (derivative(“downlinkBytes”, 5m))/“defaultbearersActive” FROM “apnstatistics” WHERE “apn” =~ /^$APN$/ AND “host” =~ /^$GGSN$/ AND $timeFilter