I’m trying to sum up all of my datapoints to a single datapoint, but when I do that every 5 minutes, it shows a huge spike which is throwing everything off and I can’t track it down.
For example, if I graph each individual datapoint:
perSecond(sumSeries(sumSeriesWithWildcards(grep(pdns.dns.auth.{udp,tcp}-queries, ‘.dns.’))))
I get this graph:
If I combine them with:
perSecond(sumSeriesWithWildcards(grep(pdns.dns.auth.{udp,tcp}-queries, ‘.dns.’)))
I get:
(You may need to click on https://i.imgur.com/yDLeaL8.png see the whole picture)
Am I doing this wrong? I want the 40+ datapoints to be added into a single datapoint so I can do simple alerting based on it. What’s weird is every other minute shows proper values, but every 5 minutes, it has this really big spike which throws everything off.
2023-07-18 18:45:30 27281635
2023-07-18 18:46:00 14461
2023-07-18 18:46:30 14696
2023-07-18 18:47:00 14126
2023-07-18 18:47:30 16063
2023-07-18 18:48:00 15094
2023-07-18 18:48:30 14829
2023-07-18 18:49:00 13006
2023-07-18 18:49:30 14260
2023-07-18 18:50:00
2023-07-18 18:50:30 640253
2023-07-18 18:51:00 13744
2023-07-18 18:51:30 15564
2023-07-18 18:52:00 13829