Display graph to show the average time spent in a camel route

[pbData (paul)]

Hi,
Currently I am taking logs from a camel application. When we go through a camel route there are several logging statements. Each time we go through that route a breadcrumId(unique identifier) is created and is logged in each of the logging statements. Each log has a time associated with it. I would like to work out the time difference between start and end of the camel route, via the timestamp. Then from this I would like to be able to show a line graph that simply shows the average of these for a time bin.

[LeeDr (Lee Drengenberg)]

Hi Paul,

This is not something very easy to do with Kibana. I think you would have to write some JSON scripting. See this thread for an example;

Display concurrency in data on Kibana

I also tried this but it doesn't remove the field parameter as promised. With the following json input: { "interval":"minute", "script": "start = doc['recordStart'].value; duration = doc['recordDuration'].value; l = []; for (long i = 0; i < duration; i += 60000) { l.add(start + i); }; return l;", "field":null, "lang": "groovy" } I get the following request "aggs": { "2": { "date_histogram": { "field": null, "interval": "minute", "pre_zone": "+02:00", "pre_zone_adjust_large…