Event Dime

Window functions in query builder tool

Events
When:
June 4, 2026 · 2:49 PM
Where:
Metabase Discussion
Source:
Metabase Discussion

You can’t explicitly request window functions from the query builder, but it will use them for certain aggregate functions (the cumulative ones). For row numbers you can use cumulative sum on a constant ‘1’ column to generate them. You can also define a Model that uses window functions to generate columns then process the results from the query builder.

Why this event appears here

This listing is shown because it is tied to the current city coverage and carries structured metadata that can be indexed and compared with other events.

  • City coverage

    Chicago, IL

  • Primary source

    Metabase Discussion

  • Categories

    Events