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


(Lee) #1

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


(Lee Drengenberg) #2

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

Regards,
Lee


(system) #3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.