Graph averaging over a period of time

[hah2930]

Hello,

I am measuring latency and packet loss to some targets. The rention-shchema that I have stores the results every 1 second for 7 days and the data is displayed nicely in Grafana. When I run a query to display results for 24 hours, the graph seems averaging out the data and does not display the actual values. This becomes an issue when trying to see historical data to find out how many times did the target report latency over 100ms.

Here is an example:

The following graph shows the data for 24 hours and the latency spike for little under 80ms is seen.

If I drill down, I can see that the latency was actually around 200ms not around 80ms

Is there a way to see the actual reading over larger time window than to see some sort of an average?

Thanks!
Haseeb.

[hah2930]

Any guidance would be much appreciated.

Thanks again.

[daniellee]

Are you using Graphite? Then read this explanation on how to write your query to be able to zoom out and show accurate results:

Y Axis values change depending on time range

It appears that you have a series that is being stored every minute, and every now and then the value stored is incremented by one. On the “zoomed in” graph, you have a period of roughly 5 hours or 300 minutes, so graphite returns 300 points at one-minute intervals and you get the graph you expect. When you zoom out, you’re now looking at a period of roughly 24 hours or 1200 minutes. Grafana can’t show more points than you have pixels on the graph (in this case roughly 1000) so with every req…