Date Histogram when only have start and end dates (or duration)?

[twigbranch]

I'd like to plot the number of car trips ongoing on a particular day, every day for the last week. I know the start time and end time of the trips - the trips can last less than a day, or more than a day. Ultimately, I will allow the user to set the interval size (i.e. from every day, to every two days, etc.) and the date range (i.e. from the last week, to the last two weeks, etc.).

It looks like date histogram aggregation might help, but it appears to, in addition to the interval size, take a single date field from which to aggregate into buckets. In my case, as I only have the start and end times, I'd need some way for the histogram aggregator to calculate, based on start and end times, whether a given trip fits into a given interval bucket. Also, a given trip would potentially need to be counted in multiple buckets.

What's the best way to do this?

[colings86 (Colin Goodheart-Smithe)]

You might find the following link helpful for this. It is a very similar use-case:

Display concurrency in data on Kibana

I have fields with start date and duration (seconds) representing start and duration of a phone call. I would like to define concurrency (a number) when the same destination (also a field) is active within the same duration. That is if a ncall starts now for 30 seconds and another call to the same destination starts 15 seconds into the first call, concurrency should be 2 for the remaining 15 seconds. How do I define this in Kibana visualization as a line graph over time?

Specifically this post in the topic, but I recommend reading the whole topic to get context: Display concurrency in data on Kibana - #3 by colings86

[twigbranch]

Beautiful! Thank you very much!