Date Range aggregation on date_range field

I have a set of documents with date range. I want to get schedule with in specific duration.

For example, following are 2 events.

  1. Event 1 - from 10th to 20th
  2. Event 2 - from 15th to 25th

Get schedule from 1st to 30th. Expecting following output.

  1. Date 10th to 14th - Event 1
  2. Date 15th to 20th - Event 1 and Event 2
  3. Date 21st to 25th - Event 2

Please suggest how can i achieve this.

Currently there are no aggregations that work on range fields. There is an issue open to add this which you can track here:

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