Stats over stats with Graphana and ES

Hi All,

I know this is a somewhat general question, but I hope you can help me figure out how to create a certain graph, presumably with Grafana and ES, but if you have any other ideas, I’d be glad to know.

I have an ES index with documents that represent system events. I want to be able to visualize the “noisiness” of the event streams by showing a graph of the average count of events in a certain period of time (let’s say an hour), divided by the standard deviation of the same (or actually by stddev+1). To do that, I have to count the number of events in a shorter period of time (let’s say 5 minutes) and then calculate the average and stddev over the (12 in our example) sub-divisions of each hour and eventually, display a single metric for each hour with avg/(stddev+1).

So is there a simple way (or any way at all) to do this with Graphana and the ES data source?

Many thanks,

Oren