Do you have any suggestion regarding how to make an easy math for diskio writes + diskio reads = and to have a total iops?
It seems that there will be a progress.
opened 02:55PM - 14 Apr 16 UTC
closed 12:05PM - 12 Nov 20 UTC
type/feature-request
datasource/InfluxDB
help wanted
prio/low
area/datasource
Currently, Grafana (2.6) supports math functionality with the field on the left … side within the InfluxDB query builder. I.e. it can build queries like
```
SELECT mean("field") / 100 AS "field" FROM "measurement" WHERE "tag" = 'value' AND $timeFilter GROUP BY time($interval) fill(null)
```
It would be nice to also have support for math with fields on both sides, for example something like
```
SELECT mean("field1") + mean("field2") + mean("field3") AS "field" FROM "measurement" WHERE "tag" = 'value' AND $timeFilter GROUP BY time($interval) fill(null)
```
SELECT MEAN(usage_system) + MEAN(usage_user) AS avg
FROM cpu
WHERE time > now() - 10s
GROUP BY host;
It’s not supported by Grafana GUI editor yet (but you can write it in manual mode).
What I’ve tried to achieve is that the:
Total IOPs per reads;
Total IOPs per writes;
Sum of Total IOPs (reads) + Total IOPs (writes) = Total IOPs per that VM.