Rate function for elasticsearch

General
1

Hi,
I want to use rate function for query elasticsearch data. how to do that?

Any suggestion?

Thanks

2

Is there any way to do rate query for elasticsearch dta source. I would like to calculate network interface rate from raw data posted by metricbeat

3

Hi, did you find a solution?

I’m looking for the same thing.

4

3

Solved this by adding a dummy field for each request I log, where the content is simply the value 1. Then in grafana, I can use the sum aggregator and an inline script that allow me to calculate a rate given a time interval like 5m, where the script is simply value / 605*.

5

Thank you, meanwhile i was able to solve it in another way.

My syslog-ng sends every 10m a message log to graylog with its stats, i then do some processing in graylog to create the fields d_graylog_processed, d_graylog_dropped, etc…

for example d_graylog_processed containers the number of messages that were processed by syslog-ng regarding the graylog destination on the last 10m.

I was able to make it work with sum and derivative.

image
image2556×1239 239 KB

I just added some overrides to hide the sum field and rename the derivative one.

6

great. Thanks for sharing