Event Dime

GUI Last agg function

Community & CultureParades & CivicsCommunity & Culture / Parades & Civics
AI signals
CasualGeneral PublicIndigenous/NativePublic
When:
June 30, 2026 · 2:39 AM
Where:
Metabase Discussion
Source:
Metabase Discussion

No, the Metabase query builder doesn’t support FIRST()/LAST() window functions. Write the query as a native query and you can call them, if your database engine supports it. One workaround is to create a custom column with a constant 1 value, order the table how you want it, then create a cumulative sum of that constant 1 column, which creates a row number. Then create a filter node selecting the max value of that row number custom column.

Indigenous/NativeCasualGeneral PublicPublic

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

    Community & Culture, Parades & Civics, Community & Culture / Parades & Civics

  • Signals

    Indigenous/Native, Casual, General Public, Public