Inconsistent data from Graphite when changing timeframes to 6+ hours

  • What Grafana version and what operating system are you using?
    9.4.7 running in a docker on Ubuntu, and Graphite 1.1.8

  • What are you trying to achieve?
    Show a movingSum of a metric for multiple nodes. I have X devices sending data and a metric and follows how many data messages each device sent. I want to sum how many messages each device has sent over the past N minutes (N could be anywhere from 5 to 30 minutes) and show how many devices have sent a number of messages above a certain threshold during those N minutes, indicating they are ‘alive’.

  • How are you trying to achieve it?
    alias(sum(divideSeriesLists(movingSum(removeBelowValue(my.metric, 10), “10minute”), movingSum(my.metric, 10), “10minute”))), “Kafka”)

  • What happened?
    When changing my graph’s timeframe to anything above 6 hours I see results MUCH lower than expected.

  • What did you expect to happen?
    I expected to see 20 devices, as I do when I configure the timeframe to anything 3 hours or lower, but only saw 3 devices. The value displayed in the graph changes based on the timeframe.
    To check if my overly complicated query is the problem, I tried to simply run sum(my.metric) and that has also showed different results for the different timeframes.

I’d greatly appreciate any guidance to help me configure this graph properly!

Hi all,

I’m still struggling with this issue and haven’t found an answer. Any help would be greatly appreciated!