query-revenue-total

gistfile1.txt

[{
  $match: {
    status: {$ne: "cancelled"},
    createdAt: {$gt: ISODate('2024-03-31')}
  }
},
{
  $group: {
    _id: { day: { $dayOfMonth: "$createdAt"}, year: { $year: "$createdAt" } },
    totalAmount: {$sum: "$revisedOrderTotal"}
  },
},
{
  $sort: {
    "_id.day": 1
  }
},
{
  $project: {
    "_id": 0,
    "date": "$_id.day",
    "year": "$_id.year",
    "totalAmount": 1
  }
}]