Ability to reference time range bucket From: and To: in query/visualisation?

[LeeSyd (Lee)]

I have indexed documents containing a person's "arrivalTime" and "departureTime". What I'd like to show is the number of people in attendance at a given time, so for each bucket, it would display a count of all documents where (arrivalTime <= Bucket From:)
AND
(departureTime does not exist or > Bucket To:)

Is this possible in Kibana? Filters? But how would I reference the bucket time in a filter query?

I'd be looking at implementing in a either a Line chart of Vertical Column chart with Date Histogram X Axis.

Thanks,

Lee

[LeeDr (Lee Drengenberg)]

Hi Lee, can you please check this post and see if it helps you?

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?

Regards,
Lee