I'm using metricbeat to push my application metrics to elasticsearch and then visualize it in Kibana. Metricbeat pushes metrics every 10 seconds to elasticsearch. My application is pushing count metric with different labels related to a business use-case. I've a requirement of visualising the increment in this count value between given time interval. This difference can be visualised as total as well as seggregated by label.
In Kibana's Visual Builder, I tried using sum aggregation/ derivative / count but none of them are giving me correct value. Need help regarding this.
NOTE - Another issue in this metric is that the count gets reset to 0 sometimes due to node going down. Is there any way to handle this scenario to give correct difference?