I'm going to perform a count aggregation on an array field by filtering the values in a range. For example, I have following 3 documents and I want to find out value counts for purchase_date_list that are between 20210101 to now(). The expected result (purchase count between 20210101 - now()) will be that: customer_id: 1, purchase count is: 2 customer_id: 2, purchase count is: 0 customer_id: 3, purchase count is: 1
Can anybody please help with some ideas on how to compose a aggregation query for above request?
Many thanks!
{
customer_id: 1,
purchase_date_list: [
20050101,
20210304,
20211121
]
},
{
customer_id: 2,
purchase_date_list: [
20100301
]
},
{
customer_id: 3,
purchase_date_list: [
20210701
]
}