Sample Header Ad - 728x90

Influxdb and grafana: howto create series that is the sum of two other series

1 vote
1 answer
5345 views
I have these three queries. They show the average upload speed of three different docker containers over time: enter image description here The difference() call is needed, because the data contains cumulative "bytes_sent" values, and it never decreases. Here is an example of the output: enter image description here I would like to create a third series that shows the sum of the above three graphs. If I simply remove the WHERE condition the it won't work: enter image description here The reason for this is that mean() always precedes difference(), and the mean value of these independent cumulative sums is meaningless: enter image description here The correct solution would be to calculate the three difference values and add them together. But I don't know how to do this in grafana? Obviously the very best solution would be to store the differences in the database in the first place. Unfortunately, I'm not the one who is sending the data so I can't do anything about it.
Asked by nagylzs (421 rep)
Apr 13, 2018, 09:33 AM
Last activity: Mar 18, 2023, 12:02 AM