Support $topN and similar accumulators in $group

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Done
    • Priority: Major - P3
    • 2.17.0
    • Affects Version/s: None
    • Component/s: LINQ3
    • None
    • None
    • Fully Compatible
    • None
    • None
    • None
    • None
    • None
    • None

      Downstream Change Summary

      Please see the scope doc and let Query know if any questions

      Description of Linked Ticket

      Epic Summary

      Summary

      Add a $top accumulator that returns an array of expressions evaluated for top n documents according to a given sort order

      Motivation

      One common analytical task is to find the top or bottom n elements in each cohort. For example, we are interested in the 10 best salespeople for each region based on their individual sales, or in the 5 slowest queries issued by a given tenant on each day. This is a generalization of finding the best or worst element.

      Cast of Characters

      • Product Owner: Katya Kamenieva
      • Project Lead: TBD
      • Program Manager: Craig Homa
      • Drivers Contact: TBD

      Documentation

      Scope Document
      Technical Design Document
      Product Description

              Assignee:
              Robert Stam
              Reporter:
              Backlog - Core Eng Program Management Team
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: