I have this below collection and I use MongoDB aggregation to acheive an output and trying to merge into another collection.

I have this below collection and I want to use MongoDB aggregation to achieve the following output.

Below are two collections orders and amounts. I have array of lookup data which is to be added using $addFields in orders aggregate pipeline and iterated and get total amount sum from amounts collections.

I am intending on designing a MongoDB Atlas cluster with a typical three node replicaset that are all electable as primary. Then adding in a couple of readonly analytical nodes for offloading heavier query workloads.

I have a data like:

I have a database with data like this:

I have a collection where I store customers with their info from multiple other collections.
I need to organize a document where the yearly info is separated by year, starting from 2020 until the current year (so next year, it will still works).
Then, for each year, I need to perform some checking to get the info/status for each array item.
If the customer checks true for the specific yearly Item, I have to add it’s _id into a sub-array in the resulting query.
Here is a sample of my customers collection:

Having a documents collection ordered by field, I want to group documents by other field but only adjacent documents should be grouped. Like so: