My apologies in advance if title of this topic is obscure, and I am not using right nomenclature. I am quite new to Kibana...
Using Kibana 5.4
I have in ElasticSearch some data, representing some type of events.
Each event contains two date-type fields: 'start' and 'end'.
The content of 'start' is also the content of '@timestamp'.
Let's say that an event is 'active' between its 'start' and 'end' times.
I would like to create a Date Histogram, where each bin (or is it called bucket?) contains the total number of events that were active during that period of time. In other words, if the Nth bin goes from time t_N to time t_N+1, it should contains the number of events that
- start < t_N+1
- end > t_N
Is this doable?
Thanks a lot in advance.