Hello! So to breifly explain the issue, we have a set of data being uploaded to an elastic index on a 1m interval, and when we graph this in grafana using time series graphs and we match the interval it works great. (we have it broken down by a few fields as seen here)

But when we have an interval that is large, the way it queries / graphs the data doesn’t behave how we want it to. We want an average of the number of machines in each status for each interval, but I’m not sure how to do this in grafana / elasticsearch. Here is what the graph currently shows:

which shows a total (not flat) even though the number of total machines is unchanged.

Thanks for any suggestions! and I can clarify if some of my descriptions are unclear.