Greetings Elastic Stack experts.
I have an index of timestamped events like so (which I have transformed into JSON, but using simple strings here for readability):
ID: 1, name: ABC, time: 111.11, action: start
ID: 2, name: DEF, time: 112.0, action: start
ID: 1, name: , time: 114, action: join
ID: 1, name: ABC, time: 123, action: end
ID: 1, name: ABC, time: 249, action: start
ID: 7, name: XYZ, time: 250.0, action: start
ID: 1, name: , time: 260, action: end
I need to compute elapsed times and join counts for each occurrence of ID: 1, and so on. A summary along these lines would be even better:
ID: 1, name: ABC, start_times: [111.11, 249], end_times: [123, 260], join_times: [114]
Is it possible to do this in Kibana, maybe using a script?
The logstash elapsed filter did not give me I did try the elapsed filter in Logstash but it resulted in some errors due to which I had to manually validate a whole bunch of data.
Any guidance?
Thanks