Pipeline Practice

Build regional running revenue

Window functions calculate across related documents without collapsing them into one group. Partitioning creates independent regional streams; sorting defines sequence; the window frame decides which preceding values contribute to each result.

For completed orders, number each order within its region by date and calculate running regional revenue. Return `orderId`, `region`, `placedAt`, `regionalOrderNumber`, and `runningRevenue`, ordered by region and date.

Expected result: Nine chronological order records that retain document-level detail while carrying regional running totals.

Example pipeline syntax

[
  { $match: { status: "completed" } },
  { $set: { placedDate: { $dateFromString: { dateString: "$placedAt" } } } }
]